spreadsheet backup to different location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I am running office 2002 edition.

I am aware of the backup option which saves the spreadsheet as another file when you press save. BUT is there a way where the backup file can be saved to a different location to that were the main file sits?

Thanks

Adam
 
Adam,

If VBA , look at the SaveCopyAs method in help, this will do what you want.

--

HTH

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

AdamE said:
Hi All,

I am running office 2002 edition.

I am aware of the backup option which saves the spreadsheet as another
Click to expand...
file when you press save. BUT is there a way where the backup file can be
saved to a different location to that were the main file sits?
 
Back
Top