Tom,

Yes, I guessed the same. Actually, I thought of the designers saying
"what would be a really dumb thing to do, such that its behaviour will
be the opposite to its siblings (Save & SaveAs)" ...!

Oh well, one gets used to unusual Excel characteristics. It is also
strange that this is not really documented (unlike
ActiveWorkbook.CreateBackup) and I couldn't even find this out in such a
tome as JW's Excel 2002 Power Programming with VBA. It seems such a
useful method, too …..

Bob,

Yes, the directory has to be present, as I found out!

Regards, and thanks for your help,

Mark




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!