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



"ryguy7272" wrote:

This should get you started:
http://www.rondebruin.nl/copy6.htm

Post back if you have specific questions.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Peter T" wrote:

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?