LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default Office Object Libraries

Bob,
Your reply somehow got overlooked, and I just discovered it. Thanks for your
suggestion. I was going to use early binding building the app with Office 97
to make it workable for a prospective client with that version, but I am
wondering if late binding would be best despite a little speed bump. I am not
sure if my app would lose any functionality of later versions with early
binding, but if I recall with late binding it would just pull in the
libraries for whatever version is being used which might be best in my case
as you indicated.
Thanks again, and God bless
Van

"Bob Phillips" wrote:

Use late binding.

Dim oWordApp As Object

Set oWordApp = CreateObject("Word.Application")

etc.

--

HTH

RP

"VanS" wrote in message
...
Hello,
I have an Excel/ Word VBA application using automation. I am trying to

make
it backward compatible to at least Office 2000. My development system has
Office 2003 but the Excel .xls file with MS Office Object Library, MS

Excel
Object Library and MS Word Object Library is on another system with OFfice
2000 in order to bring in the object libraries for that version of

Office(to
make it backward compatible). This latter system is not workable to

develop
on, so the problem is that when I bring the xls file from the Office 2000
into my development box with Office 2003 , the object libraries are

converted
to those for Office 2003, or version 11.

I need to package my app on the newer system, but does anyone know a way

to
retain the older object library versions when I import them into the newer
system?
Thanks, God bless
Van




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help locating Object Libraries Ayo Excel Discussion (Misc queries) 2 November 6th 09 09:09 PM
Saving from Excel to MS Office Drawing Object sir23 Excel Discussion (Misc queries) 4 February 19th 08 02:53 AM
Reference to Office 11.0 Object Library Steph[_3_] Excel Programming 1 September 29th 04 08:08 PM
Using Outlook Object Libraries V8 & 9 Kevin Excel Programming 2 April 21st 04 03:55 PM
Object libraries Lionel Fridjhon Excel Programming 9 August 29th 03 01:20 PM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"