Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 excel application
there are 2 the number of excel applications. see the below. you must open excel application as below. '''''''''''''''''''''''''''''''''''''''''''' window start menu - run - excel - enter once more,, window start menu - run - excel - enter '''''''''''''''''''''''''''''''''''''''''''' workbook in a first excel name is "controler.xls" workbook in a second excel name is "controled.xls" and then make a button in a worksheet in controler.xls. And press the button and then must be appeared in message box with "controled.xls is opend in the other excel application" please, xl genius @@ *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 excel application
Take a look at this kb article:
http://support.microsoft.com?kbid=138621 tom taol wrote: there are 2 the number of excel applications. see the below. you must open excel application as below. '''''''''''''''''''''''''''''''''''''''''''' window start menu - run - excel - enter once more,, window start menu - run - excel - enter '''''''''''''''''''''''''''''''''''''''''''' workbook in a first excel name is "controler.xls" workbook in a second excel name is "controled.xls" and then make a button in a worksheet in controler.xls. And press the button and then must be appeared in message box with "controled.xls is opend in the other excel application" please, xl genius @@ *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 excel application
Hi Tom,
The only way you can automate an instance of Excel that has been started manually, is to use GetObject() function. Unfortunately, if there are two instances of Excel that were both started manually, GetObject() can connect to only one of them, not both, and there is no way to control which instance it will connect to. I suggest you try to start both instances programmatically, using either early or late binding. Only then can you connect to two separate instances of Excel. Regards, Vic Eldridge "tom taol" wrote: there are 2 the number of excel applications. see the below. you must open excel application as below. '''''''''''''''''''''''''''''''''''''''''''' window start menu - run - excel - enter once more,, window start menu - run - excel - enter '''''''''''''''''''''''''''''''''''''''''''' workbook in a first excel name is "controler.xls" workbook in a second excel name is "controled.xls" and then make a button in a worksheet in controler.xls. And press the button and then must be appeared in message box with "controled.xls is opend in the other excel application" please, xl genius @@ *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VB application | Excel Discussion (Misc queries) | |||
Application/vnd.ms-excel | Excel Discussion (Misc queries) | |||
macro to close excel application other than application.quit | Excel Programming | |||
Excel Application needs a DLL | Excel Programming | |||
application.quit will not shut off application | Excel Programming |