mvidas
11-09-2004, 10:22 AM
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
ActiveWorkbook.SaveCopyAs "C:\2963372.xls"
is run, it gives a "The file could not be accessed" error.
But,
ActiveWorkbook.SaveAs "C:\2963372.xls" works just fine
Any ideas?
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
ActiveWorkbook.SaveCopyAs "C:\2963372.xls"
is run, it gives a "The file could not be accessed" error.
But,
ActiveWorkbook.SaveAs "C:\2963372.xls" works just fine
Any ideas?