ExcelBanter - Workbook Copy

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Workbook Copy (https://www.excelbanter.com/excel-programming/332042-workbook-copy.html)

Ashman

Workbook Copy

Does anyone know if you can copy a workbook?

Norman Jones

Workbook Copy

Hi Ashman,

Try:

Sub Tester()
ActiveWorkbook.SaveCopyAs ("MyCopy.xls")
End Sub

---
Regards,
Norman

"Ashman" wrote in message
...
Does anyone know if you can copy a workbook?

Ashman

Workbook Copy

many thanks works well, I did use the getsaveasfilename at the start though

Ashman

"Norman Jones" wrote:

Hi Ashman,

Try:

Sub Tester()
ActiveWorkbook.SaveCopyAs ("MyCopy.xls")
End Sub

---
Regards,
Norman

"Ashman" wrote in message
...
Does anyone know if you can copy a workbook?

All times are GMT +1. The time now is 03:32 AM.