[AccessD] Unzip Files Part II

Mark A Matte markamatte at hotmail.com
Mon May 2 15:19:02 CDT 2005


The code is on a machine at home...but I know there is a DIR call in the 
second function to see if the winzip.exe is there.  I modify when I get 
home.

On your other email...I will also look at the winzip command line.

Thanks,

Mark A. Matte

>From: DWUTKA at marlow.com
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Unzip Files Part II
>Date: Mon, 2 May 2005 13:49:08 -0500
>
>Post your code.  Guessing in the blind, sounds like Function 2 is using the
>Dir function (maybe checking to see if the file exists before
>unzipping....), because that would goof secondary calls to Dir in your 
>first
>function.
>
>Drew
>
>-----Original Message-----
>From: Mark A Matte [mailto:markamatte at hotmail.com]
>Sent: Monday, May 02, 2005 1:30 PM
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Unzip Files Part II
>
>
>Hello All,
>
>I gave up on a command line to use XP's unzip...I bought WINZIP and wrote 2
>functions:
>1.  uses DIR to get all files in a certain folder and loop through until 
>the
>
>end of directory...(works fine)
>2.  shells to winzip and extracts needed files to determined 
>folder...(works
>
>fine)
>
>Then I called function 2 from function 1 as it looped through each
>file...and after the first file was unzipped...the loop determined it was 
>at
>
>the end of of the directory.
>
>Any ideas why this happens?
>
>Unless there are any ideas for a better approach/workaround...I plan on
>movig the DIR inside the loop...and then deleting the .zip file after its
>extracted...then add an IF statement that ends the loop if the DIR returns
>nothing.
>
>Any thoughts/suggestions?
>
>Thanks,
>
>Mark A. Matte
>
>
> >From: DWUTKA at marlow.com
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: accessd at databaseadvisors.com
> >Subject: RE: [AccessD] Unzip Files
> >Date: Thu, 28 Apr 2005 11:14:24 -0500
> >
> >True.  I copy and pasted the code years ago, when I built the original
> >program I am rebuilding.  Nowadays, I tend to make my own 'utility'
> >modules,
> >just for the fun of it....
> >
> >Drew
> >
> >-----Original Message-----
> >From: Gustav Brock [mailto:Gustav at cactus.dk]
> >Sent: Thursday, April 28, 2005 10:24 AM
> >To: accessd at databaseadvisors.com
> >Subject: RE: [AccessD] Unzip Files
> >
> >
> >Hi Drew
> >
> >The major source for these generic functions is the official API
> >specifications and examples.
> >I've seen so many variations on these and it is impossible to tell who
> >included which comments.
> >
> >/gustav
> >
> > >>> DWUTKA at marlow.com 04/28 4:59 pm >>>
> >I don't know, I rarely use other people's code now, and so I prefer not
> >to
> >post someone else's work.  You didn't include the comments I have in
> >my
> >module, which denote the original author.
> >
> >Drew
> >
> >-----Original Message-----
> >From: Gustav Brock [mailto:Gustav at cactus.dk]
> >Sent: Thursday, April 28, 2005 9:49 AM
> >To: accessd at databaseadvisors.com
> >Subject: RE: [AccessD] Unzip Files
> >
> >
> >Hi Drew
> >
> >Since when have you turned into chicken mode?
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com





More information about the AccessD mailing list