How to resolve"Reference " OR "Library" not found error?

[Chirag R Raval]

Dear experts,

When Try to run any code, on "[ DATA]" & on FORMAT (DATE, "DD/MM/YYYY")
code particularly stop At/ ON...Square bracket "[" .... & Word/function/statement ......"Date"..
Says "Reference or Library not found…"

There are not more test that on how many points macro can stop..in additions above 2 points...

How to resolve this??????

If any one successfully runs all his or her macros...on his/her pc
when just same macros run on other pc ...face many problems....
you are requested to guide what Precautions should be taken before
move to other pc.with required final & universal repository system
so that any one can not face any problem to run their VBA macros on other pc.

Regards,
Chirag Raval

 

[Marc L]

Hi !

As it depends on source library, just install it on computer …

To avoid reference issue
better is to use late binding instead of early binding.
​

 

[Chirag R Raval]

Dear Sir,

Thanks for reply..

but ...
what where are found that library ? & how to install?
& can you describe about what is "Bindings"?
& what relations to VBA?

hope you can help to understand this that I & may be someone can new for VBA..

Regards,
Chirag Raval

 

[Chihiro]

Often, when error is thrown on "Date" function, wrong standard library is referenced (likely the one missing on the PC). I've had it happen to me once. Though was unable to pinpoint the cause.

Check by going to VB Editor, and going to Tools->Refrences.

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

These 4 should be standard, and unless required no other references should be ticked.

If you find missing reference to one of above, check that xx (version) matches that of your Office/Excel installation. If it isn't, scroll down and locate the one that corresponds to your installation.

11.0 = Office 2003
12.0 = Office 2007
14.0 = Office 2010
15.0 = Office 2013
16.0 = Office 2016