Good morning plasma33
So you are trying to download a file, using Excel, and then hand control over to a batch file to unzip it?
It's not going to be possible to hide the batch file window that pops up - you're going to have a hard time to suppress from Excel VBA something that Windows wants to do.
Why not unzip via VBA? Ron de Bruin is the authority on this type of ttechnique, and discusses a number of them here. The bad news is, if you unzip using the default Windows unzipper, you cannot get around the information window. If you can't put up with that you may have to unzip using 7-Zip (free) or WinZip (not free) - but Mr de Bruin will still show you how to do this from within VBA.
HTH
DominicB
Bookmarks