starting a separate program from Excel
starting a separate program from Excel
(OP)
All,
I would like to create a macro in excel that runs another program using the data from that excel file. It's the running the other program that I don't know how to do. I would be grateful for any thoughts on the matter.
I would like to create a macro in excel that runs another program using the data from that excel file. It's the running the other program that I don't know how to do. I would be grateful for any thoughts on the matter.
Regards,
Qshake
Eng-Tips Forums:Real Solutions for Real Problems Really Quick.





RE: starting a separate program from Excel
In Excel dig around in the ActiveX help, it looks like you might be able to do it from there.
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: starting a separate program from Excel
I did this way back in 1999, opening up Access, searching a database for matching records, then writing a line to the database and opening up Word and performing a mail merge with the data. It was my first ever macro and I managed to pull it off, so it's not that hard!
RE: starting a separate program from Excel
where ShellPath is the full path and program name
TTFN
RE: starting a separate program from Excel
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.