Access Report OfficeLink (Access 2003)

[swhli]

I use Access reports a lot of time and I have found that the Officelink (while viewing the report) is very helpful in exporting the report to Excel. However, I would like to know if there is a way to set the default directory to my network drive rather than My Document. I have noticed that when I first get into the database, the Officelink is default to Word, not Excel. If I change to Excel, then it will stay in Excel until I quit the Access program. Similarly if I change the folder to drive X:, then the system will remember it until I quit. If I come back to the program, it will not remember Excel is the Officelink that I want and drive X is the destination. I have to set them each time, very annoying.

Thanks

[HansV]

As far as I know, there is no way to change the defaults.