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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Ben Allen" schrieb im Newsbeitrag
...
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,
--
Ben

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.

--
Regards,
Tom Ogilvy

"Ben Allen" wrote in message
...
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,
--
Ben

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

--
Regards
Frank Kabel
Frankfurt, Germany

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

uncheck solver or use the browse button to find it.

--
Regards,
Tom Ogilvy

"Ben Allen" wrote in message
...

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

--
Regards
Frank Kabel
Frankfurt, Germany

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

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

Thanks Again