473,322 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Modify VBA Reference Based on Office Version

EML
My application's front-end is installed on multiple machines running
different versions of MS Office. The app contains code that references
the Word and Excel object libraries that cause errors on the machines
that run older versions.

How can I automatically change the references to refer to the
appropriate library? Thanks.

Nov 13 '05 #1
3 5271
You can't. You can however use late binding, in which case your
automation code will still work.

Nov 13 '05 #2
EML
I don't know what late binding is. Can you explain how I would
implement that?

Nov 13 '05 #3
Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"EML" <el******@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I don't know what late binding is. Can you explain how I would
implement that?

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Konrad Den Ende | last post by:
I have a function returning a string but the problem is that the color of it is blue which suits me well for some pages but not for others. Is it possible to "feel" what the color of the background...
1
by: John | last post by:
Hi My pc had office xp previously. I uninstalled it and installed office 2000 instead. Now while in the references I see word/excel/outlook 9.0 references, the office reference is for 10.0 (xp)....
2
by: tc | last post by:
I would like to create an application that can modify the content and style(e.g. font size, font, style) in a MS Word document. Can anyone give me some idea/reference? thanks
1
by: Brian Mitchell | last post by:
Hello, I have an application that uses word automation and everything is working perfectly. However, I have one potential issue 1) I am using Office XP on my machine to design the app,...
2
by: Elena | last post by:
On the top of my form I have Microsoft.Office.Core and I get this task error: Namespace or type 'Core' for Imports 'Microsoft.Office.Core' cannot be found. When I checked the references, It says...
5
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. ...
1
by: Siv | last post by:
Hi, I referenced Excel via COM in References and selected the Excel Version 11.0 but somehow it picked up the Beta of Office 2007 in the Interop reference that gets pulled in as well. I decided...
1
by: =?Utf-8?B?Q2hyaXM=?= | last post by:
Hello: I have a C# Windows App that has a reference to the Word 2003 dll, which from my understanding of things will boil down to the Microsoft.Office.Interop.Word.dll PIA that lives in the GAC of...
7
by: Eran.Yasso | last post by:
Hi, I have project that automate excel(using Excel COM) which works fine in my home. I took the project from my home to work and tried to build the project but it won't built. I get error "The...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.