Hi,
I get a file loaded everyday into a folder in C named as in stock_distribution_20240726.xlsx.
The format is stock_distribution_yyyymmdd.xlsx.
I need to rename this file as stock_distribution.xlsx by stripping off the date before linking it to my table.
Using FileSystemObject and fileExists, I can test if the file exists for that day.
Not sure if I can use Rename along with Mid function to derive only the filename without date.
Is there a simpler way?
TIA
I get a file loaded everyday into a folder in C named as in stock_distribution_20240726.xlsx.
The format is stock_distribution_yyyymmdd.xlsx.
I need to rename this file as stock_distribution.xlsx by stripping off the date before linking it to my table.
Using FileSystemObject and fileExists, I can test if the file exists for that day.
Not sure if I can use Rename along with Mid function to derive only the filename without date.
Is there a simpler way?
TIA