I've set CreateBackup = True on a file. However, when my clients are using
the file they sometimes get a message about 'cannot create backup file - do
you want to save the file with out backup?'. It seems like a minor issue to
me, but the clients don't like the extra click to close the message. When I
try to duplicate this with my file to my 'My Documents' folder, Excel creates
the backup each and every time, as indicated by the time stamp on the file.
When I check the file in the 'live' folder, there is a backup from today, but
I get the same message and no current backup file is created. I use Excel
2007 on my machine, but the users are using 2003 - could this be the issue?
Is there a way to get around this? I already have DisplayAlerts = False set,
so I'm at a loss. Can anyone explain this to me?