I know this can be done .. but i'm not sure what keywords to google or even the right words to ask .. so here is what i'm trying to do.
I have an excel template file.
Whenever the user clicks on a button (in an ms access form), I would like a dialog box to open up, the user then can browse to wherever on his computer and save the file under a certain file name.
In reality, they are just going to be doing a "save as" with the excel template file *i think*.
I also have another place in my file, where my user is creating a file on button push (in excel) ... whenever he pushes the button, i'd like a popup box to come up where he can browse to the right place and save the file as whatever he wants to.
can this be done?
any clue on how to do it?
Thanks much in advance :thanx: