Open specific folder with a button in access 2003

[jaccess]

I was wondering if there is a simple way to open a specific folder from an access form button.

I have a form that a user can enter a date range and either view or print reports based on the date range. These reports are based on linked excel files.

What I am trying to do provide a simple way (press a button) for my users to be able to open their excel files from the form instead of having to open excel, locate the folder then locate the file.

Actually is possible to open the most recent file in a folder based on a button press?

I have been searching for most of the morning and I cant seem to find a simple (easy for a noob to understand) way to open a specific folder from within access.

Any help would be uh... helpful.

Thanks,

J

[jaccess]

Never mind, I found something which will do what I need.

For anyone else interested:

Create a command button to open an Excel spreadsheet from an Access form

[NeoPa]

Thank you J, both for letting us know you were no longer in need, and also providing an answer for any others searching this problem in future :)