Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
can anyone here adivse me on what to do. I have now finished my project and it works exactly as i want it too. However, i have come across this very large problem. Introducing the book onto our server where everyone else uses excel 2000. I created this book on excel 2003. So when someone else issues a macro they immediately get an error saying Object not found. i went into the Visual Basic Editor / References and looked for the office library but it says: MISSING.Office 11 object library. Is there a way around this or have i just wasted my time on this book? Can i copy over the office 11 object library, or save this book as an earlier edition? or, do i have to upgrade everyone to office 2003? please advise. Very Frustrated Nige |
#2
![]() |
|||
|
|||
![]()
Although this has never happened to me the many times I've used different
Excel versions, I'd suggest you open the workbook in Excel 2000, remove the problem reference, add a reference to Office 2000 and save it. -- Jim "Nigel" wrote in message ... | Hi, | can anyone here adivse me on what to do. I have now finished my project and | it works exactly as i want it too. However, i have come across this very | large problem. | Introducing the book onto our server where everyone else uses excel 2000. I | created this book on excel 2003. So when someone else issues a macro they | immediately get an error saying Object not found. | i went into the Visual Basic Editor / References and looked for the office | library but it says: | MISSING.Office 11 object library. | Is there a way around this or have i just wasted my time on this book? Can i | copy over the office 11 object library, or save this book as an earlier | edition? | or, do i have to upgrade everyone to office 2003? | | please advise. | | Very Frustrated Nige |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Missing library when running 98 project on 2003 | Excel Discussion (Misc queries) | |||
VB Extensibility library and "late binding" | Excel Discussion (Misc queries) | |||
Missing Library | Excel Worksheet Functions | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
missing data from table | Excel Discussion (Misc queries) |