66 Replies Latest reply: May 13, 2012 8:56 AM by Lav Jain RSS

    Load all sheets in all Excel documents

    Dave Finlay

      I have a number of Excel docs in a folder with naming convention of FileName_YYMMDD.

      The problem is that the docs may contain a different number of sheets i.e. Doc1 has Sheet1/Sheet2

      while Doc2 has Sheet1/Sheet2/Sheet3 etc.

      I need to create a table of Doc name and Sheets belonging to that Doc.

      Then I want to load the sheets from their associated docs in a loop statement.

      Anyone any ideas?