xlApp.Activeworkbook.SaveCopyAs Filename:= yourfilename

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Hcoms" wrote in message
...
hello,

what i am doing is to create a copy of the working excel doc AFTER the
save.
However because we do not have the after save event what is the best way
of
doing this???

Cheers