Hi All,
I'm trying to help someone who has excel 97, and I've only got 2000.
From everything I can find on the MS website, savecopyas is a valid procedure in xl97.
But for some reason, when the code
is run, it gives a "The file could not be accessed" error.ActiveWorkbook.SaveCopyAs "C:\2963372.xls"
But,
works just fineActiveWorkbook.SaveAs "C:\2963372.xls"
Any ideas?