This video illustrates how to create code in Excel VBA to open a file in a folder based on Cell Values for both the File Name and Folder where file is located. This allows users to change the cell values to automatically open different files in different locations. In this example we have Month/Year Folders that are located within a Year Folder. The objective is to write code to get to any of the files within specific month/year subfolders based changing cell values.
#ExcelVBAOpenFileBasedOnCellValue
#ExcelVBAOpenFile
#LearnExcelVBA
Learn More about Excel VBA & Macros with this Book on Amazon:
amzn.to/3xnqT6R
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.