Thread: How do I hide a shell command called from VBA in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Lyriotakis Robert Lyriotakis is offline
external usenet poster
  
Posts: 2
Default 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 QuoteReply With Quote