Visual Basic :: Project Reference, "MISSING: Microsoft Excel 10.0 Object Library"

Missing Library Running Excel 98 Project On 2003
Not really a VB query, but a VBA one. I have this project which was developed using Excel from Office 98. When it is run on a machine with Office 2003, there are "Library missing" bugs everywhere (e.g., it chokes on the Chr function). It appears to me that the project itself is storing the reference to the C:Program FilesCommon FilesMicrosoft SharedVBAVBA6VBE6.DLL library and when it runs on the 2003 machine, it's looking for the older version of the DLL. This is because on the 2003 machine, I can create a new project where the Chr function works. Any ideas on how I can get the older 98 project running on the 2003 machine without having to create a new project and port all the data?

Excel Object Library Reference
I have an Excel add-in program that is coded in VBA. It works fine until I loaded a vender's software. Now the add-in won't compile. It can't reference the workbook, worksheets and range objects. The reference is still set to the Excel 9.0 object library.

I have reinstalled Office and uninstalled the vender program. The uninstall said that not all components of the vender program were removed. The add-in still won't compile.

Any idea what the problem is?

Microsoft Excel Object Library
Where can I get Excel Object Library? I have Excel 2000, I have vb 6, I cannot find the Excel Library...

Microsoft Excel 8.0 Object Library
could you tell me where i can download this library?
For ocx controls we never seen before is there any way of getting some info on it??

If Add Reference To Excel 9.0 Object Library And Set Button On Toolbar , Error
Hi, i am getting error if i add reference to Microsoft Excel 9.0 object library

1. add reference to Projext->Reference and select Microsoft Excel 9.0 object library
2.add one toolbar on form1
3. Run the following code

Private Sub Form_Load()
Dim btnX As Button
Toolbar1.Buttons.Add (1)
Set btnX = Toolbar1.Buttons(1)
End Sub

if you remove the reference then everything will work fine but if add reference then type mismatch error

why these error is occuring ?

Microsoft Office Object Library Excel 2003 And Excel 2000
Ciao Gurus,

I have developed an application with excel 2003 and, of course, it takes as reference the library of excel 2003, but most of the users have excel 2000 and the application goes in error when this reference is called. The library is Microsoft Outlook that in excel 2003 is 11.0 version while in excel 2000 is 9.0.
How can I fix the problem?
Best Regards
KAIALA

Edited by - kaiala on 7/2/2007 3:21:56 AM

Microsoft Excel 11.0 Object Library Question
is there a way to view the compnents of Microsoft Excel 11.0 Object Library. Like a read out of all avaliable objects and properties etc...?

Thanks,
Nooch

Microsoft Excel Object Library Question
Hello everybody

