- Aug 22, 2020
- Office Version
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")