Can't find project or libary

B

Ben Allen

Hi,

I created a spreadsheet a while ago in Office 2000, now when I open it (in
Office 2003), I recieve the "Can't find project or libary" error. 'Date' is
hightlighted. I fixed this by changing it (and all the others) to
'vba.date'. After this the same error appeared for 'format' and 'entirerow'.
The same used above fixed the 'format' issue. However when doing this to
'entirerow' I recieve the error "method or data member not found". Does
anyone have any idea how to fix this?

Thanks,
 
F

Frank Kabel

Hi Ben
in the VBA editor goto 'Tools - References' and check if at least the
reference to the Excel/Office library is checked
 
T

Tom Ogilvy

in the VBA, go to tools=>References (make sure this project is the active
project) and you should see at least one checked library marked as MISSING.

You need to uncheck this library (ies) or find the current verion on this
machine using the browse button.
 
B

Ben Allen

Frank Kabel said:
Hi Ben
in the VBA editor goto 'Tools - References' and check if at least the
reference to the Excel/Office library is checked
Click to expand...
Thanks Frank,

They following are ticked:

Visual basic for Applications
Microsoft Excel 11.0 Object libary
Ole Automation
Microsoft Office 11.0 Object libary
Microsoft Form 11.0 Object libary
MISSING: SOLVER.XLA

The missing solver one is weird as I have installed the solver add-in.

Any more ideas?

Thanks,
 
B

Ben Allen

Thanks everyone, sorted now. I browsed for the solver add-in as Tom said.

Thanks Again
 
Top