Good Evening all,
I have a form which as a textbox named "Core Serial Number"
I have a folder that contains two excel spreadsheets, with the folder name, and the excel spreadsheet name that same as the core serial number displayed in the text box.
e.g.
Core Serial Number Displayed in textbox on form = CAE540151
Folder located on A:\ Drive = CAE540151
Excel worksheet located in folder = CAE540151.
The form is linked to an master excel spreadsheet, which is updated daily, and any data that is changed in the master excel spreadsheet is replicated on the form.
What I would like to do is create a command button on the form that will allow me to open the excel worksheet located in the folder on A:\ drive that corresponds to the core serial number displayed in the textbox.
Is this possible? I am using Access 2013
I have a form which as a textbox named "Core Serial Number"
I have a folder that contains two excel spreadsheets, with the folder name, and the excel spreadsheet name that same as the core serial number displayed in the text box.
e.g.
Core Serial Number Displayed in textbox on form = CAE540151
Folder located on A:\ Drive = CAE540151
Excel worksheet located in folder = CAE540151.
The form is linked to an master excel spreadsheet, which is updated daily, and any data that is changed in the master excel spreadsheet is replicated on the form.
What I would like to do is create a command button on the form that will allow me to open the excel worksheet located in the folder on A:\ drive that corresponds to the core serial number displayed in the textbox.
Is this possible? I am using Access 2013