View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trevor[_4_] Trevor[_4_] is offline
external usenet poster
 
Posts: 9
Default Running .BAT file from within a macro...

Hello all,

I am wondering if it is possible to run a .BAT file from
within a macro in excel. Basically, the .BAT
file "creates" the text file that my macro imports. I
want, as the first step in the macro, to run the .BAT file
and then continue with the text import. As it is now, I
have to leave excel, manually run the .BAT file, and then
run the macro to import the text file. Any suggestions
would be greatly appreciated.

Thanks,

Trevor