Get file name from Macro reading excel files

FelipeGonzalez

Hi everybody,

I have been reading some forum answers but unfortunately they have not been able to solve my problem, therefore I appreciate any help.

I have a simple macro that reads an excel file:

And then a simple workflow that reads it. Unfortunately, I am getting the same filename in all the data despite that the datafiles are named differently.

Thanks for the help!

Best wishes

Thableaus

@FelipeGonzalez 

Try to select the "File - value = ....(your file path)" in the Action Tool

Check the box "Replace a specific string" and make sure you're replacing the full path.

Other than that, we'd need to check what's coming from the Directory Tool and which field is being fed to the Control Parameter

Cheers,