You might try this slight code modification. No promises but it hide the
shelled app for me.
' Initialize the STARTUPINFO structu
start.cb = Len(start)
start.dwFlags = 1 '<<Add this
--
Jim Rech
Excel MVP
"Robert Lyriotakis" <Robert
wrote in
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?