Load excel with for each

[#1]

Hi,

I load in a excel file some tables with        "For each vSheet in 'Jan', 'Feb', .....

                                                               Load col1, col2

                                                               From [path]

                                                               (biff, no labels, header is 3 lines, table is $(vSheet))

                                                               Next;

Now i would like to do the same, but i would like to do the same with two excel files. Something like this:

                                                               For each vFile in 'Path1', 'path2'

                                                               For each vSheet in 'Jan', 'Feb', ....

                                                               Load col1, col2

                                                               From [$vFile]

                                                               (biff, no labels, header is 3 lines, table is $(vSheet))

                                                               Next;

                                                               Next;

How is that possible?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You are almost there!

Change this line, and that should work.

From [$(vFile)]

Hope that helps.

Miguel

[#3]

Great, Thank you.

Everytime this small faults...