Importing multiple Excel sheets
How to import 5 excel sheets (2 from local machine and 3 from QC) into the same "Action1"sheet? The problem here is that some columns in the sheets are same but the rows are totally different. Will the columns, with the same name, overlap and retain all the rows of data of all 5 excel sheets?
I tried looking into the help doc but in vain. But am giving a try anywayz.
Thanks in advance.
Re: Importing multiple Excel sheets
You can't do that in a single statement. You will need to right code for the same. The ImportSheet function will always replace and never add the new sheet. Search for Excel.Application on this forum and you will find few examples on how to use Excel COM APIs