Command Line summoning of a VB function

[F*SH]

Hi all

I'm trying to work out a command-line function (ie shell command) that'll open an Excel spreadsheet and run a macro with arguments. Opening Excel is easy enough, as is opening a specific spreadsheet. There is also a way to run a specific macro within the sheet.

But what stumps me is how to pass arguments. Any ideas? I basically need my spreadsheet (or rather a subroutine in it) to run from a batch file, with a different set of parameters each time.

Cheers!

 

[Norie]

Why do you need to use a batch file?

Can't you use VBA to do what you want?

 

[F*SH]

Design requirement. I say a batch file, I actually lie. Partially. it's a cron job, designed to trigger the code (via a batch file) once a day. We don't want to keep Excel open and a script running all day long so some manner of automated, command-line implementation is sort of needed.

 

[Seti]

Could you store the parameters in a text file of some sort and have the VBA read the values from there?

 

[F*SH]

ADVERTISEMENT

Yeah, I guess that's a possibility. But it seems long winded somehow - I'm pretty sure there must be a way in invoke such a command more easily. Microsoft have been pushing inter-program operability so it would appear strange to me that there is no way to pass arguments from the most basic interface...

 

[cgmojoco]

F*sh

Curious if you worked this out---(Passing arguments)

Also can you post an example of your command line code/technique to get a specific VBA to run?

Thanks!

 

[John_w]

You can do it with VBScript or JScript. See http://www.mrexcel.com/forum/showthread.php?t=302970 for example.

Another example (my posts): http://www.mrexcel.com/forum/showthread.php?t=379181