Hi everyone,
I want to create a folder if it doesn't exist, i got that part down.
now I have an excel file that im making changes to and I want to save it as a new file (with a different name) in the folder I have created above. something like this:HTML Code:
how do I make a variable out of the folder I created and place it in the strLocation? so then I would just need to use the SaveAs function to save that entire path strLocation. anyhelp would be much appreciated. thank you.HTML Code:
best Regards,
Ahsan K
Bookmarks