excel 2000 macro on excel 2003... help!

  • Thread starter Thread starter sonycellguy
  • Start date Start date
S

sonycellguy

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
 
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
 
Chip:

Why does this happen? It sounds like a bad planning situation from Microsoft.

John baker
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Porting from Excel 2003 to Excel 2010 12
Help! Problem Referencing Excel 2003 in VB.NET 1
Excel 2000 VBA Application on Excel 2003 2
forwards/backward compatibility Excel 2003-2007 8
Running Excel 2000 VBA Application on Excel 2003 3
Excel 2003 Macro in Excel 2000 Environment 2
Excel How to enable engineering functions in MS Excel 2000? 3
Problem running VBA 2000 code in Excel 2003 3

Back
Top