SOLVED
Directory input and daily worksheet name variation
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
MarkMcCullagh
7 - Meteor
‎05-19-2020
02:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I get a daily file that is manually pulled and the creator is sticking to a predefined naming convention so that the latest .xlsx file can be read in. The single worksheet name varies and so my question is, is there a way for this to be loaded automatically regardless of this name change ?
Thanks in advance.
Mark
Solved! Go to Solution.
Labels:
- Labels:
- Input
2 REPLIES 2
patrick_mcauliffe
14 - Magnetar
‎05-19-2020
03:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-02-2020
07:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Patrick
It was for a dynamic name. Sorry I missed your post. Found a coworker elsewhere in my organisation that provided a solution. Because of my set up I can't post it other than a screenshot. This was his solution.