By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

VBA locate and save as

100+
P: 158
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!
Aug 6 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
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)>
Attached Files
File Type: zip FileGrabber.zip (34.4 KB, 62 views)
Aug 6 '08 #2

100+
P: 158
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!
Aug 7 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.