I want to create a command button that will allow me to browes my c:drive folders.

Currently, I have code that will import a spreadsheet. At present, the spreadsheet file name is HARD CODED into the macros "Transferspreedshhet acimport, 3, filename...." you get the picture. Subsequesntly if the spreadsheet file name I want to import changes I have to update the macro with the new file name.

My goal is to be able to create a button, much like a browes button, that will allow me to search for the file I want to import, select it, and then insert that file name into my macro code.

Is this an attainable goal

any advis would be appreciated

I use the API call: API: Call the standard Windows File Open/Save dialog box

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Thanks for the reply
I got it to work

Glad I could help.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"