Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel filename command line parameter to VB
I'd like to execute a macro in Excel automatically using a
VB .exe file. I can do that, but would like to have the VB file be generic so that it can just receive the specific Excel file's name as a command line parameter. Can someone show me how to receive that, in VB? An example of which portion of the code starts to use it? I don't think I'm wording this well... sorry. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel filename command line parameter to VB
Mark,
In you program read the parameters using the "Command" function. Sub Main() Dim sParam As String sParam = Command() MsgBox "The parameters a " & sParam End Sub If you pass more than one parameter, e.g. myProj param1, param2, then you can parse it to separate it out. -- HTH RP "mark" wrote in message ... I'd like to execute a macro in Excel automatically using a VB .exe file. I can do that, but would like to have the VB file be generic so that it can just receive the specific Excel file's name as a command line parameter. Can someone show me how to receive that, in VB? An example of which portion of the code starts to use it? I don't think I'm wording this well... sorry. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel filename command line parameter to VB
Sub Main()
Dim sParam As String sParam = Command() Thanks, Bob. That's what I needed to know! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First Parameter in INDIRECT command changes if I add new column | Excel Discussion (Misc queries) | |||
What are the possible command-line arguments in Excel? | Excel Discussion (Misc queries) | |||
How to: Pass Command Line Parameter ??? | Excel Worksheet Functions | |||
Command line parameters to Excel | Excel Programming | |||
command line excel to run macros | Excel Programming |