Posted to microsoft.public.excel.programming

Robert Lyriotakis Robert Lyriotakis is offline

external usenet poster

Posts: 2

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shell command	MAx	Excel Programming	2	June 4th 04 04:11 PM
Shell command stopped working: is it part of Excel 95 , or Windows?	Charles Jordan	Excel Programming	9	May 4th 04 06:39 AM
xp shell command using vba	Sudhendra	Excel Programming	2	February 16th 04 05:56 AM
Writing Command Shell (stdOut) to Excel Cells	Ryan Waltz	Excel Programming	0	January 28th 04 10:52 PM
SHELL command	Robin Clay[_3_]	Excel Programming	3	October 17th 03 02:50 PM

All times are GMT +1. The time now is 08:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us