Outlook
"Ron de Bruin" wrote in message ...
Do you use Outlook or OE
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Keith" wrote in message m...
Thanks for your help on using the Shell command. That part is
definitely cleared up.
But my other problem is this:
I am doing a FollowHyperlink to download a .zip file. Upon downloading
I would get the pop-up box asking me if I wanted to run the file from
the location or save it. I couldn't figure out how to bypass that
pop-up box with VBA and have it automatically save to a specific
folder, so I decided to click "Save" and I unchecked the box that says
"Always ask this for this type of file" so I wouldn't get that
anymore. And now when I test this code, the .zip file downloads and
opens after downloading (even though I told it to always save). So the
.zip file opens and I see the file that needs to be unzipped. But the
problem is, I would have liked to have specified where to save that
.zip file so that I could easily use Shell. (Remember this is Excel
97.)
Anybody know what I can do?
Thanks....Keith
"Ron de Bruin" wrote in message ...
Try this for unzip test.zip from C:\ to C:\
Sub test()
Shell "c:\program files\winzip\wzunzip c:\test.zip c:\"
End Sub
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Keith" wrote in message ...
I downloaded the WinZip command line add-on from the WinZip website. I
have a macro in EXCEL 97 that downloads a file and when the file is
downloaded, it opens as a zip file.
Two things that I ask:
1. Do I need to do anything in my VBA window to activate the add-on?
2. How can I extract the file (with code) that is inside the zip
window? In looking at other posts I've seen something like...
Shell("C:\whatever path\WZUNZIP.exe bla bla bla")
I put bla bla bla because I have no idea what any of the stuff
following the .exe path means in those posts.
Any ideas? Thanks.