MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Knowing which Function is in which DLL?

  Asked By: Ernesta    Date: Oct 12    Category: MS Office    Views: 1947

I have an Excel Macro which has Chr() Function in the codes.(MS Excel 2003)

Private Sub Set_NotePad_Wsht_ActiveCell_FullVisible(AcFvVerNum As Integer)
If InStr(1, ActiveCell, Chr(10)) <> 0 Or InStr(1, ActiveCell,
Chr(13)) <> 0 Then
End Sub

Chr is highlighted and VBA says:"Compile Error: Can't find project or library"

If i reinstall Excel with fully VBA included then most probably Code will
work. But is there a possibility like just putting on single DLL in the right
folder(System32 or etc). If ir is possible which DLL has Chr() function in it?

Is there a website which tells about all functions and its parent DLLs?



3 Answers Found

Answer #1    Answered By: Corbin Jones     Answered On: Oct 12

"Don't know" is the answer from me (hopefully someone else does).

But this is pretty fundamental, I would have thought, and there mightn't be
any information about it on the net.

First thing, though, is to check your references. Maybe something has got
itself turned off. Looking at an empty spreadsheet that compiles your
statement without trouble, the references that are ticked (Excel 2003) are:

Visual Basic For Applications
(In Program Files\Common Files\Microsoft Shared\VBA\VBA6\VB........ can't
read the rest)

Microsoft Excel 11.0 Object Library
(In Program Files\Microsoft Office\OFFICE11\EXCEL.EXE)

OLE Automation
(In WINDOWS\System32\stdole2.tlb)

Microsoft Office 11.0 Object Library
(In Program Files\Common Files\Microsoft Shared\OFFICE11\M........ can't
read the rest)

Microsoft Forms 2.0 Object Library
(In WINDOWS\System32\FM20.tlb)

I don't know which of these are default and which I've turned on at some
stage, but it'd be worth checking that they're on in yours.

Answer #2    Answered By: Taylor Evans     Answered On: Oct 12

CHR() is in vbe6.dll. If Visual basic for applications is ticked in
References this library is active.

Answer #3    Answered By: Benjamin Simpson     Answered On: Oct 12

IMHO your problem is definateley the references. If you look at the list do
any of them have "MISSING" next to them?

Didn't find what you were looking for? Find more on Knowing which Function is in which DLL? Or get search suggestion and latest updates.