I found the code below on an earlier post from 2002, but it did not give me the full path, including subfolders and file name. It just gave me the files in that particular folder and did not include the subfolders, etc. How do you change it so that I get the full path? I want to use it for an...
Can somebody help in separating Filename and Path when saving a file in a macro (excel).
Dim TempFilePath As String
MiFile = Application.GetOpenFilename(",*.xls")
If MiFile = False Then Exit Sub
'Here I have a path and filename (all together) and I can not...