Save Issue

[GreenHornet]

Hi, i'm somewhat of a beginner at this vba lark and struggling, I've searched the threads for something similar with no luck...

I'm trying to put together a piece of code that will save the current workbook in 2 locations (the current folder and on another server) on closing. I don't want the code to originate from a button as I don't think it will be used (my colleagues are not IT orientated!!).

The before close statement is close, but not quite there as it saves no matter what.... Is there a way of changing the folder for Backups (i'm using 2000 and it only saves in the current folder).

[Avner]

H,
Have you tried the EVENT macro workbook_beforeclose on thisworkbook macro sheet?

and the lines of chdrive and chdir ?
be aware that chdir isn't enough, you have to change the current drive with chdrive.
Avner

[GreenHornet]

Hi Avner,

Thank's for the reply, I have tried this, there is a problem with it though, in that if you don't want to save what you have done it will save it to the second location anyway.

Any other thoughts please let me know...

Thanks