(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 *