I have Office97Pro, Office2000Premi um and OfficeXP Pro all installed. I'm
creating an Access97 application for another person and need to set a
reference to Microsoft Office 8.0 Object Library. When I look at my
references, all I have is Microsoft Office 10.0 Object Library. Why don't
have Microsoft Office 8.0 Object Library when I have Office97Pro installed?
What can I do to get a reference to Microsoft Office 8.0 Object Library?
Thanks!
Rolf
Nov 13 '05
13 18881
Same as for any other late binding:
Dim cbr As Object
Dim Ctl As Object
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Rolf" <rl*****@mycour t.com> wrote in message
news:fR******** *********@newsr ead3.news.atl.e arthlink.net... David,
Thanks for responding!
Do you have a response to my second question?
Rolf
"david epsom dot com dot au" <david@epsomdot comdotau> wrote in message news:41******** *************** @news.syd.swift dsl.com.au... during development. Why not use late binding during development? Early binding lets you use the Type Library during development. This lets you use AutoComplete, compilation checks, the Office help files, etc. Once you have it working on your PC, then you can remove the reference, and go through and remove all the type declarations and named constants, and use late binding for the object creation.
(david)
"Rolf" <rl*****@mycour t.com> wrote in message news:bw******** ********@newsre ad3.news.atl.ea rthlink.net... David,
Thank you for taking the time to respond!
Two questions --- 1. Why shouldn't I have a reference to the Office object library
except during development. Why not use late binding during development? 2. I need the Microsoft Office 8.0 Object Library to be able to work with the commandbars collection. I have included a sample of my code. How
do I apply late binding?
Dim cbr As CommandBar Dim Ctl As CommandBarCombo Box On Error GoTo ErrorHandler Set cbr = CommandBars("Co urseCalendarMen u") Set Ctl = cbr.Controls("M onth") Ctl.ListIndex = Month(Date)
Thanks!
Rolf
Thanks, Doug!
What about CreateObject; is that applicable?
Rolf
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:3f******** ************@ro gers.com... Same as for any other late binding:
Dim cbr As Object Dim Ctl As Object
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Rolf" <rl*****@mycour t.com> wrote in message news:fR******** *********@newsr ead3.news.atl.e arthlink.net... David,
Thanks for responding!
Do you have a response to my second question?
Rolf
"david epsom dot com dot au" <david@epsomdot comdotau> wrote in message news:41******** *************** @news.syd.swift dsl.com.au... > during development. Why not use late binding during development?
Early binding lets you use the Type Library during development. This lets you use AutoComplete, compilation checks, the Office help files, etc. Once you have it working on your PC, then you can remove the reference, and go through and remove all the type declarations and named constants, and use late binding for the object creation.
(david)
"Rolf" <rl*****@mycour t.com> wrote in message news:bw******** ********@newsre ad3.news.atl.ea rthlink.net... > David, > > Thank you for taking the time to respond! > > Two questions --- > 1. Why shouldn't I have a reference to the Office object library except > during development. Why not use late binding during development? > 2. I need the Microsoft Office 8.0 Object Library to be able to
work with > the commandbars collection. I have included a sample of my code. How do I > apply late binding? > > Dim cbr As CommandBar > Dim Ctl As CommandBarCombo Box > On Error GoTo ErrorHandler > Set cbr = CommandBars("Co urseCalendarMen u") > Set Ctl = cbr.Controls("M onth") > Ctl.ListIndex = Month(Date) > > Thanks! > > Rolf >
If you can create your objects by referring to some other object or
collection, you don't need the CreateObject. That's only required if you're
creating a brand new object.
To be honest, though, I'm not sure whether your reference to the CommandBars
collection is going to work if you don't have the reference set. You'll have
to try it and see.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Rolf" <rl*****@mycour t.com> wrote in message
news:es******** *********@newsr ead3.news.atl.e arthlink.net... Thanks, Doug!
What about CreateObject; is that applicable?
Rolf
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message news:3f******** ************@ro gers.com... Same as for any other late binding:
Dim cbr As Object Dim Ctl As Object
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Rolf" <rl*****@mycour t.com> wrote in message news:fR******** *********@newsr ead3.news.atl.e arthlink.net... David,
Thanks for responding!
Do you have a response to my second question?
Rolf
"david epsom dot com dot au" <david@epsomdot comdotau> wrote in message news:41******** *************** @news.syd.swift dsl.com.au... > > during development. Why not use late binding during development? > > Early binding lets you use the Type Library during development. > This lets you use AutoComplete, compilation checks, the Office > help files, etc. Once you have it working on your PC, then you > can remove the reference, and go through and remove all the type > declarations and named constants, and use late binding for the > object creation. > > (david) > > "Rolf" <rl*****@mycour t.com> wrote in message > news:bw******** ********@newsre ad3.news.atl.ea rthlink.net... > > David, > > > > Thank you for taking the time to respond! > > > > Two questions --- > > 1. Why shouldn't I have a reference to the Office object library except > > during development. Why not use late binding during development? > > 2. I need the Microsoft Office 8.0 Object Library to be able to work with > > the commandbars collection. I have included a sample of my code.
How do I > > apply late binding? > > > > Dim cbr As CommandBar > > Dim Ctl As CommandBarCombo Box > > On Error GoTo ErrorHandler > > Set cbr = CommandBars("Co urseCalendarMen u") > > Set Ctl = cbr.Controls("M onth") > > Ctl.ListIndex = Month(Date) > > > > Thanks! > > > > Rolf > > > >
On Dec 01 2004, 06:58 pm, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .com> wrote in
news:Zd******** ************@ro gers.com: To be honest, though, I'm not sure whether your reference to the CommandBars collection is going to work if you don't have the reference set. You'll have to try it and see.
At least in A97, this would sometimes work even without an explicit
reference to the Office library. Access is using the same library itself,
and it "shortcuts" some (not all) of the library's objects and methods so
that they can be used in your application code.
To be honest, I'd much rather set the reference and be done with it. The
library is present on every machine that has Access installed - unlike some
other libraries, I've yet to see this one cause any problems with broken
refs.
--
remove a 9 to reply by email This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Helene Day |
last post by:
I am trying to access the Word Objects from a .NET project.
I have some sample from
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/WordObject.asp
and I have MS Office 2003. However I don't know which file I need to
reference for the MS Word 11.0 Object Library.
Or what else do I need to install/download from MS to be able to create MS
Office 2003 Projects.
|
by: Rene Muench |
last post by:
Hi there,
I am running AccessXp and want to make use to the new filedialog object.
the references are set to: VBA, MS Access 10.0 Object Library, Ole
Automation, Microsoft Office 10.0 Object library,
Ms Dao 2.5/3.5 compatible library.
Public Function GetXXXfilePath() as String
Dim objDlg as Office.Filedialog
|
by: Steve |
last post by:
What would happen if an Access97 database had a reference to Microsoft
Office 10 library (but only used Access97 stuff) and it was run on a machine
that only had Access97 and correspondingly only had Microsoft Office 8
library? Would Access97 be smart enough to go to the Microsoft Office 8
library when it needed to?
Thanks,
Steve
|
by: |
last post by:
Hi!
How to extand and access the internat Office object structure.
Is there any Dev Kit for Microsoft Partners that in not available to
"normal" users?
Something like NOKIA back entrence!?
gicio
|
by: ©pEIO |
last post by:
I have installed the PIA of Microsoft Office 2003 and the installation was
succefully.
If I add the reference of Microsoft Excel 11.0, I see that the property
CopyLocal is False
and the assembly linked is
C:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Excel\11.0.0.0__71e9bce111e
9429c\Microsoft.Office.Interop.Excel.dll
But if I try to use the the assembly, I see that the object Range are
| |
by: Dean |
last post by:
I wrote a simple App in Access 2003 but used the 2000 file format. The
one module Requires reference to Microsoft Office 11.0 Object Library.
However, the person I have the code to has Office 2003 but only
Microsoft Office 9.0 Object Library.
Are they not backward compatible? Is there something the user can do
to update this to Office 11?
|
by: Michael Russell |
last post by:
Hi all,
Using C#, I've created a simple wrapper class for using Excel. I have
Office Pro 2003 installed on my devel machine. The wrapper class works
great, reading and writing to/from Excel. To do this, I created a
reference to "Microsoft Excel 11.0 Object Library", and have a "using
Excel;" directive.
I decided to add a method for creating a TextBox using the
Shapes.AddTextBox method, which requires a
|
by: Excel 009 |
last post by:
Hi,
In my office I have Office 2003 on the PC. I created an Access
application which has a component reference to Microsoft Office 12.0
Object Library.
The problem that I am having now it that in my home PC I also have
Office 2003, but I only have Microsoft Office 11.0 Object Library in
it and not Microsoft Office 12.0 Object Library, so the application
does not work right.
|
by: Sylfelin |
last post by:
Hello,
If I use Microsoft Outlook 12.0 Object Library (Outlook 2007) COM
Object in my application, the custommer must have the outlook 2007 on
his computer ?
But if i use Microsoft Outlook 11.0 Object Library (Outlook 2003) COM
Object in my application, the custommer must have the outlook 2003 or
outlook 2007 on his computer ?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |