(Solved) – How do I write a VBA code to go to a filepath, open a folder then open a file?

(solved)-–-how-do-i-write-a-vba-code-to-go-to-a-filepath,-open-a-folder-then-open-a-file?

Can anyone help me with a VBA code that goes to a folder location, opens the folder most recent folder and then opens a file. Example –

FileName = Book1
FolderName = Raw_Data_04.16.20 (04.16.20 is today's date)
FolderLocation = "F:Weekly Data - LiveArchive"

So Filename is saved in Foldername located in FolderLocation

Leave a Reply

Your email address will not be published. Required fields are marked *