Input Data : Replace with Full Path

[DelData]

Hi There...

I have an Input Data called Superstore Old (B), the File Path for Superstore Old is C:\users\del\Sample Superstore Old.xls

However the Input Data file path for Superstore Old (B) needs to be replaced with a different excel that has a different path name that change regularly.

How can I dynamically replace the Input Data field in (B) to go from.....

C:\users\del\Sample Superstore Old.xls

to the new full path name shown in (A) called...

C:\users\del\Replacement Excel.xlsx|||Country

[griffinwelsh]

What is your criteria for picking a new filepath? You will likely be able to use a directory tool and pull the most recent file with a certain keyword/extension ect.

[DelData · Accepted solution]

I will use a combination of dir and formulas to get the full path of the replacement excel each time name changes....I now thinking a batch macro will work....I will try that...thanks for getting back to me :)