Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Looping Excel files with Sheets

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.

2 Replies
Anonymous
Not applicable
Author

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