I`d like to know if the Microsoft Excel 11 Object Library, installed by Microsoft Office 2003, can be used on machines which might have another version of Microsoft Office installed.

ToolBar1 & Microsoft Excel 12 Object Library Does Not Get Along?
Hi there, I have a project using Toolbar, and has being working great for such a long time.

Know i decided to make some improvements to my program, and one of the improvements is to export data on a MSFlexgrid to Excel. For that, i needed to add Microsoft Excel 12.0 Object Library.

When i run the program it appers to be a mistake on a SUB wich reads something like this:

The declaration of the procedure does not match with the description of the event or the procedure that has the same name.

The problem seams to be here:

Private Sub Barra_ButtonClick(ByVal Button As Button)

Where Barra is the name of the control Toolbar and the event is to catch the Button pressed.

The fact is, if I erase the Barra_ButtonClick Sub the Excel exporting works just fine.

Or

If i Take out the Object Library the ToolBar Event works great.

What can that be?

Please help more than apreciated!

Microsoft Excel 10.0 Object Library And Toolbar Problem
Referencing to Microsoft Excel 10.0 Object Library will generate compile error: Run time error 13 "Type Mismatch" at
"Set btnX = Toolbar1.Buttons.Add(, "open", , tbrDefault, "open")" code below. Please, help if you can, Thank's.

Private Sub Form_Load()
    ' Create object variable for the ImageList.
    Dim imgX As ListImage

    'Load pictures for the Toolbar buttons into the ImageList
    'control.
         Set imgX = ImageList1.ListImages. _
            Add(, "open", LoadResPicture(101, vbResBitmap))

         Set imgX = ImageList1.ListImages. _
            Add(, "save", LoadResPicture(102, vbResBitmap))

         Set imgX = ImageList1.ListImages. _
            Add(, "exit", LoadResPicture(103, vbResBitmap))

    Toolbar1.ImageList = ImageList1

    ' Create object variable for the Toolbar.
         Dim btnX As Button

    ' Add button objects to Buttons collection using the Add method.
    ' After creating the button, set the Description and ToolTipText
    ' properties.

    ' Create Open Button
         Set btnX = Toolbar1.Buttons.Add(, "open", , tbrDefault, "open")
            btnX.ToolTipText = "Open"
            btnX.Description = btnX.ToolTipText

    ' Create Save Button
         Set btnX = Toolbar1.Buttons.Add(, "save", , tbrDefault, "save")
            btnX.ToolTipText = "save"
            btnX.Description = btnX.ToolTipText

    ' Create Exit Button
         Set btnX = Toolbar1.Buttons.Add(, "exit", , tbrDefault, "exit")
            btnX.ToolTipText = "Exit"
            btnX.Description = btnX.ToolTipText

    With Toolbar1
            .Wrappable = True ' Buttons can wrap.
         End With
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
    ' Use the Key property with the SelectCase statement to specify
    ' an action.
    Select Case Button.Key
        Case Is = "open"
         Call cmdFileSelect(blnSndpath)
    Case Is = "save"
         Call cmdInsert(blnSndpath)
    Case Is = "exit"
         Call cmdQuit
   End Select

End Sub

-NT- I Cant Find "Microsoft DTSPackage Object Library" In The Project Menu;References
TIA

Missing MS Script Control 1.0 Reference Library
Hi,

I've got a problem with a VB6 reference library, and I hope all u VB experts out there can help me.

I tried to compile and make my project as an .exe file, but when the project was compiling, there was an error, stating that the library 'MS Script Control 1.0' is missing, and thus, could not compile. I checked my reference libraries, and true to the word, that reference library is missing.

Any ideas on where to download and install the MS Script Control 1.0 reference library? I tried to search the Microsoft website, and nothing came up

Any help is greatly appreciated.

Moving Back From Office 11 To 9, Missing Library Reference Errors Keep Appearing
Greetings all!

I have a spreadsheet that I was developing for work and took home to do some work on. Now I have Office 11 at home but we have office 9 I think it is at work. When I was developing the spreadsheet I had to change some library references to Outlook 11 at home, but removed them when I got back into work.
For a while everything ran fine, but suddenly the spreadsheet stoppped working. After investigation it looks like the spreadsheet is looking for the Office 11 library again but obviously can't find it, causing the error. The reference to the Office 9 library also seems to be being removed. None of the other office library reference seem to be being changed however.

Any ideas on what might be causing this, or how to prevent it????

~Shiv

Missing Microsoft ActiveX Data Objects Library 2.7
Hi,

I have Microsoft ActiveX Data Objects Library 2.1 & 2.5 Libray in my VB 6.0 (Service pack );

I am wondering how I would update to Microsoft ActiveX Data Objects Library 2.7.

thanks

Missing:Microsoft ActiveX Data Objects 2.8 Library
I've downloaded a code from planet-source code, but as I run the program a message pops up saying the library could not be found, and as I look at the reference, I have a missing data objects 2.8 library. Anyone who knows where I could get this library or update?

Missing Microsoft ActiveX Data Objects 2.8 Library
I keep getting this error in VB6 when I try to create an EXE from my project, Missing Microsoft ActiveX Data Objects 2.8 Library, I look where it points to and the file is there, Msado15.dll...but it will not register that it is there...any ideas of what is wrong? I am using XP Pro and VB6 SP5.

Thanks,

Missing Project Or Library
Hi,

I´m new to this so first of all a big hello to everyone.

My VB- project use the 'Visual Basic for Application Library'. I don't know what I have changed but since yesterday, the compiler nags about a missing project/library. So I looked at the specific line(s) and noticed that there are simple String-functions in use (Left$, Mid$ ...). So, when I changed the line to e.g VBA.Left$(...) it compiles without any error.

In the references dialog the 'Visual Basic for Application Library' is at the first position.

Does anyone know what the problem is? I don´t want to change every single function call in my project...since it is not small (46 classes, 52 forms).

Regards,
Kalle

(sorry for the bad English)

Microsoft Access Library Reference Problem
Im currently using Access 97 and I have downloaded and installed the latest vb scripts, called scripten.exe. I am writing some vb code through Access, and the Miocrosoft vb script for Regular Expressions does not apear in my library of references. The ironic thing is that I downloaded someone elses sample Access database and when I run it in Access 97 the regular expressions reference shows up in the library with a path of vbscript.dll3 , when I try to find that same reference in my Access database it cannot be found. It does, however, find vbscript.dll but that only gives me a vb script Globals reference which does not give me the RegExp object that I need. Any help would be greatly apreciated.
Thank you much, Sam

Missing Library Or Project Files
Hi Friends,
when i run a project i get error saying "Can't find project or library" and then references dialog box opens up. It shows MISSING: macro hierarchy type library". Can i know which file is missing or how should i go about this error??

I get the error at this place of code:

VB Code:
Public Sub SetCurrentCellText(FlexGridObj As MSFlexGrid, X As Integer, Y As Integer)

Looking forward for your suggestions...

Missing Project Reference
Hi,

I am using Visual Basic 6 and in my cod I connect to an Access 2003 database and to do this I need a Reference under the Project Menu called 'Microsoft ActiveX Data Objects 2.x Library'. I did have this reference but I had to re-install Visual Basic 6 and now I don't have it. I have tried simular references but they don't work it seems I need this one to make my code work. Is there a url where this reference can be downloaded or some kind of update for Visual Basic 6 that includes it?

Thanks,
Darren

Project Reference Missing
Dear all,

My VB program suddenly stop with error "Can't find project or library" and debug point to syntax "date" and "time" .When I check via Project ---> References I found that Available References for Microsoft Data Environment Instance 1.0 (SP4) is MISSING . Is this related to the error and if it is then how can I get back the control ?

Thanks and I appreciate any kind of help .

Project Library Reference
what is the specific library reference for date and chr? my project wont run on another machine!

VB6 Missing Uncheck Project Reference
Hi,

Can anyone help me with my VB6 program problem?

Whenever Im starting to compile my program, It promt me like "Compile Error: Can't find project or Library" . This is because the UCase,Format,Val, etc.....

Its seems like i miss something to check in the VB6 Project Reference.
Even if I add Form - About Dialog, the command button "SYSTEM INFO" doesnt work due to this the same problem.

Thanks in advance!

Can't Find Project Library Or Reference...
i have downloaded a sample vb program.. but wen i run it, it would have an error that says it couldn't find project library or reference...

and it would appear in the references that microsoft data environment instance is missing.. what should i do?...

How Can I Find Reference Missing Without Opening The VB Project
Hi All,

I need to parse the dll refernce in the VB project without openig the VB project thru IDE and i want to display the missing reference. I need some documentation for the reference format used in VB project.

Regards
Jebasingh

Object Library Reference
I am developing an application that uses the Excel Object Library...My system has Office XP installed, under my references I see the Excel 10.0 object library reference, but my client (who is going to be using the app) has Office 2000, which uses the EXCEL9.OLB, Excel 9.0 object library. I do not have a reference to the 9.0 object library in my VB IDE...So I was wondering, if I go ahead and reference the 10.0 object library will this create a problem once the app is installed on the clients machine? since the object libraries will be different?

Missing: ActiveX Data Object 2.5 Library
Can anyone tell me where i can get the library file above?

Looking For A Word 9.0 Object Library Reference
Hey there again,

I'm also looking for a book/e-book or a paper of some sort with a
function reference on the Word 9.0 object library. Where can
one find this information?

Best regards
/Thomas

How To Reset An Object Library Reference
On my system, due to an error on my part, when I go to Project -> References for the MS Word 9.0 Object Library, it is pointing to C:MyDirectoryMSWORD9.OLB. It should really be pointing to C:Program FilesMicrosoft OfficeOfficeMSWORD9.OLB.
How can I fix this?

Reference An Object Library Through Code?
I know that if you want to reference a library in VB you can select the Project menu and References, but can you do it through code?

Here's my dilemma. I am building an interface to create reports in MSWord and I have users with different versions of Office on their machines, specifically Office97 and Office2000. I was planning on checking to see what Word object library they had and reference it through code.

Maybe there's a better way of doing this. Any suggestions is appreciated.

VB Reference To Acrobat Object Library
Can anyone tell me how to set up a reference to an Adobe Acrobat 4.0
object library in a VB project? I have already set the reference to
Acrobat in my VB project, but when I try to CreateObject("Acrobat"), it
returns the error:

Error 429: ActiveX component can't create object

Thanks in advance. =97 Ron in NYC

************************************************** **
This e-mail and any attachments thereto, is intended only for use by theaddressee(s) named herein and may contain legally privileged and/orconfidential information. If you are not the intended recipient of thise-mail, you are hereby notified any dissemination, distribution or copyingof this email, and any attachments thereto, is strictly prohibited. If youreceive this email in error please immediately notify me at (212) 735-3000and permanently delete the original copy and any copy of any e-mail, and a printout thereof.

Further information about the firm, a list of the Partners and theirprofessional qualifications will be provided upon request.
************************************************** **

How To Install/reference Office 10.0 Object Library
I am trying to make my program compatible with Office XP (10.0) as well as Office 2000 (9.0). I have Office XP Standard and Visual Basic 6.0 Professional installed on Windows XP Professional. I have references in my VB project to the PowerPoint 10.0 Object library (msppt.olb) and the Office 9.0 Object libary (mso9.dll).

I read somewhere that I need to reference Office 9.0 and 10.0 object libraries as well as PowerPoint 9.0 and 10.0 object libraries. I don't have the Office 10.0 and PowerPoint 9.0 object libraries in my reference list and cannot locate the appropraite files.

Where do I find these object libraries to reference them? Do they exist?

I Need Help Finding Missing Reference?? Compile Error: "Cannot Find Project Or Librar
Hi Guys,
I have moved my project to a new stand alone PC, I installed VB6 and the service packs I use as I usuall have done in the past.

But when I try to run my project its erroring out on a form that has a web browser and toolbar.

The error I get says

Compile Error: "Cannot find project or library"

Once I click ok at the error message the reference panel opens and is wanting me to make reference to this missing file I guess??

In my project the program stops on this line

Code:
Private Sub tbToolBar_ButtonClick(ByVal Button As Button

Can anyone suggest what file VB is looking for and will it be on my VB6 Discs?

Thanks in advance to anyone who can help me here.
Regards as ever
C

Microsoft 2.0 Object Library
Does somebody know where I can find documentation of these components?

Thanks in advance

Ruben
(Montevideo, Uruguay)

Microsoft Word 8.0 Object Library
Hi All,

I am having a problem here ...

When i develop my application in VB, i used the MSWord 10.0 Objecj Library.

The Run function allow me to run a MSWord macro and submitted the parameter to that macro. However, when i run on Win97, the MSWord 8.0 Object Library, the Run function do not support the passing of parameter.

Can anyone advise me on how can i pass the parameter over to the macro !

Thanks,

Microsoft X.x Access Object Library
Hi all,

I have Access 2003 installed and I need to add the Microsoft Access Object Library to one of my projects so I can use some report functionality, yet, it does not appear in my components list.

Does anyone know how I can get it there? Thanks

Microsoft Access 8.0 Object Library
I am using VB 6.0 both at college and home. For my current and previous project i require the Referance Microsoft Access 8.0 Object Library, and the Component Microsoft Data bound Grid control 5.0(Dont think version matters).
The problem is i recently formatted my HDD, and after reinstalling VB i no longer have the Microsoft Access 8.0 Object Library in my referances. I have a feeling it is something to do with the file 'MSACC8.olb' but don't quote me on that. But i didn't have this problem before i formatted my HDD!
I would appreciate if someone could tell me how i can solve this problem, and if that is the file i need, where can i get it.

Thanks in advance,
Metaphoric

Microsoft Word 9.0 Object Library
Can some someone please upload the Microsoft Word 9.0 Object Library? I am in great need of it and cannot install the latest service pack.

Thanks so much!

Microsoft Forms 2.0 Object Library?
Any one heard about Microsoft Forms 2.0 Object Library. This library allow UNICODE for textbox, cmdbutton & so on.

My Question is, anyone place unicode to form.caption before?

FYI, I'm Using VB6 Ent SP5 (English Edition)

Microsoft Word Object Library
Hello,

I would like to incorporate a spell checker? If I reference Microsoft Word 8.0 Object Library and distribute the compliled program to others do they need Microsoft Word?

Are there any in-process spell checkers? I do not want the user to rely on a particular spell checker.

Code:

Dim MSWord As Word.Application

Private Sub Form_Load()

Set MSWord = New Word.Application

End Sub

Private Sub cmdCheck_Click()
Dim text As String
Dim suggestion As Word.SpellingSuggestion
Dim colSuggestions As Word.SpellingSuggestions

If MSWord.Documents.Count = 0 Then MSWord.Documents.Add
text = Trim(txtWord.text)
lstSuggestions.Clear
If MSWord.CheckSpelling(text) Then
lstSuggestions.AddItem "(correct)"
Else
Set colSuggestions = MSWord.GetSpellingSuggestions(text)
If colSuggestions.Count = 0 Then
lstSuggestions.AddItem "(no suggestions)"
Else
For Each suggestion In colSuggestions
lstSuggestions.AddItem suggestion.Name
Next
End If
End If

End Sub

Thanks,
deDogs

Microsoft Graph 9.0 Object Library
Hai

How to use Microsoft Graph 9.0 Object Library In VB.

I like to use it to create Pert Chart.

Regards,

Karnan.S

Add Ref To Microsoft HTML Object Library
hi

i am working with VBA, and due to the nature of my project, i am using the web browser.

if i go to the visual basic editior in excel, select tools, referecnes, and scroll down and select Microsoft HTML Object Library the code will fire without a hitch.

however, another user might not have Microsoft HTML Object Library referenced and when they go to use the routine it will bug out.

so my question is, how can i code it directly into the VBA to reference the Microsoft HTML Object Library to make sure whoever uses the program doesnt have a problem

thanks

Microsoft Outlook 10.0 Object Library
I'm not sure if this is where I should be posting this. If there is a better location please let me know. Here goes.

I am using VB.Net, but this has more to do with COM objects.

I have referenced the MS Outlook 10.0 Object Library and I am sending email from an app. I can do this with no problem except when I hit the send button I get a dialog box warning me that someone is try to access Outlook and it may be a virus. Click yes to continue. I can hit yes and it works fine. I think the reason I'm getting this is because in my code I should be including the Outlook.NameSpace Logon method. I would include this but the first param is for a profile, 2cd is password, and then there are two more params but not of concern to me. I do believe that if I could set the profile and password to that of one in my Outlook that I would no longer receive this warning. The code looks something like this:

Code:Public Sub SendAssignment(ByVal body As String, ByVal teEmail As String, ByVal trEmail As String)
        ' Create Outlook application.
        Dim oApp As Outlook.Application = New Outlook.Application()

        ' Get Mapi NameSpace.
        Dim oNS As Outlook.NameSpace = oApp.GetNamespace("mapi")
        oNS.Logon(profile as Object, password as Object, ShowDialog as Object, NewSession as Object) 'here are the problem params

        Dim oMsg As Outlook.MailItem

        oMsg = oApp.CreateItem(Outlook.OlItemType.olMailItem)

        With oMsg
            .Body = body
            .Subject = "Tutoring Assignment"
            .Recipients.Add(teEmail)
            .Recipients.Add(trEmail)
            .Display()

        End With

        ' Log off.
        oNS.Logoff()

        ' Clean up.
        oApp = Nothing
        oNS = Nothing
        oMsg = Nothing
    End Sub

If anyone could help out with this it would be greatly appreciated. Thanx in advance.

--kmfan
----------------------------------------------------------------------------
"It's not whether you win or lose, it's whether I win or lose."

Why To Use MicroSoft Forms 2.0 Object Library
Hi,
I have a doubt for which i didnt get clear answer from google or msdn.
Why to use forms 2.0 object library.

Our project is developed with vb6 and msaccess. It has to work independently (without vb & office in client system). Problem is, project was developed using forms 2.0 object library which involves with fm20.dll. So, it works only in the system with office. But our client wants this application to run independently. We have to remove this from our application. As i am new to vb, i dont know if i remove this and use standard vb package (command button, test boxes...) will it affect the application processing with db.

We are using data grids to display data.

any suggestions are appreciated

rajan

Microsoft SQLNamespace Object Library
I'm trying to create an application in VB6that connects to a remote mySQL database. I've found some sample code to look at, but it needs the "Microsoft SQLNamespace Object Library", which I do not have. I've tried finding it, and all I've found is documentation on it, and no where to actually get it.

I would apprieciate if someone coulddirect me to where this library can be downloaded, and how I might go about installing it.

Thanks in Advance