View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
satyan satyan is offline
external usenet poster
 
Posts: 1
Default Making a Macro that will run a script at the end

I have data in an excel file which I need to convert into a csv file,
save the csv file, and then run a script from the command line with
the csv file's location as a parameter. It can be the same name
everytime, I just don't know how to go about running a command line
script. Any help would be much appreciated!

(For hte CSV file), I've made it so that Sheet2 in the workbook is
just the data with commas in between, such that I could just copy it
into notepad, save it, and it would work as a CSV file for me. If
there's a better way to do it, I'd be glad to try it.

Thanks in advance for your help!