Visual Basic :: ToolBar1 & Microsoft Excel 12 Object Library Does Not Get Along?

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.

Missing Microsoft Excel 8 0 Object Library
A customer gave me code to download, and I am getting the following error. I do not have Excel loaded on my machine -- is there any way that I can just download the Excel object library ? Or do I need to be running a version of Excel ?

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

Project Reference, "MISSING: Microsoft Excel 10.0 Object Library"
I am writing a program that requires the Microsoft Excel 10.0 Object Library. I just moved the project to a new development machine that does not have Microsoft Excel installed on it, and I do not have my Excel cd with me here. Is there anyplace that I can get download the object library, or will I have to wait until I have the cd with me?

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

Microsoft Word 8.0 Object Library
From a VB App, how can I access Tables and Text Boxes within a Word 97 Document. I can open the document, but I can't seem to pinpoint the data.

Microsoft Word 9.0 Object Library Problem
when I have a refreacne to Microsoft Word 9.0 Object Library selected and hit F2 vb6 freazes. a pup up error window saying VB6.exe has generated errors and will be closed by Windows. You will need to restart the program.An error log is being created.
when I remove the referance to Microsoft Word 9.0 Object Library then F2 opens up the Object Browser fine.

thanks for help

Microsoft HTML Object Library Problem - Please Help
I am trying to submit a form that has 2 buttons, one of which clears the form and redirects you to a previous page and the other which actually submits the form. I am trying to use the Microsoft HTML Object Library to submit the form. I have found that everything I've tried has either submitted the form using the wrong button or has failed altogether.

The HTML for the button I want to submit looks like this:

HTML Code:
<input type="button" id="send_button" value="Send" />

First I tried the following code to submit the form but found it was clicking the wrong button (the Cancel button):

Code:
Doc.Forms(1).submit

So then I was thinking that maybe I could give the button focus and simulate the user clicking it by saying:

Code:
Doc.All("send_button").focus
SendKeys vbNewLine

This worked fine as long as the program had the main focus in Windows and the user didn't do anything to change the focus (like click the mouse somewhere else). While it worked, it is really impractical for my situation. I need my program to be able to fill out and submit the form without interfering with the user's other computer actions.

I tried both this:

Code:
Doc.getElementById("send_button").submit

and this:

Code:
hDoc = Doc.getElementById("send_button")
hDoc.Click

neither of which worked right. Does anyone know of a HTML Object Library command I can use to tell the webbrowser to submit the form using the button code above?

--------------------------------------------

I thought up the answer to my problem about 10 seconds after posting this, which is kinda funny because I spent hours searching the net for ideas. It turns out all I had to do was:

Code:
Doc.All("send_button").Click

Question About Microsoft Outlook 9.0 Object Library
I have a question about the Microsoft Outlook 9.0 Object Library. My boss just came up to me and asked me to change my code. Here is my code :

VB Code:
'**************** Sets up and Sends Email to AOPS ****************** 'This will send an email to everyone in the department with the 'appropriate information. 'Create Outlook object variable Dim objOutlook As Object 'Assign Outlook.Application to object variable Set objOutlook = CreateObject("Outlook.Application") 'Set objOutlook = GetObject(, "Outlook.Application") With objOutlook.CreateItem(olMailItem) 'To: Field of the Email .Recipients.Add "AutomatedOperationsDistroList@upbna.com" 'Subject: Field of the Email .Subject = strIssue & ", " & strAlert & ", " & strServer 'Body of the Email .Body = strDateTimeStamp & ", " & "Response number: " & strResponse _ & Chr$(13) & Chr$(13) & "Comments: " & strComments 'Copy message to Outlook Outbox with Send .Send End With 'Quits Outlook 'objOutlook.Quit 'Release object variable Set objOutlook = Nothing '********************************************************************

My question is, is there a way for me to change this so that instead of it automatically sending the email, it brings up the email in outlook, so that the person can make changes to it before it's sent? The only thing that really needs to be changed is in case they need to add another email address. But how can i do this? Thanks.

Eric Garrison
Automated Operations
Union Planters Bank

Referencing Microsoft Access Object Library
i m using a reference to Microsoft Access Object Library that references MSACC.OLB my question is in order to redistibute my application do i have to make as requirement that the client machines to have access install or i can make an install program just including that file?

thnks

Microsoft Data Formatting Object Library
When I run my application under Windows 98 it works but when i run it under Windows 2000 it says that MSSTDFMT.DLL is missing. What is microsoft data formatting object library? Will it work if I just register that file under Windows 2000? Will anything be corrupted?

Microsoft Word 9.0 Object Library Error !
i add references Microsoft Word 9.0 Object Library but when i write such as : dim a as _

the message VB6.EXE Application
the instruction at .............. the memory could not be 'read'

what happened ? how to fix it ?

give your answer

thank you

Microsoft HTML Object Library (MSHTML.TBL)
I did include it in the setup, so I unistalled my program, removed it from the setup, installed it with no problem, but still got a "Run Time Error '424', Object Required" when using MS HTML Object Library, thanks again though,

Question About Microsoft Word 8.0 Object Library
How do I using MS Word 8.0 Object Lib in VB acheive the same result as if I where to Insert -> Picture -> From File in MS Word application. Something like:

dim app as Word.Application
set app = new Word.Application

app.documents.add

app.ActiveDoument.ActiveWindow... ???

Thank you

Biasha

Scrollable Frame- (Microsoft Forms 2 Object Library)
Hi,
Thanks for your time. I am using the frame control from Microsoft Forms 2 object Library. It has provision for scrollbars.

When a picture box is added setting the container property gives an error...

Code:
Private Sub Form_Load()
Set Picture1.Container = Frame1
Picture1.Picture = LoadPicture("C: est.jpg")
Picture1.AutoSize = True

End Sub

The above code gives the error "invalid object use". Has anybody used this control? Can it be used as a container for a picture box like the traditional frame control?

Any help would be greatly appreciated...
regards,
M

Make .hWnd Available In Microsoft Forms 2.0 Object Library
Hi,

As I know MSForms is used for MS Office purpose in windowless state. But I need to use the controls in my vb6 application due to unicode issue for the old controls. However, the application has some requirement where .hWnd value is needed.

Is there any way to make the controls in MSForms library to have .hWnd? Responses will be much appreciated

Microsoft Outlook Object Library Missing In References
I am trying to add Microsoft Outlook Object Library from the references. It is not there. I also searched for a library named like "MSOL.OBL", but did not find anything.
I also tried to add "msoe.dll" (hoping it will work) but it also generated error and was not added.
Kindly show me a way out.

Regards,
Pir Qaiser Zaman

Microsoft Forms 2.0 Object Library - Combobox. Filling Up Error
Hello i am trying to fill up my forms 2.0 Combo box like this

this is how i call the module code

Code:
populatemulticombo combomachinename, "SELECT * FROM tblTASKfinishingMachines ORDER by MachineName", "MachineName", "finishingMachineID", "CategoryID"

in a module

Code:
Sub populatemulticombo(ByRef cbo As ComboBox, strSQL As String, ByRef strField As String, ByRef strfield2 As String, ByRef strfield3 As String)
Dim x As Integer
x = 0
Set rs2 = New ADODB.Recordset
rs2.Open strSQL, cn, adOpenStatic, adLockReadOnly
If rs.EOF Then
Else
Do Until rs2.EOF
cbo.AddItem
cbo.List((x), 0) = rs2.Fields(strfield2)
cbo.List((x), 1) = rs2.Fields(strField)
cbo.List((x), 2) = rs2.Fields(strfield3)
x = x + 1
rs2.MoveNext
Loop
rs2.Close
Set rs2 = Nothing
End If
End Sub

if i do this out of a module, it works fine! (obviously replacing variables with actualy object names etc)

but if i have it like this, i get this horrible error "Type Mismatch" Whenever i try to run it! then it highlights the call sentence.

Please could anyone help me?! i would be very grateful as always

-stewie

Converting Cmb.ItemData(cmb.NewIndex) Into Microsoft Forms 2.0 Object Library Control
Im currently converting VB.ComboBox to MSForms.ComboBox due to unicode issue.

Is there anyway to imitate the following code?

Code:
cmb.ItemData(cmb.NewIndex) = 0

MSForms.ComboBox doesn't support .ItemData and .NewIndex anymore.
I'm greatly appreciate for responses

Microsoft Excel 9.0 Library Error - Plz Help
Hello ALL VB Guru

I have littal problem with my Excel Library

I have Windows 98 + MS Office 2000 Installed on my PC
So I Used "Microsoft Excel 9.0 Object Library" in my Program

Where On Other PC there is Windows 2000 with SP4 and MS Office XP Installed

So Where I Run .EXE file (Working Perfactly on Win98 PC) on Win2000 PC then It Gives Error

run-time error `91`:
Object Variable or With block variable not set

So Is this error comes because of "Excel 9.0" Library or Because of Different OS ?

and If it comes because of Excel Library Mismatch then what is solution of that ?

I will be very Thankful to you if you solve this problem

Thanks in Advance

A Problem In Frame Control In "Microsoft Form2 Object Library"
Ok..It is that simple:
in the normal frame when i put on it a command button exemple and move the frame the command button will move with it..But in the Frame control in the "Form2 Obje......." it doesn't..I can't explain more because of my bad english..
There is an exemple in the Attachement..See what i mean
Try to move the normal frame and then the ather frame!

Excel Object Library
does someone knows where can I download the excel object library for excel 2000?

Excel Object Library
I am using VB6 and make a reference to the excel object library 8.0 in my program. If someone uses the program with Excel X, will the program still work?

Is there a way to reference all the excel librarys(sp?), Excel Object Library 8.0, 9.0 and 10.0?

Thanks for the help.

Excel Object Library
I'm developing an application which will run using Excel 97 but the PC I'm developing on has Excel 2000 installed. Will that give me trouble or how do I make sure that my app will be ok with 97?

Excel Object Library, Plz Help!!!
Hello, I want to calculate a math expression using the ms excel object library.
First, I add a reference (Project -> Add Reference->COM) to the Microsoft Excel 10.0 Object Library, then I write following code:

Public Class Form1
....
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim EXL As New Excel.Application()
' I want to evaluate 5*3+1
EXL.Evaluate("5*3+1")
End Sub
End Class

And the following message appears when I run the program:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in WindowsApplication3.exe

Additional information: Old format or invalid type library.

Could you please help me?? Do I make sth wrong?How could I fix it??
Thank you in advance?

Excel Object Library
hi
i am using vb 6.. installed excel 2000 in my machine.. but in references there is nothing named microsoft excel object library.. what is the problem.. does it requires re-installation of vb or excel or copying some files alone may help.. if so what files..

Excel 8 Object Library
Within my program I am accessing data from an Excel 97 spreadsheet. To do this I am using the Excel.Application, Excel.Workbook and Excel.Worksheet objects. I have added a reference to the Excel 8 object library, and all works fine.

However, I installed the program on another PC. This one does not have Office installed on it, but I made sure to check that excel8.olb got installed in the system32 folder (it's an NT box). When I try to run the program on this machine, it crashes with error 429: ActiveX component can't create object. This crash happens when it tries to instantiate the Excel.Application object.

Can anyone suggest why this is happening and post a solution? It would be much appreciated, and it's quite urgent. Thanks.

Excel 11 Or 12 Object Library In VB6
Hi,

I use VB6 to read data from Access and populate data on Excel Worksheets.

Currently I have Office 2003 installed on my development computer so in VB6, I use Microsoft Excel 11.0 Object Library reference.

In some cases, my customers may install Office 2007 on their own and use my VB application. Here are my questions:

1) If I compile my VB application with Excel 11 Object Library, will there be any problems to run the application on any machines with Excel 2007 (especially for creating and formating chart objects)?

2) If I install Office 2007 with Excel 12 Object Library on my development machine, then I compile my VB application. Should it work on any computers with Excel version 2000 to 2007? I think so but want to make sure.

3) Instead of installing Office 2007 on my computer, is there any Excel 12 Object Library plug-in which I can download and register on my computer so I can still compile my VB application?

Appreciate for any inputs.

Jeff

Excel 11 Or 12 Object Library For VB6
Hi,

I use VB6 to read data from Access and populate data on Excel Worksheets.

Currently I have Office 2003 installed on my development computer so in VB6, I use Microsoft Excel 11.0 Object Library reference.

In some cases, my customers may install Office 2007 on their own and use my VB application. Here are my questions:

1) If I compile my VB application with Excel 11 Object Library, will there be any problems to run the application on any machines with Excel 2007 (especially for creating and formating chart objects)?

2) If I install Office 2007 with Excel 12 Object Library on my development machine, then I compile my VB application. Should it work on any computers with Excel version 2000 to 2007? I think so but want to make sure.

3) Instead of installing Office 2007 on my computer, is there any Excel 12 Object Library plug-in which I can download and register on my computer so I can still compile my VB application?

Appreciate for any inputs.

Jeff

Various Excel Object Library
Hi folks

I made a small app to automate an excel spreadsheet from vb 6.0. it works fine when i run the program in the comp that has visual basic. I'm making the application in vb 6.0 SP5 in windows XP with Office XP.
When I created a setup using package and deployment wizard for that program and install it on Windows 98 with Office 97 or 2000 it doesn't run and gives me this error

"Run time error '-2147023067 (80070725)':Automation error

After looking at on various forums I decided to to try a better setup tool (Wise 5.1 and Installshiel 8). But I got the same result.

I know that Office XP is shipped with a different version of Object Library than Office 2000 or 97 (version 9 for Office 2000 and 10 for XP), so because my app has the 10.0 object version as a reference the program doesn't work.

I don't want to run multiple versions of Office on my computer or create different distribution depending the OS and Excel version.

I don't know if it is possible but I would like my setup to be able to install the right version of Object Library (8, 9 or 10) depending the target computer.

does it the right way to deal with this problem? Any other idea?

Thanks in Advance

Yann

Excel 8.0 Object Library
Hi ,

Anyone knows how to format an Excel column as Text before moving data to it
I was trying to move "2.10" to Excel as a string, but Excel misunderstands
that my data is numeric and it rounds it up to "2.1"

Thanks

Excel 8.0 Object Library
Hi,

I was trying to read Excel spreadsheets using Excel Object Library, and the
file is big (2 sheets , each has around 2000 rows).

I was some where near the end of my reading process when everything seems
to be hanging. I press Ctrl+Alt+Delete : evrything is not responding

And I've got Component Request Pending
message: "This action can not be completed because the application is busy.
Choose "Switch to " to activate the busy application and correct the problem"

I end up closing everything and have to reboot my computer.

Thanks for any help.