Ananthak275
Board Regular
- Joined
- Aug 22, 2020
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
- MacOS
I have a path that I put into a variable. How would i make sure to get the file name and extension separately? I wanna be able to use this code for other variables that have a path extension with a file at the end.
Eg : Path_Extension = ("\\documents\data\file\datafile,xlsx")
Eg: Data_Extraction = ("\\desktop\sourcefile.xlsx")