ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 774
- Office Version
- 365
- 2019
- Platform
- Windows
Hello - I have a very peculiar request. I currently run a process where the date to use is driven off the folder name (the date to run it for). I am looking for a way to remove the human element of someone typing in the day and including it somehow in my VBA or the use of a formula? see below for an example. Currently I need to modify the yellow shaded. in hindsight the worksheet that runs the code is in the folder anyways so could it just use that to drive the date to run other worksheets that reside in that same folder as well?
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Path | D:\ME\Documents\Files\House\Home\12.20.20\Monthly Credit Card breakdown.xlsx | ||
2 | Run Date PRE | Run Date Post | ||
3 | 12/20/2020 | 12/20/2020 | ||
4 | ||||
5 | ||||
6 | ||||
7 | ||||
Sheet1 |