View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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?