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

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?

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

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?

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

It worked for me too.
Thank you.


"Jim Rech" wrote:

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?