Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Working with WinZip (Excel/VBA)

    Hi All,

    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>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •