[AccessD] Unzip Files Part II

DWUTKA at marlow.com DWUTKA at marlow.com
Mon May 2 13:49:08 CDT 2005


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



More information about the AccessD mailing list