how to use vb to save the excel file

H

Hcoms

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
 
B

Bob Phillips

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)
 
Top