I have two codes, not sure which is better or why, but I would like to be able to provide this VBA to anyone and them run it easily without adjusting the code. So is there a way to have a popup like a Save As would do that would allow the user to select one time where to export 240 files to?
my two similar codes are below. I do like that the second gives you a success message.
Please Login or Register to view this content.Please Login or Register to view this content.
You could try something like this to prompt them for the location - you would add in your code where indicated. The loop just ensures no copy is attempted before the location (user input) is found to be valid.
Please Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Thanks!
what do I do with my code's folder path?
Please Login or Register to view this content.
If I literally just copy my code here, I get a compile error: user-defined type not defined.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks