How do I hide a shell command called from VBA in Excel

[Guest]

I am executing the Shell function in a Visual Basic program to validate the
contents of an Excel spreadsheet and transmit the data to a mainframe file
using the Windows FTP command.
I am using the Win32 API documented in the following knowledge base article:
http://support.microsoft.com/kb/129796/EN-US/

The issue is that the user sees the command window open briefly. Does
anyone know of a way to hide the command window?

 

[Jim Rech]

You might try this slight code modification. No promises but it hide the
shelled app for me.

' Initialize the STARTUPINFO structure:
start.cb = Len(start)
start.dwFlags = 1 '<<Add this


--
Jim Rech
Excel MVP
message |I am executing the Shell function in a Visual Basic program to validate the
| contents of an Excel spreadsheet and transmit the data to a mainframe file
| using the Windows FTP command.
| I am using the Win32 API documented in the following knowledge base
article:
| http://support.microsoft.com/kb/129796/EN-US/
|
| The issue is that the user sees the command window open briefly. Does
| anyone know of a way to hide the command window?

 

[Guest]

It worked for me too.
Thank you.