Hide all the tasks happening during the Macro Process!!

Hi Guys,

I want to hide the following tasks that happens in front of the Excel workbook:

1. Hide the file copying process window (from the unzip process) happening in front of the Excel workbook
(###Note: The window for copying process comes up sometimes and sometimes not).. Please find the sample screenshot for it below:
sample_copying_process.png
2. Hide the cmd prompt process window (from the .bat file) happening in front of the Excel workbook

How can we hide the above two tasks and somehow put it behind the workbook.

Part of my full code is given below:

Please Login or Register  to view this content.

Actually cmd prompt process has lot of other tasks in the .bat file. I have only provided some of it.

I have tried using the code below but in vain..it doesn't hide only those two tasks mentioned above:

Please Login or Register  to view this content.

Attached is my .bat file. Please find the link below for it.
https://www.dropbox.com/s/mldghi7ss8...hFile.bat?dl=0

Thanks in advance guys.

Cheers
Plasma33

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

Good Morning, DominicB

Thank you for your kind reply.

I will do what is necessary right away. Thank you for the link.

Cheers
Plasma33