Create New Folder, Save as New File and Open after Running VBA

[NewatWork]

Hello everyone,

Sorry in advance if this has already been answered. I would greatly appreciate it if you could link the solution.

This is what I'm hoping to execute: I have a "Manual Counts" sheet that I use at work. Every time I use it, I need to save a new copy in a new folder after inputting the necessary data in it. I'd like to be able to increase efficiency by running a VBA and having the new copy saved automatically in a new folder.

The folder would need to be saved in the file path: C:\Daily Upload and saved as Cell Value found in C6. The File Name would need to be saved using the Cell Values found in C6 and G6.

And if it's at all possible, after running the macro, I'd like the new file to open up automatically without having to find it in the Daily Upload folder.

Thank you in advance and have a great rest of your day, evening and night!

 

[onlyadrafter]

Hello,

Does this work as expected?

Sub SAVE_A_COPY()
    ActiveWorkbook.Save
    ActiveWorkbook.SaveAs ("C:\Daily Upload\" & Range("C6").Value & Range("G6").Value)
End Sub

when doing SAVE AS, the new filename will be open, so bit confused with the last part of your request.