start a non microsoft program via a macro in excel

[JAJOSEPHESQ]

I was wondering if it is possible to have a macro in excell that would
start another program, ie. QuickBooks. Currently I know that if you
double click on a QuickBooks file, as long as that extension is
associatied as a QuickBooks file, QuickBooks will automatically start
up. So what I am trying to do is have a macro that will in a sense
allow me to double click on my QuickBooks data file and in turn start
up QuickBooks via my macro in Excel.

Thanks for any help at all on this!

Jeff J.

 

[Earl Kiosterud]

Jeff,

Try the Shell function.

Shell "Quickbooks.exe"

Not sure about the program name for Quickbooks. Look at a shortcut that
starts it (in start menu, or on desktop) for that. Right-click it,
Properties.

 

[Chip Pearson]

Jeff,

Try something like

Shell "start " & QuickBooksFileName

where QuickBooksFileName is the name of the QuickBooks file.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com