Bypass Open or Save Dialog Box

[AvGuy]

I want to download a file using the FollowHyperlink method and then bypass Windows' Open or Save Dialog box. Any ideas on how to do this?

AvGuy

 

[AvGuy]

Let me expand on this somewhat vaguely stated question. I want to download an .mdb file that's zipped as a WinZip self extracting (.exe) file. Then I want to extract the file and import data from it.

I can access the file on the net for download using the FollowHyperlink method. Because the file is an .EXE Windows invokes the Open or Save dialog box. I would like to pass the "Open" value to this API so the file will be automatically extracted to the destination set in the WinZip self extractor.

Then I need some way of detecting that the unzip operation has completed. DoEvents doesn't cut it and neither does ShellWait.

Any thoughts or suggestions would be appreciated.

AvGuy