run time 1004 when using macro in Excel 2003




Created a macro in Excle 2000 and it worked fine - when moving to excel 2003
the macro gives a runtime 1004 error.

error message

Run-time error '1004':

Microsoft Office Excel cannot access the file 'C:'. There are several
possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a
currently open workbook

Do I need to amend code ? I thought it would be seamless change ? doh!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question