Opening an external application when opening excel file
Posted by Bill Ford on September 16, 2000 11:04 AM
I have an external engine application that provides DDE information to my spreadsheet. It must be opened before the external links are started so that it cqan dump in current stock market info. the app is called "talnet32.exe" and requires about 15 seconds to come up to speed before it will honour DDE requests.
This would be an auto start routine if Excel VBA can call an external app and delay while it starts...any ideas?
Posted by Ivan Moala on September 17, 0100 12:10 AM
Have a look @ online help for Shell and Wait
and probablly AppActivate.....these commands will
do what you require otherwise you could use some
API calls to simulate a Shell & wait.
Post if this doesn;t do it.
Ivan
Posted by Bill Ford on September 19, 0100 3:27 PM
Have a look @ online help for Shell and Wait and probablly AppActivate.....these commands will do what you require otherwise you could use some API calls to simulate a Shell & wait. Post if this doesn;t do it.
------------------====================-------
That did the trick Ivan...much appreciated. BF
