chr(65) => can't find project or library

[stt_d31]

hello
when i have:

dim str as string
str = chr(65)

i get the following error: can't find project or library !
Don't understand why?

[RobDog888]

Is this in an Office VBA app or in VB6?
Sounds like your missing a reference or a possibly a corrupt file.

[stt_d31]

it's vba excel.
and now i see i cannot use the Mid function neither!
am i missing some references maybe ?

[RobDog888]

These are the four core references you should have in your VBA IDE.

Visual Basic For Applications
Microsoft Excel xx.0 Object Library
OLE Automation
Microsoft Office xx.0 Object Library

[stt_d31]

found it already.
remember i had the same problem about a year ago and searched a whole day on it:

solution:
- uncheck all references that are marked as "MISSING"
- reboot computer

[RobDog888]

So this workbook came from another system with a different version of Excel.

[stt_d31]

So this workbook came from another system with a different version of Excel.

now i have this problem with excel 2000.
last year i had the same problem on another computer but with vb itself !

very strange, however i found the solution on the internet (to uncheck all references that are marked MISSING), so the problem is not unknown.

however, very strange (and stupid) behaviour

[RobDog888]

The "MISSING" references issue usually happens when you upgrade Office or VB. Since the references are pointing to a
specific CLSID for one version and yo upgrade to another version then the CLSID will be different. So you get a "MISSING" reference.

[stt_d31]

those guys have the same problem:
http://www.idautomation.com/kb/vba-compile-error.html

This is a Microsoft application problem... This is a documented issue at the Microsoft website....

[Gibber]

I have the same problem, but the Excel file I have calls a function in VBA. This shows the "compile error" box. However, the spreadsheet keeps calling the function, so if I try to reset or go into design mode, the error just keeps appearing, so I can't access the references. All I can do is kill the application.

[Br1an_g]

I have the same problem, but the Excel file I have calls a function in VBA. This shows the "compile error" box. However, the spreadsheet keeps calling the function, so if I try to reset or go into design mode, the error just keeps appearing, so I can't access the references. All I can do is kill the application.

if you open a blank Excel file, you should be able to access and modify the references so that the next time you open your excel file that gives the issues, it should be ok.

[stt_d31]

All I can do is kill the application.

go to Tools - References and uncheck all that is marked as "MISSING"

[rishidoshi]

Hello.

I have the same issue. If i remove the missing component, it works.

I have referenced to an AutoCAD reference.... something axdb16enu.tlb file.

Is there any way to "install" this reference somewhere somehow?

As the excel product is already shipped and the VBA is password protected. I do not want to give the password to the users to uncheck the missing reference.

It wont work where autocad is not installed.

If i could install or put the reference somehow in the client machine, the problem will be solved.

Hope i made sense in my question :P too confused!! pls help!!

Regards

Rishi Doshi

[si_the_geek]

Welcome to VBForums

To install the reference you are likely to have to install AutoCad - which would be a big waste of resources, and be illegal too.

Even if there is an easier way, you will still be wasting resources.


As you need to ship something out anyway, why not simply untick the reference and send out your Excel product?

[rishidoshi]

Hi si_the_geek,
thanks 4 ur time.
The thing is that its already shipped away.
I did some R&D at my end and came up with a following temporary solution:
i created a new folder in Common Files named "Autodesk Shared"
[ C:\Program Files\Common Files\Autodesk Shared ]
and pasted the file "axdb16enu.tlb" in it.
Now it works.
It would be unprofessional if i tell the clients to make folders and paste files in them.
I am looking for an installable .exe file which will do the above.
Any suggestion please!