Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shell command | Excel Programming | |||
Shell command stopped working: is it part of Excel 95 , or Windows? | Excel Programming | |||
xp shell command using vba | Excel Programming | |||
Writing Command Shell (stdOut) to Excel Cells | Excel Programming | |||
SHELL command | Excel Programming |