Results 1 to 2 of 2
  1. #1

    Importing multiple Excel sheets

    Hi All
    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.

  2. #2

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 03:36 PM.

Copyright BetaSoft Inc.