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 13 18878
On Nov 27 2004, 10:48 pm, "Rolf" <rl*****@mycour t.com> wrote in
news:1U******** *********@newsr ead2.news.atl.e arthlink.net: 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?
When you install a later version of Office on a machine with Office 97, the
newer version registers its own version of the Office library, which is
supposed to be backwards-compatible with the Office 97 version. If you set
a reference to v10.0 library in an Access 97 database (which is ok for
development, although you shouldn't use any features from the new library
that are not present in the old one), and then move the database to a
machine that only has Office 97 installed, Access will fix up the reference
so that the 8.0 version of the Office library is used.
That's how it _should_ work. It wouldn't be a bad idea to test it in your
environment.
--
remove a 9 to reply by email
My experience has been otherwise.
If I develop an application with a reference to Office 8.0 and put it on a
machine with Office 9.0, the "fix" is automatic, but not in the other
direction.
"Dimitri Furman" <df*****@cloud9 9.net> wrote in message
news:Xn******** *************** *****@127.0.0.1 ... On Nov 27 2004, 10:48 pm, "Rolf" <rl*****@mycour t.com> wrote in news:1U******** *********@newsr ead2.news.atl.e arthlink.net:
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? When you install a later version of Office on a machine with Office 97,
the newer version registers its own version of the Office library, which is supposed to be backwards-compatible with the Office 97 version. If you set a reference to v10.0 library in an Access 97 database (which is ok for development, although you shouldn't use any features from the new library that are not present in the old one), and then move the database to a machine that only has Office 97 installed, Access will fix up the
reference so that the 8.0 version of the Office library is used.
That's how it _should_ work. It wouldn't be a bad idea to test it in your environment.
-- remove a 9 to reply by email
"Rolf" <rl*****@mycour t.com> wrote in message
news:1U******** *********@newsr ead2.news.atl.e arthlink.net... 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?
Use late binding and it won't matter which version is present, and you app will
be less crippled on machines where NO version of the library is present.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Rick,
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
"Rick Brandt" <ri*********@ho tmail.com> wrote in message
news:30******** *****@uni-berlin.de... "Rolf" <rl*****@mycour t.com> wrote in message news:1U******** *********@newsr ead2.news.atl.e arthlink.net...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? Use late binding and it won't matter which version is present, and you app
will be less crippled on machines where NO version of the library is present.
-- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
"Rolf" <rl*****@mycour t.com> wrote in message
news:bZ******** *********@newsr ead2.news.atl.e arthlink.net... Rick,
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 Object
Dim Ctl As Object
On Error GoTo errorhandler
Set cbr = CommandBars("Co urseCalendarMen u")
Set Ctl = cbr.Controls("M onth")
Ctl.ListIndex = Month(Date)
It's called MSO97.dll It is normally in your (Office 97) Office
folder. It's not displayed because it is compatible with the
Office 10 version: the registry entry can point to one or the
other, but not both.
And you probably should not have a reference to the Office object
library except during development. Take out the reference,
check for compilation errors, and use late bound objects
(set obj = createobject).
(david)
"Rolf" <rl*****@mycour t.com> wrote in message
news:1U******** *********@newsr ead2.news.atl.e arthlink.net... 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
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
"david epsom dot com dot au" <david@epsomdot comdotau> wrote in message
news:41******** *************** @news.syd.swift dsl.com.au... It's called MSO97.dll It is normally in your (Office 97) Office folder. It's not displayed because it is compatible with the Office 10 version: the registry entry can point to one or the other, but not both.
And you probably should not have a reference to the Office object library except during development. Take out the reference, check for compilation errors, and use late bound objects (set obj = createobject).
(david)
"Rolf" <rl*****@mycour t.com> wrote in message news:1U******** *********@newsr ead2.news.atl.e arthlink.net... 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
> 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
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
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |