Posted to microsoft.public.excel.programming
|
|
How to save a worksheet in a project as a SEPARATE FILE
Ryan
Really Useful - Thankyou! my problem is no longer a problem
Cheers
Pete
"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?
|