Saving the same workbook uniquely


N

Novicer

Can someone please help me with this task?

I have a workbook with 2 worksheets (W1, W2) that we use daily. At the end
of the day, my colleagues and I want to save W1 (only) separately.

Secondly, the file name used is the last unique number generated in that
worksheet (W1) automatically. So the file name will actually be a number
generated in that worksheet.

Is this possible?

Thanks!
Novicer.
 
Ad

Advertisements

B

Bob Phillips

Worksheets("W1").Copy
Activeworkbook.SaveAs Range("A1").Value

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top