Excel sheet Wildcard

[vardhancse]

Hi,

PFA excel sheet.

Here is the Requirement:

1. irrespective of the sheet name which ever sheet starts with Region & Area all sheets should be reloaded.

2. Both the data needs to be concatenated

can any one please let me know option.

[tamilarasu]

My bad. I haven't tested the code. Thanks and Have a good day!!

[vardhancse]

Hi Nagaraj,

similarly can please let me know how to load data from multiple excel sheet with different file names.

For e.g:

1. Sample.xlsx

2. Sample 1.xlsx

3. Sample 3.xslx

Now we need to load all the sheets data from all the 3 excel sheets and concatenate into one single sheet

[tamilarasu]

Hi Sasi,

Have you tried by changing the file path (Highlighted in red) in above script? I believe this should work.

FOR EACH file in FileList('Filepath\*.xlsx');

[vardhancse]

Hi Nagaraj,

Yes changed the path and given * as well in the file name.

But issue is that facing "_xlnm._FilterDatabase" issue.

Loading duplicate sheets by appending _xlnm._FilterDatabase in the file name.

[tamilarasu]

Sasi - Do you apply any table formats in your excel file? I think that might cause this issue. You can exclude those sheet names by adding "IF" condition. If you still facing the issue, could you please post a snapshot that shows your problem.