Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are there command line parameters for Excel? | Excel Discussion (Misc queries) | |||
Complete list of Excel Command line switches/parameters | Excel Programming | |||
Command line parameters to Excel | Excel Programming | |||
passing parameters from command line | Excel Programming | |||
Command line parameters into a macro | Excel Programming |