Looping Excel files with Sheets

[Anonymous]

Hi Friends any suggestions on the below query:

I am trying to load Excel files with Jan, Feb......Dec as sheet names.

There are 3 Excel files in the Folder with Month names as sheet names.  Naming convention is like below:

Filename:  Data2010.xlsx with Jan till Dec sheets.

Can anyone suggest how to loop and load these Excel files please.

Thanks in advance.

[tresesco]

Have a look here:

Load all Excel files and all sheets in a folder

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[Anonymous]

Hi Tresesco, i am using the same code , but there is some problem while code execution , if  iam not wrong the next i and next or there should be a drop table some where , coz for me if i use the code as it is it is giving me 12 months (Jan to Dec sheets ), 24 months and 36 months . can u suggest please.

Regards