View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default How do I determine if it is a new file or an existing file?

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