Loading

Excel.Application instance

Majid Kamali

Hi.
I am creating a program that gets data from a excel file and writes multiple results in several excel files for printing.
When I want to write the files, how many Excel.Application instance is necessary? I mean can I create an instance of Excel.Application for all of the files or I should create Application instance for each of them?
How about Excel.Workbook?

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
A single instance of the Excel.Application object should suffice to do all this.

Individual files are represented by Workbook objects and you can associate several open files at once with an Application object using its Workbooks collection.
Majid Kamali15y ago
Thanks