Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2000 macro on excel 2003... help!
I've got this Proration Calculator from a guy at work which can reall
make my life a lot easier. It was made in MS Excel 2000. I took a cop of it home and tried to open the *.xls file in my MS Excel 2003 progra which was fine. When I click a button i.e. $34.99, it gives me an error message saying: "Compile error: Can not find project or library" How can I make this work under MS Excel 2003? Thank you so much in advance -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2000 macro on excel 2003... help!
Open the VBA Editor (ALT+F11), select your project in the Project
Explorer (CTLR+R), then choose References from the Tools menu. Look for items marked "MISSING". If you find one or more, uncheck the reference in the dialog. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sonycellguy " wrote in message ... I've got this Proration Calculator from a guy at work which can really make my life a lot easier. It was made in MS Excel 2000. I took a copy of it home and tried to open the *.xls file in my MS Excel 2003 program which was fine. When I click a button i.e. $34.99, it gives me an error message saying: "Compile error: Can not find project or library" How can I make this work under MS Excel 2003? Thank you so much in advance. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2000 macro on excel 2003... help!
Chip:
Why does this happen? It sounds like a bad planning situation from Microsoft. John baker "Chip Pearson" wrote: Open the VBA Editor (ALT+F11), select your project in the Project Explorer (CTLR+R), then choose References from the Tools menu. Look for items marked "MISSING". If you find one or more, uncheck the reference in the dialog. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Macro and Excel 2003 to Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 macro not working in Excel 2003 | Excel Discussion (Misc queries) | |||
Office 2000 Excel Macro runs very slow in 2003, why? | Excel Discussion (Misc queries) | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Macro error after switching from Excel 2000 to Excel 2003 | Excel Discussion (Misc queries) |