A button that opens a new workbook and saves the current worksheet on to it

hello

i bassically wanted to know if theres a way that if i click the button ie macro then it would save the current worksheet on a new workbook so the button would open the workbook and save the worksheet on to it

for example

if i was creating a finacial spreadhseet and i wanted to keep a record of all the invoices before the date is cleared, i would need a button that would open another workbook and cave the invoice on that

thanks in advance

Hello shilpz,

The VBA code to save a worksheet as a new file is as follows. Change "Sheet1" to the name of the worksheet you want saved. The file name in the example is Invoice 2007001.

Please Login or Register  to view this content.

If you want the button to save the currently active sheet use this code...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

thanks alot