load multiple xls files by using Macro - not working

[c20091929]

Hello there, 

I want to load multiple xls files by using Macro. 

I have built the Macro, but it is not working.

The error was "No table chosen; please select a table from the data source."

I have selected the table name in my Macro and the output was correct. Just don't understand why the workflow is not working...

Any help is really appreciated!!

Thank you all for your time.

[gabrielvilella]

Hi @c20091929, insert a formula tool before the macro and concatenate the name of the sheet to the full path. Since you are working with XLS, don't forget the $ at the end. Example:

[c20091929 · Accepted solution]

Hi my friend, 

Thank you so much for your reply. 

I tried to add the formula tool but still got the format error. 

Any ideas?

[c20091929]

Finally know why now.

Replaced /// with ||| and now is working. 

Thank you so much for your time

[gabrielvilella]

Yeah you need the pipe, not the slash. I use the pipe on my answer. Happy to help! Please don't forget to mark my suggestion as the solution.