Posted to microsoft.public.excel.programming

WhytheQ

external usenet poster

Posts: 246

Set mySavedSummary = ActiveWorkbook.SaveAs( .......

What am I doing wrong:

Dim mySavedSummary As Object
Set mySavedSummary = ActiveWorkbook.SaveAs(Filename:="R:\Statistics
\Example.xls")

....and how do I alter the above so that it does work?

Any help greatly appreciated,
J.

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
ActiveWorkbook.SaveAs problem	SandyUK[_11_]	Excel Programming	2	November 14th 05 02:54 PM
Max charactors for 'ActiveWorkbook.SaveAs Filename'?	TOMB	Excel Worksheet Functions	1	February 16th 05 06:44 AM
'ActiveWorkbook.SaveAs Filename'	TOMB	Excel Programming	2	February 15th 05 11:51 PM
ActiveWorkbook.SaveAs Problem	SowBelly	Excel Programming	4	August 4th 04 10:58 PM
activeworkbook.saveas	J Silver	Excel Programming	0	June 25th 04 09:01 PM

All times are GMT +1. The time now is 03:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us