Can't find project or libary
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 |
Can't find project or libary
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 |
Can't find project or libary
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 |
Can't find project or libary
"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 |
Can't find project or libary
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 |
Can't find project or libary
Thanks everyone, sorted now. I browsed for the solver add-in as Tom said.
Thanks Again |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com