Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Macro Problems between Excel 2003 & 2000


  • Please log in to reply

#1
LapeerTech

LapeerTech

    New Member

  • Member
  • Pip
  • 6 posts
Please forgive me if this has been addressed, but I searched to no avail (in this forum, many others, microsoft, ...)

I have users in both Excel 2003 and 2000 (in the midst of upgrading all users). A developer upgraded his version to 2003. The application makes heavy use of macros and uses the Object Libraries. When the developer saves the file, it upgrades the references to Office 11.0 Object Library. When the users in Excel 2000 open the file and the macros execute, it cannot find that library (uses 9.0 Object Libary) and the application exits.

While it would be possible to have the developer go back to office 2000, this is the third time I've been asked to address this problem. The company I am working with has 40,000 pc's and the migration from Office 2000 to Office 2003 will take some time.

Is there any solution that can be placed in a macro to ensure the right library is referenced? The solution of having the users change the reference manually is not acceptable. (Some users barely can open the file, let alone go into VBA, Tools, References and sort through all the selections!)
Thank you for any assistance, hints or guesses you can send my way,
Tony
  • 0

Advertisements


#2
rkrickler

rkrickler

    New Member

  • Member
  • Pip
  • 1 posts
Did you ever get this resolved? If so what was the fix?

Thanks,

Roger
  • 0

#3
I_am_MAD_Alice

I_am_MAD_Alice

    New Member

  • Member
  • Pip
  • 6 posts
XL2000: How to Run a WordBasic Macro from a Microsoft Excel Macro
XL2000: How to Use DAO to Create a New Microsoft Excel Workbook
XL2000: "Can't Find Project or Library" When You Run a Macro

I hope this helps, or gets you in the right direction.
  • 0

#4
LapeerTech

LapeerTech

    New Member

  • Topic Starter
  • Member
  • Pip
  • 6 posts
Roger - Solution:
There is an option when you use <Save As> that allows you to save in a dual mode format. File type is [Microsoft Excel 97 - Excel 2003 & 5.0/95 Workbook (*.xls)]. Makes the file a bit larger, but keeps enough reference details for the macros to work.

Thanks for the try I_am_MAD_Alice. However those do not fix the problem.

Tony
  • 0

#5
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
u want the fuile to reference to the referneces thru code?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP