Can't find project or libary

[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,

 

[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

 

[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.

 

[Ben Allen]

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

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,

 

[Tom Ogilvy]

uncheck solver or use the browse button to find it.

 

[Ben Allen]

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

Thanks Again