Need to write a program to open a filename...
I want to write a VBA program that will automatically reference a date in a
certain cell and then use the data in the cell to be able to locate a file
and open it.
Example:
Cell (1,2) has the data of: 12/31/04
Based on this info, the filename I wish to open is called 12-04.xls and is
located in the following location:
S:Accounting\Monthly Report\
How do I get VBA to automatically open the 12-04.xls file based on the data
in that cell? Remember that a future time the data in that cell will change
to a different date such as 02/28/05. In which case I would wish the program
to open 02-05.xls located in the same folder location.
|