I am currently using the very simple vba code "ActiveWorkbook.SaveAs (strFilename2)" to save my file, how can I have that saved into the same path of the folder yet into a folder let's say for instance is "Summary"
Thank you!
I am currently using the very simple vba code "ActiveWorkbook.SaveAs (strFilename2)" to save my file, how can I have that saved into the same path of the folder yet into a folder let's say for instance is "Summary"
Thank you!
Post the complete code you are currently using to export and save your file.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Here you go! That's part of the code tho. Hope it helps
![]()
Please Login or Register to view this content.
Last edited by jeffreybrown; 11-12-2016 at 10:58 AM. Reason: Please use code tags...Thanks!
Maybe like this.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks