Opening multiple workbooks in Excel through VB

N

Nick.Korynski

I need to open multiple excel files through my code in VB. Does a
quicker runtime result from opening up one instance of excel and then 5
workbooks in that application as opposed to opening 5 applications of
excel?

e.g.

public xlApp as excel.application
public xlBook as excel.workbook
public xlBook2 as excel.workbook
public xlBook3 as excel.workbook
public xlBook4 as excel.workbook
public xlBook5 as excel.workbook

vs.

public xlApp as excel.application
public xlApp2 as excel.application
public xlApp3 as excel.application
public xlApp4 as excel.application
public xlApp5 as excel.application

Thanks,

Nick
 
J

Jon Peltier

Just as important is what are you doing with the workbooks? I'd think it
would be easier to use a single instance, especially if there's any
interaction between the workbooks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Similar Threads

Open a file in another Workbook 1
How to Cancel the Protect of Excel with VB and save it with a new password again 1
Open Excel workbook from Access 4
VSTO Excel 2003 to VB 6.0 Type mismatch 0
Excel object "Access denied" error 0
Fail to open unicode txt file in excel 8
Hanging Instance of Excel 6
How to save and close multiple Excel applications? 1

Top