Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am using a VB Script to show a Bar Graph in our GUI through excel workbook. The call I am using in VB Script to create Excel Object is: .... set ExcelObject = GetObject("", "Excel.Application") .... Its working well when there is no Excel instance running previously. If there is an existing excel sheet already open (opened manually and unrelated to the GUI & VB Script), the GUI's Excel is taking control of the Excel and I am unable to switch back to the Excel Sheet which is opened manually. I can only switch to the previously running Excel sheet only when I minimize the excel sheet in the GUI. Could someone help me to overcome this or is this intended if so, any justification for this ? Steps which lead to a problem: 1. launch Excel manually from start - run - excel.exe 2. launch Excel in the my own GUI with the VBScript which is using GetObject() call At this point, I am not able to switch to the Excel instance which is opened in step 1. Thanks in advance, Ravi Nandibhatla. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Switching between Workbooks | Excel Discussion (Misc queries) | |||
Switching between workbooks | Excel Discussion (Misc queries) | |||
Switching Between 2 workbooks using VBA | Excel Programming | |||
switching between workbooks... | Excel Programming | |||
Switching Workbooks in vbscript | Excel Programming |