Opening Excel files from Access macro

J

JT

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......
 
Top