Ignore Certain Excel Files from path

[kiranpatil123]

Hi All ,

I'm Loading all excel files from particular Path by giving * (around 50 excel files) .

I want to restrict (dont want to read them) some excel files Starting with '3rd Party' .

How do i do that ?

Advance Thanks

[martinpohl]

for each vFile in filelist('yourpath\*.xls')

if substring('$(vFile)',\',-1) like '*3rd Party' then

Trace 3rd Party, not loaded;

else

load

*

from $(vFile);

endif

next

[Frank_Hartmann · Accepted solution]

Or maybe like this:

for each file in filelist('C:\Users\admin\Desktop\Neuer Ordner\*.xlsx')
   if WildMatch(text('$(file)'), '*3rd Party*') = 0 then
      load * 
      from [$(file)] (ooxml, embedded labels, table is Tabelle1)  ;
   end if   
next