View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr BT Mr BT is offline
external usenet poster
 
Posts: 12
Default can vb from excel launch another program?

We have a batch file that will read a file, and with a couple of keystrokes
of <ENTER a delimited text file is created.


Would there be a way I could run the batch file (i think its converter.bat)
from a vb script in excel, maybe sendkey the ENTER strokes? Then i would use
my (already made) script that opens the end resulting txt file and clean it
up of some unwanted characters.

Would this be possible at all?

Thank you for reading and answering

Mr BT