two same workbooks opened -- don't want this

R

rchiuhk

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(...........)
}
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top