VBA locate and save as

[Jollywg]

What I am doing is (1) having a user press a button, which has a msgbox pop up and asks if they would like to find a file. (2) if the user clicks yes then (3) open up a dialog box so that they can search through their computer and select the file. (4) Once they select the file i need it to be saved as "file1". I know how to do everything up to step 2. Any help is greatly appreciated!

thanks!

[missinglinq]

Here's a sample database called FileGrabber from a gentleman name Ken Getz that demonstrates how to open the File Dialog box and select a file. Be sure to look at the module that does most of the work, as well as the copyright notice. The code is free to use as long as you keep the copyright notice in place.

Linq ;0)>

[Jollywg]

Here's a sample database called FileGrabber from a gentleman name Ken Getz that demonstrates how to open the File Dialog box and select a file. Be sure to look at the module that does most of the work, as well as the copyright notice. The code is free to use as long as you keep the copyright notice in place.

Linq ;0)>

Thanks for the response! That helps out A LOT. The only thing that i need to do now is take the variable filePicker which has the file name that the user selected, and "automatically" (without user input) save it to a file name and path which are named setName setPath respectively.

Thanks!