how to use vb to save the excel file

  • Thread starter Thread starter Hcoms
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save data from Notebook: copying to the USB stick using Linux and the command line 0
VB Code to Auto Save Multiple Files 0
Lose macros before saving 4
Excell 2021 0
saving the userform layout 0
Saving a Word document as PDF from en Excel macro 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel save takes 18 times longer than Windows Explorer copy - why?Options 2

Back
Top