In Tools | References Missing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: CAE (anonymous_at_discussions.microsoft.com)
Date: 05/19/04


Date: Wed, 19 May 2004 12:20:19 -0700

Thanks there is a Missing Reference:

I dont know how to deal with/correct it?

The missing reference is "Microsoft ActiveX Data Objects
(Multi-Demensional) 2.7 Library"

In Tools | References Missing

>-----Original Message-----
>In Tools | References, check if you have any items marked
as "MISSING"
>
>--
>Regards
>
>Juan Pablo González
>
>"Cae" <anonymous@discussions.microsoft.com> wrote in
message
>news:f4df01c43dc8$6e277650$a301280a@phx.gbl...
>>
>> I had the following macro working in Excel 2000, when I
>> used an Excel XP machine to save the file now I get the
>> following error when running on back Excel 2000.
>>
>> "Compile Error: Can't find Project or Library"
>>
>> The Macro Breaks at the following Code that uses
a "Form"
>> to graphically display progress.
>>
>> Sub UpdateProgress(pct)
>> With Mercury_Reporting_Package.ProgressUpdate_Form
>> .FrameProgress.Caption = Format(pct, "0%")
>> .LabelProgress.Width = pct *
>> (.FrameProgress.Width - 10)
>> .Repaint
>> End With
>> End Sub
>>
>> Thank you in advance
>>
>
>
>.
>



Relevant Pages

  • Re: Getting file name from the file path error
    ... I checked one users tools - References and it appears that it ... It is part of a code module in an Excel ... end of statement with the As highlighted after the(stFullName As String). ... Sub GetFileNameAs String ...
    (microsoft.public.excel.programming)
  • Followup re Excel/Word OLE error
    ... It was suggested by another to check the Excel & Word VBA references for any ... that were missing. ... the app with code removed. ...
    (microsoft.public.word.vba.general)
  • Followup to Excel OLE Error
    ... It was suggested by another to check the Excel & Word VBA references for any ... that were missing. ... the app with code removed. ...
    (microsoft.public.excel.programming)
  • RE: Excel/Word app error
    ... It was suggested by another to check the Excel & Word VBA references for any ... that were missing. ... the app with code removed. ...
    (microsoft.public.word.vba.general)
  • Re: "compile error in hidden module: ThisWorkbook" for Excel 2002 - pl
    ... > You will see one or more references with the word MISSING showing. ... >> I have developed code in excel 2003 and it work ok in excel XP. ... >> Exit Sub ... >> Dim dateStart As Date ...
    (microsoft.public.excel.programming)