load multiple xls files by using Macro - not working

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

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167