how to use vb to save the excel file
 

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

how to use vb to save the excel file
 

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