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?

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

See More: How do I name a newly created workbook

Report •

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.

message edited by DerbyDad03

Report •
Related Solutions

Ask Question