[AccessD] Unzip Files Part II

Drew,

Thanks for all the feedback...

I've fought with this more than I've fought with any other function in 
access...guess I've lost the touch......anyway......I finally came up with 
this(had to quit when the test worked)...but I still had to use the SHELL 
command...I 'think'...lol...I used the command line.  Do you think this is 
the best approach(it works but I think I went the long way around)?

Ex:
    Dim test
    test = "C:\Program Files\WinZip\WZUNZIP.EXE C:\Stock\BriterStockFiles\" 
& MyName & " C:\Stock\BriterStockBiHourlyTEMP\"

    Shell (test)

Thanks for the feedback.

Mark A. Matte

PS...Oh yeah...'MyName' equals the file name...thanks...Mark

>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:54:14 -0500
>
>Also, why not just use a *.zip in the winzip command line?  It'll do it all
>for you....
>
>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