Solved How do I name a newly created workbook

April 28, 2019 at 16:55:16
Specs: Windows 7
I have this code to create a new excel workbook and it works great but I would like to name it "FireDrill Report" but I don't know how to code it to give it the name.

Can someone help me with this?

Application.Workbooks.Add
    Set xWs = Application.ActiveSheet
    Rng.Copy Destination:=xWs.Range("A1")


See More: How do I name a newly created workbook

Reply ↓  Report •

#1
April 28, 2019 at 18:56:08
✔ Best Answer
You name it when you save it using SaveAs.

This site will show you a whole bunch of options.

https://www.automateexcel.com/vba/v...

message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question