View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default How to save a worksheet in a project as a SEPARATE FILE

What's a "print form" ?

To do what your subject line implies, simply

ActiveSheet.Copy

This will create a new file, save it as required, and close it.

Regards,
Peter T

"vbnewbie" wrote in message
...
I have, as part of a project, a print form I want to save as a separate
file
without losing focus on the original. Can anyone help?