Hi Conan

A workbook that is not saved one time have no path so you can test it like this.

Sub test()
If ActiveWorkbook.Path = "" Then
MsgBox "New workbook"
Else
MsgBox "Old workbook"
End If
End Sub




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Conan Kelly" <CTBarbarin at msn dot com wrote in message ...
How can I tell (via VBA code) if the workbook is a new workbook from a template or an existing workbook?

If it is a new workbook, I want to SaveAs and give it a name. If it is an existing file, I just want to save it.

I already understand the SaveAs and Save methods. I just don't know how to check whether it is new or existing.

Thanks for any help anyone can provide,

Conan Kelly