Reading command line parameters in a VBA program
 

Hallo everybody,

I have an Excel VBA macro that I run several times per day to generate
certain reports. To have this done fully automatic I need to be able
to launch the program with a commandline that looks like
....\ReportGenerator.xls /List=1000 /Date=Today
How can I read the parameter(s) '/List=1000 /Date=Today' in my
program. I find no property that returns this string.

Thanks to anybody who can help me because I've been looking for a
solution for quite some time now.

DQ

Reading command line parameters in a VBA program
 

You can't pass parameters to Excel VBA macros from the command line,
unfortunately. Have you tried putting the parameters in a simple text
file -- or the Windows Registry -- and having your VBA macro read them
from there?

/ Tyla /

On Apr 17, 8:02 am, dq wrote:
Hallo everybody,

I have an Excel VBA macro that I run several times per day to generate
certain reports. To have this done fully automatic I need to be able
to launch the program with a commandline that looks like
...\ReportGenerator.xls /List=1000 /Date=Today
How can I read the parameter(s) '/List=1000 /Date=Today' in my
program. I find no property that returns this string.

Thanks to anybody who can help me because I've been looking for a
solution for quite some time now.

DQ

Reading command line parameters in a VBA program
 

On 17 apr, 17:32, Tyla wrote:
You can't pass parameters to Excel VBA macros from the command line,
unfortunately. Have you tried putting the parameters in a simple text
file -- or the Windows Registry -- and having your VBA macro read them
from there?

/ Tyla /

On Apr 17, 8:02 am, dq wrote:



Hallo everybody,

I have an Excel VBA macro that I run several times per day to generate
certain reports. To have this done fully automatic I need to be able
to launch the program with a commandline that looks like
...\ReportGenerator.xls /List=1000 /Date=Today
How can I read the parameter(s) '/List=1000 /Date=Today' in my
program. I find no property that returns this string.

Thanks to anybody who can help me because I've been looking for a
solution for quite some time now.

DQ- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Hallo Tyla,

That is exactly what I do know: a batch file generates a .reg and
loads it into the registry and then launches the Excel program which
reads it back. But this is such a messy way that I was hoping there
was something in VBA itself.

Thanks anyway.

DQ

Reading command line parameters in a VBA program
 

Bummer, isn't it? Next time I have Bill G. over to lunch, I'll talk to
him about this issue -- one a many I have on my list for him.

/ T /

On Apr 17, 8:40 am, dq wrote:
On 17 apr, wrote:



You can't pass parameters toExcelVBA macros from the command line,
unfortunately. Have you tried putting the parameters in a simple text
file -- or the Windows Registry -- and having your VBA macro read them
from there?

/Tyla/

On Apr 17, 8:02 am, dq wrote:

Hallo everybody,

I have anExcelVBA macro that I run several times per day to generate
certain reports. To have this done fully automatic I need to be able
to launch the program with a commandline that looks like
...\ReportGenerator.xls /List=1000 /Date=Today
How can I read the parameter(s) '/List=1000 /Date=Today' in my
program. I find no property that returns this string.

Thanks to anybody who can help me because I've been looking for a
solution for quite some time now.

DQ- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

HalloTyla,

That is exactly what I do know: a batch file generates a .reg and
loads it into the registry and then launches theExcelprogram which
reads it back. But this is such a messy way that I was hoping there
was something in VBA itself.

Thanks anyway.

DQ

Reading command line parameters in a VBA program
 

You cannot pass command line arguments to a workbook, but you can pass them
to Excel and grab them in an Auto_Open routine:
http://www.dailydoseofexcel.com/arch...uments-in-vba/

Called from Run with something like:
excel c:\book1.xls /e/some/args

I assume would work with ShellExcecute or from a Short Cut.

Having said that, there may be better ways of achieving your goal, possibly
with Automation/VBScript.

NickHK

"dq" wrote in message
oups.com...
On 17 apr, 17:32, Tyla wrote:
You can't pass parameters to Excel VBA macros from the command line,
unfortunately. Have you tried putting the parameters in a simple text
file -- or the Windows Registry -- and having your VBA macro read them
from there?

/ Tyla /

On Apr 17, 8:02 am, dq wrote:



Hallo everybody,

I have an Excel VBA macro that I run several times per day to generate
certain reports. To have this done fully automatic I need to be able
to launch the program with a commandline that looks like
...\ReportGenerator.xls /List=1000 /Date=Today
How can I read the parameter(s) '/List=1000 /Date=Today' in my
program. I find no property that returns this string.

Thanks to anybody who can help me because I've been looking for a
solution for quite some time now.

DQ- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Hallo Tyla,

That is exactly what I do know: a batch file generates a .reg and
loads it into the registry and then launches the Excel program which
reads it back. But this is such a messy way that I was hoping there
was something in VBA itself.

Thanks anyway.

DQ