Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
two same workbooks opened -- don't want this
Dear all,
I have the excel file which is opened and run the dllfunction which will manipulate this excel file. How can I write in dllfunction so that it can work the excel file which has been opened?? Let me mention more clearly. xlapp=new excel.applicationclass() // Actually test.xls has been opened. xlworkbook=xlapp.WorkBooks.open("test.xls",....); // open again, it will make two test.xls excel screen. How to eliminate this and working on the existing opened excel file?? ............................. I want as below. if (There is instance of excel exists) { set xlApp to be excel instance set xlWorkBook=xlApp.ActiveWorkBook; } else { create new excel instance and set to xlApp. set xlWorkBook=xlApp.Workbooks.Open(...........) } |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
two same workbooks opened -- don't want this
I Usually use CreateObject and Getobject together and don't use Open.
Test if object exists. If it doesn't then use getobject to open the workbook. "rchiuhk" wrote: Dear all, I have the excel file which is opened and run the dllfunction which will manipulate this excel file. How can I write in dllfunction so that it can work the excel file which has been opened?? Let me mention more clearly. xlapp=new excel.applicationclass() // Actually test.xls has been opened. xlworkbook=xlapp.WorkBooks.open("test.xls",....); // open again, it will make two test.xls excel screen. How to eliminate this and working on the existing opened excel file?? ............................. I want as below. if (There is instance of excel exists) { set xlApp to be excel instance set xlWorkBook=xlApp.ActiveWorkBook; } else { create new excel instance and set to xlApp. set xlWorkBook=xlApp.Workbooks.Open(...........) } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
History of Workbooks opened | Excel Worksheet Functions | |||
Transfer data between 2 workbooks opened with IE | Excel Programming | |||
always prompted to save opened workbooks | Excel Discussion (Misc queries) | |||
Reference to Multiple Opened Workbooks | Excel Programming | |||
Format by VB opened Workbooks/sheets | Excel Programming |