Input Data : Replace with Full Path
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :)