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


--
urkec


"WhytheQ" wrote:

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.