Opening multiple workbooks in Excel through VB

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

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/
_______


<[email protected]> wrote in message
news:[email protected]...
>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
>