auto open a workbook

  • Thread starter Thread starter Mauricio
  • Start date Start date
M

Mauricio

Hello, I need a formula that well alaw me to open an
especific workbook from a text string from another,
since my files are save as dates(jan-01-03, etc....)
it's taking me to long to open, paste, and save the new
file.
since the workbook used a text(date) in a cell, how can I
used that to open the file with the same filename as the
cell before closing the workbook.
 
=HYPERLINK(A1&"/"&A2&".xls", A2)

Where A1 contains the directory path where the file is stored (for example,
C:\Documents and Settings\shockley\Desktop) and A2 contains the name of the
file, for example, 2003-10-22.

HTH,
Shockley
 
Back
Top