Results 1 to 2 of 2
Thread: Working with WinZip (Excel/VBA)
2001-07-10, 12:46 #1
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Working with WinZip (Excel/VBA)
I have two questions about WinZip and MS-Excel/VBA:
1) I would like to know if there is a way to know how many files are zipped into a WinZip archive?
Ideally I would like to provide the user with a list of files to choose from. Currently I count how many .XLS workbooks I have before I use the SHELL command to execute WinZip with the right switches, and then recount the files to find what has changes. This works OK, but it does not take much to break it.
2) How can I tell when the Shell Command has finished.
I know that the SHELL command runs asynchronously, but I am sure there should be an API function to check on a process and detect when its done. Currently I Loop until the number of files in the folder I am unzipping to changes. Again this can break very easily.
Thanks for ALL your help.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
2001-07-10, 13:04 #2
- Join Date
- Mar 2001
- Springfield, Ohio, USA
- Thanked 2 Times in 2 Posts
Re: Working with WinZip (Excel/VBA)
Wassim, Use CreateProcess instead of Shell. See <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q129/7/96.asp>Q129796</A> for details. HTH! --Sam<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
<small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>