G
Guest
Dear Access experts,
I am working on a form and want to be able to open an Excel file from a form
button, but the Excel file to be opened will be based on a variable name that
the user types into a field. In other words, if the user types "A", and
clicks the button, the excel file workA.xls is open. If the user types "C"
and clicks the button, the excel file workC.xls is open. The files are in a
few different directories. What is the best method to do this? How do I
have Access open the Excel file? In addition, would a Select Case statement
be the best way to have the various files be chosen? Thanks in advance for
your input into this.
Neal
I am working on a form and want to be able to open an Excel file from a form
button, but the Excel file to be opened will be based on a variable name that
the user types into a field. In other words, if the user types "A", and
clicks the button, the excel file workA.xls is open. If the user types "C"
and clicks the button, the excel file workC.xls is open. The files are in a
few different directories. What is the best method to do this? How do I
have Access open the Excel file? In addition, would a Select Case statement
be the best way to have the various files be chosen? Thanks in advance for
your input into this.
Neal