Hi everyone,
I want to create a folder if it doesn't exist, i got that part down.
HTML Code: 
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.
best Regards,
Ahsan K