+ Reply to Thread
Results 1 to 2 of 2

Macro error after switching from Excel 2000 to Excel 2003

  1. #1
    Jake Burnham
    Guest

    Macro error after switching from Excel 2000 to Excel 2003

    My company recently switched from Excel 2000 to Excel 2003 and now a macro I
    created does not work. It gives me the error 1004 and highlights the line of
    code where I set it up to open certain files in a folder. This macro has
    been working for 6 months without fail and only has problems opening the
    Excel files I created after the switch to 2003. Any help would be
    appreciated.

  2. #2
    vezerid
    Guest

    Re: Macro error after switching from Excel 2000 to Excel 2003

    Without any other info the only suggestion is to see if your sheets
    have different names.
    For example, a statement like:

    Sheets("Feb Sales").Cells(i, j+5) = k

    might cause a 1004 error if the new workbook does not have a sheet with
    this name. Otherwise you need to post the code.

    HTH
    Kostis Vezerides


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1