Making a Macro that will run a script at the end

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

satyan - 03 Mar 2008 17:51 GMT

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!

Reply to this Message

Steve Yandl - 03 Mar 2008 20:25 GMT

It would help to know exactly what you mean by 'a command line script'. My
guess is that you have a vbScript file with a vbs file extension that acts
on your csv file. Is that the case?

If you have such a vbs file, you could probably modify it to open the
workbook, save a copy of sheet2 as a csv file and then do its thing. An
alternate approach would be to create a subroutine in your workbook that
does whatever it is the script does.

You can launch a script from VBA but it would help to know how the script
takes arguments and what type file it is.

Steve Yandl

>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
[quoted text clipped - 8 lines]
>
> Thanks in advance for your help!

Reply to this Message