Hi,
I am working on a code that sends and email with a renamed workbook attachment. I would like to save a copy of the workbook to a specific folder "C:/desktop" instead of killing the temporary file.
I have tried a lot of things that my limited knowledge would allow me but I can't make it work. Your help is appreciated!
Please Login or Register to view this content.
Last edited by moxman; 10-18-2013 at 01:20 AM.
didnt read the whole code but having two "\" in the path could be the issue
MyPath = "C:\Documents and Settings\\Desktop"
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi, Thanks for pointing that out. Its a mistake I made while posting the code here. The original code goes to a different specific folder, I just changed it to the Desktop for easier reference.Originally Posted by humdingaling
I have been focusing on the line:
tried changing it to wb2.Saveas.Filename etc etc but didn't workPlease Login or Register to view this content.
The code you have already saves the file but in a tempfolder
under windows 7
TempFilePath = Environ$("temp") & "\" was saving to C:\Users\<username>\AppData\Local\temp\
to change to desktop
i run windows 7, different windows may have different desktop path, adjust to your windows defaultPlease Login or Register to view this content.
Last edited by humdingaling; 10-20-2013 at 07:40 PM.
WOW! That worked! Thanks a lot humdingaling!
I also disabled the codeto prevent it from deleting the newly created form.Please Login or Register to view this content.
Thank you for your help! Its a very useful addition to help me understand VBA.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks