Visual Basic :: If Add Reference To Excel 9.0 Object Library And Set Button On Toolbar , Error

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?

VB 6.0 MS Excel Object Library 10.0 And Toolbar Problem
Hi! I'd appreciate if anyone could help me ....

Referencing to Microsoft Excel 10.0 Object Library will generate Run time error 13 "Type Mismatch" at
Set btnX = Toolbar1.Buttons.Add(, "open", , tbrDefault, "open") line below but if MS Excel Object library 10.0 is unreferenced in my vb 6.0 prj, the toolbar works fine. I need to reference MS Excel Object Library 10.0 and the toolbar buttons. What can I do to eliminate this run time error?

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

Thank's in advance!

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?

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?

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?

Add A Reference To The MS Word Object Library To My Project
how do i reference a ms word object to my project

More Than 1 Excel Library Reference
Hi all, is it possible to include more than 1 version of excel object libraries for each vb application? I was not able to run my vb application on excel 2000, while the reference was for excel 2003's 11.0 object library. If not, is there any way to get around it?

Thanks alot!

Reference To Non-Shared Member Requires An Object Reference Error
I am getting a Reference to Non-Shared Member Requires an Object Reference on the (NorthwindDataSet.Customers) coding below. (NorthwindDataSet.Customers has squiggly Blue Line and Mouse hovered over has this error. Please see coding below. I just do not understand the weird error.
Any help to so I can proceed with my learning of VB. I am trying to learn a section of coding at a time and understand why I am getting these errors. This procedure is trying to filter a row and pull data.

Thanks for any help!

jjc9809

Private Sub btnCustomersFind_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles btnCustomersFind.Click

Dim filteredView As Data.DataView = _
New Data.DataView[B](NorthWindDataSet.Customers)

End Sub
End Class

Error Reference to a non-shared member requires an object reference is appearing on: NorthWindDataSet.Customers and has blue line underneath indicating the error in yellow.

Compile Error, Library Reference
I am trying to support a legacy application written in VB5. Since I can't find a VB5 install, I decided to use VB6 on XP Pro. While trying to compile the code, I get a "Compile Error" on some string functions (Space$, Left$, etc), and a dialog box pops up about project or library issue. Using F2, I find that those commands are part of VBA6.dll which I have installed.

What do I need to do get around these Reference library issues? Thanks in advance.

Cheers,
Edward

Add Reference Type Library At Runtime Excel 2002?
To Whom It May Concern,
I'm trying to add a reference to an OCX file at run-time or at least find a way that my users don't have to go to "Tools" "References" and "Browse" to add it to Excel VBA. Any ideas?
-jcm

ActiveX Component Can't Create Object Or Return Reference To This Object (Error 429)
MSDN talks about the "registry" and "setup program". I'm a beginner and CLUELESS! I tried to install Active X references and got the following notice: Name conflicts with existing module, project, or object library. The last line is where I get the run-time error in VB6:

Dim ppApp As PowerPoint.Application
Dim ppPres As PowerPoint.Presentation
Dim ppShape As PowerPoint.Shape
Dim ppCurrentSlide As PowerPoint.Slide
Dim msoTrue As New OLEObject
Dim msoFalse As New OLEObject
Dim oPicture As New OLEObject

Set ppApp = CreateObject("PowerPoint.Application")
ppApp.Visible = True

Set ppPres = ppApp.Presentations.Add(msoTrue)

Hope someone can help me....thanks Warren

Error Message - Object Reference Not Set To An Instance Of The Object
Can anyone help - I am trying to add a record (with no success!) The following code comes up with the error message Object reference not set to an instance of an object.at the line marked (***). Must be a simple reason but I can't work it out...

Cheers

John

Private Sub btnAddUser_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddUser.Click

OleDbDataAdapter1.Fill(DsAllProfile1, "tblProfile")
Dim objTable As DataTable
Dim drRows As DataRowCollection
Dim objNewRow As DataRow

objTable = DsAllProfile1.Tables("tblProfile")
drRows = objTable.Rows

(***)objNewRow("Default") = CBool("1")
objNewRow("ProfileWeight") = 233
objNewRow("ProfileName") = "Pablo"
objNewRow("ProfileDOB") = "23/02/71)"
objNewRow("ProfileSex") = CBool("1")

drRows.Add(objNewRow)

End Sub

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

Add Reference Library Crystal Report 9 ActiveX If Not Exist In Reference
I have a problem i want to use crystal report, the problem is when i want to add
crystal report in my reference it did not exist. Can anyone told me the solution for my problem...

Positioning Object Other Toolbar Button
I periodically use command buttons, combobox, or a textbox on a toolbar but position them After all toolbar buttons.

Anyway to have a series of buttons, then say a combobox and then more toolbar buttons?

If so, how do you set the positions of the buttons that come after the toolbar if they are loaded at runtime rather than placed at design time?

But I Get Error: Object Reference Not Set To An Instance Of An Object.
When I define my class like:

public class ProductEntity
{

private int productID;
// Public properties, to expose the state of the entity
public int ProductID
{
get { return productID; }
set { productID = value; }
}

......

then to bind the ProductID to my textbox.Text in a form I do:

textBox1.DataBindings.Add("Text", myProductObject, "ProductID");

But I get error: Object reference not set to an instyance of an object.

But When I initialize the value of productID like in

private int productID=0;

that fixes the problem

My question:

I don t see why I should initialize that value.

Is there a way not to get the error without initializing productID .

and what s a good practice for this pls (I mean binding Business entity classes to form controls)

Pls ignore this as I posted it in VB.Net section.
Thanks

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.

Excel Object Library
Hi

I want to append 1 more Sheet to my Workbook.
And I have trouble using :

dim MyWorkbook as Workbook
MyWorkbook.Worksheets.Add ([Before],[After],[Count],[Type]) as Object

What am I supposed to pass to [Before] or [After] ?

Thanks

Object-model Like The Toolbar's Button Collection<RESOLVED>
On a control I am making I want to use an object model like a toolbar's Buttons/Button collection. I will have an abstract interface class, a cButtons class, and a cButton class. These will reference the IconButton control that I made.

Here is what I am stuck with. Should I add the first button to the control at design-time so that I can just use a control array to load new buttons? Does anybody know if that is how a toolbar works under the hood, or does the toolbar not contain any buttons until you add them?

God Bless America

Edited by - IDontKnow on 6/7/2004 3:07:47 PM

Excel 8.0 Object Library Problem
I'm using VB 6 and I'm trying to write a program that will automate some Excel functions. I can open a new Excel Application and close it fine from within VB, but everytime I try to do some manipulation of the cells, rows, or columns I get an Automation Error -2147417848 (80010108).

The program works on another computer in the office (and I think the only difference is that it's running Windows Xp and mine is on 98, but it still uses VB 6 and MS Office 97). This made me think maybe my Excel 8.0 Object Library was corrupt. I've just recently uninstalled and reinstalled the Entire MS Office 97 suite. I get the same problem.

The following program demonstrates functions I'm trying to run and my methodology for doing so:

Code:
Private myExcel As Excel.Application
Private myWorkBk As Excel.Workbook

Private Sub Command1_Click()
Set myExcel = New Excel.Application
Set myWorkBk = myExcel.Workbooks.Add()
myExcel.Visible = True
myExcel.UserControl = False

End Sub

Private Sub Command2_Click()
Dim myrange As Excel.Range
Set myrange = myExcel.Range("A3:A7")
myrange.Formula = "Some Text" // <---- Errors Here
End Sub

Private Sub Command3_Click()
myExcel.Range("A3:A7").Copy myExcel.Range("D3:D7") // <---- Errors Here
End Sub

Private Sub Command4_Click()
myExcel.Quit
End Sub
I can click Buttons 1 and 4 all day long without a problem, but if I click 2 or 3 I get the automation error. Any help you can provide would be much appreciated.

Excel Object Library W/ VB6. Need Some Help/examples
After searching around the forums, I found a reference to the Excel Object library and some starting code:

Code:
Dim exl As Excel.Application
Set exl = New Excel.Application

etc..

How to I use the Excel Object Libary to just open Excel? (so I have a new workbook open to start interacting with). Every example I can find shows an existing sheet being open.

With what I'm doing I can not open an existing workbook or save a workbook. I just need Excel to open with a new blank workbook that I can use (interacting with it like the VB6 is really Excel VBA... all the good stuff).

Anyone have any good examples or links for the Excel Object Library?

Thanks...

Excel 9 Object Library Referencing
Hey All,

I got some great input from Paul Hinds about writting to an Excel file from VB, BUT when I try to run the additions to my previously running program I get error....
Referenced memory at "0x00000000". The memory could not be "read".

My thinking is that I am supposed to add Excel 9 object library in my referenced, but all I have available is Excel 10? How do I find the 9, if this is even my problem???

P.S. This is my favorite help site, some(I won't mention, but it's initials are esri) are not friendly at all.
Cheers
Debbie

Help Meee. Excel Object Library
i had vb 6 and excel 2000 installed in my machine.. found no excel object library in references.. then installed excel-97.. now found excel object lib 5 and 9..

my code goes like that
Dim objWrkSht As New Worksheet
dim X As Integer
Set objExcel = CreateObject("Excel.Application")

when 5 is used at
Dim objExcel As New Excel.Application
it displays
invalid use of new keyword

when 9 is used at
Set objExcel = CreateObject("Excel.Application")
it displays
variable uses automation type not supported in vb

wot is the problem.. i cant do any work becoz of that.. please reply me

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??

Loading Excel Object Library
Fairly new to this!

I want to use Excel functions in VB6, like NORMDIST (normal distribution) etc, and in a post by wdb on 4/11/2002, one way might be to load Excel object library into my project - but I can't see how to do this!

I've looked in the Project menu / Components / Controls, and can't see any .dll or .ocx, or anything that refers to Excel.

Running Office XP, WIndows XP, VB6 Pro with SP5.

Any ideas please?

Thanks.

Mid$() Error:CAN'T FIND THE OBJECT OR LIBRARY!
I don't know why this error occured.
If I checked out the OLE AUTOMATION in Project/reference...
That'll be ok,but other function couldn't work without the ole automation.
I wonder why?
Thanks for any suggestions.

Help Getting Error Object Library Invalid
hi,

I have an excel application with VB bas and cls modules behind it. It was working fine until I editted it and all of a sudden I am getting the error message "OBJECT LIBRARY INVALID OR CONTAINS REFERENCES TO OBJECT DEFINITIONS THAT COULD NOT BE FOUND". I checked the references and it looks fine and its not missing any reference ( I didn't change anything from the working version). I am not sure what's causing this error.

Any help will be greatly appreciated.

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

Excel Object Library Causes My Subs To Fail
I turned on the Excel object library (in the lowest priority position) and now a couple of my subs don't work. I at first thought that it was something to do with the names of the subs conflicting with the names of some of the methods of Excel Objects, so I changed the following names:

closeMenus
openMenus

to:

closeDecisionMenus
openDecisionMenus

But I still got the same error message (type mismatch). As soon as I turned off the Excel object library they worked again. Any ideas?

Here is the script for the subs

Public Sub closeDecisionMenus(ByRef theToolbar As Toolbar)
'This sub-routine disables the menus that should only be available when the user has a project open

Dim i As Long

For i = 1 To theToolbar.Buttons.Count
If Not theToolbar.Buttons.Item(i).Caption = "File" And Not theToolbar.Buttons.Item(i).Caption = "About" Then
theToolbar.Buttons.Item(i).Enabled = False
End If
Next i

i = Empty

End Sub

Public Sub openDecisionMenus(ByRef theToolbar As Toolbar)
'This method enables all menus in the project:

Dim i As Long

For i = 1 To theToolbar.Buttons.Count
theToolbar.Buttons.Item(i).Enabled = True
Next i

i = Empty

End Sub

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.

Excel Object Library Compatability Issues???
Quick question for any who know.

I have almost finished writing an app for reading the data out of XLS files and writing to a DB. All is working well (in thanks to people here) but I am concerned about compatability.

If the system I am installing on has an older or newer version of excel installed will this have any effect?

I wrote my app with the Excel 8.0 object lib (office 97) but users may be on office 95 (excel 5) or office 2000 (excel 9) I'm only using the RANGE and WORKBOOK objects but would like to hear more before distribution.

Thanks

Excel: Object Library Switching From 2000 To XP
I have an Excel workbook that was written with Excel 2000 that has references to, among others, Microsoft Word 9.0 Object Library. When the workbook is opened and saved with Excel XP, all 9.0 object library references change to 10.0. When the book is reopened in 2000 all references change back to 9.0 except the Word library, which causes a MISSING: Microsoft Word 10.0 Object Library error.

Using

ThisWorkbook.VBProject.References.AddFromGuid "{00020905-0000-0000-C000-000000000046}", 1, 0

to programmatically call the Word object library in the ThisWorkbook object works, but if an XP user saves the workbook it still causes the MISSING error for 2000 users. Plus, since VBA was changed, my digital certificate is dropped and everyone has to enable macros again.

To eliminate this problem I changed

Dim wdObj As Word.Application
Set wdObj = New Word.Application

to

Dim wdObj As Object
Set wdObj = CreateObject("Word.Application")

but now I don't have access to Word's formatting abilities.

I'm sure I could create a Word template and replace placeholders, but I'd prefer to generate the entire document on the fly. I'm hoping there's a way around this problem. Any ideas?

Thanks in advance.
Dave Kazebeer