Macro to open another program - shortcut target has a command line switch

[wadergirl]

So, in my spreadsheet, I have an existing macro that uses:

Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe")

So I'm pretty sure that it is the base of what I need to use for this other program, but the other program I need to use a shortcut which has a command line switch in the target filepath that I'm not sure how to include:

"C:\Users\Me\Documents\Program.exe" -switch

It doesn't work as:
Shell ("C:\Users\Me\Documents\Program.exe" -switch)

 

[shknbk2]

You can look HERE for a decent explanation. You would do something like this:

[COLOR=#333333]Shell ("""C:\Users\Me\Documents\Program.exe"" -switch")[/COLOR]

 

[wadergirl]

You can look HERE for a decent explanation. You would do something like this:

[COLOR=#333333]Shell ("""C:\Users\Me\Documents\Program.exe"" -switch")[/COLOR]

Thank you, that works! Unfortunately, I now get an "Unhandled exception has occurred in your application" error when the program opens, "object reference not set to an instance of an object". I can get past it by just clicking "continue" and the program is fine, so I don't know if it's a problem with opening the shortcut from Excel vs. my desktop, but I can live with it.

 

[shknbk2]

You're welcome.

Try removing the parentheses and see if that clears it up. Since you are not setting a variable equal to the return value of the Shell command (which is fine, by the way), Excel doesn't like the parentheses.

 

[wadergirl]

Nevermind! Fixed it! Used:

Call Shell ("""C:\Users\Me\Documents\Program.exe"" -switch")

instead of just

Shell ("""C:\Users\Me\Documents\Program.exe"" -switch")