Opening Excel files from Access macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access macro that opens an Excel file with no problems because I
tell it the path and file name. I would like the user to open a second file
on a different drive, which could have any name, so I can't hard code it.

I have tried ChDr and ChDir but that doesn't help in Excel.

I have a prompt that tells them to open a file. I would like to display the
Open File dialog box to "R:\ Macro File\" in Excel.

The problem is the Open File dialog box opens to My Documents. However, if
I manually open a file from access, the dialog box displays "R:\ Macro File\"

How can I code the macro to display "R:\ Macro File\" when they are prompted
to open the file with the Excel Open File dialog box.

Thanks for the help......
 
Back
Top