Posted to microsoft.public.excel.programming

external usenet poster

Posts: 57

SaveAs?

I need to save copy of a workbook under diferrent names...

I currently am using the SaveAs method but this switches to the newly
created file and I would like to remain within the original file. How can
this be done.

Also, is it possible to create these copies without copying the vba in the
main file, just the worksheet data?

Thank you for the help,

QB

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value	DarrenL	Excel Programming	4	April 18th 09 07:54 AM
SaveAs	Arnie	Excel Programming	6	October 21st 08 03:56 PM
VBA SaveAs Value	charlie	Excel Discussion (Misc queries)	4	August 27th 07 11:33 PM
SaveAs	brownti via OfficeKB.com	Excel Programming	3	February 28th 07 04:33 PM
Using the SaveAs in VBA	caldog	Excel Programming	2	October 5th 05 01:05 AM

All times are GMT +1. The time now is 02:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us