1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2K3 Macro Problems

Discussion in 'Business Applications' started by mwells, Sep 20, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. mwells

    mwells Thread Starter

    Joined:
    Jul 17, 2002
    Messages:
    20
    Hi All,

    Here's the prob.
    Had some pretty complex worksheets with complex macros within them that were created with Excel 2000 (win2k machine). The macro's purpose is to basically go through the worksheets get stuff from them and create new excel files....all works well on the machine set up that way (excel 2000).

    Well, the machines have been re-imaged to winxp pro and office 2k3. The spreadsheets open and the macros work to a point. The macro goes through the spreadsheets and starts to create the new spreadsheets. The problem, is that the new workbooks are blank (the macro attempts to create the workbook and does give the proper name to it in the save).

    Any ideas? I by no means am any sort of excel expert (actually I'm tech support and working on this lady's machine (old computer still set up and will be replaced with the xp and excel 2k3)).

    Thanks,
    Mike
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,294
    First Name:
    Wayne
    anything silly like directory names?
     
  3. mwells

    mwells Thread Starter

    Joined:
    Jul 17, 2002
    Messages:
    20

    No, everything's local. Files are in the same locations that they are on the computer that works as well. IF that's what you meant.
     
  4. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    How about posting your macro code so we can take a look.
     
  5. mwells

    mwells Thread Starter

    Joined:
    Jul 17, 2002
    Messages:
    20
    Macro attached since it's kinda lengthly
    Macro created in Excel 2000
    Now trying to use it in Excel 2003
     

    Attached Files:

  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/276040

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice