473,883 Members | 2,798 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to handle a missing VBA reference (To Excel)

365 Contributor
Hi guys,

I am in the process of migrating some access projects to 2010 (from 2003) and have hit another problem,

The background: we have upgraded some PC to office 2010, but not all, and some have had office removed (and we are using the viewers and access runtime).

Problem: in one project i have a reference to Excel (11.0) so that i can export some things straight to excel, now if excel isn't installed, it cant comit that reference, is there anything i can do to overcome this? (removing the reference invalidates the code objects, and it gets "all shouty")

i was thinking of somehow "blocking off" the excel code/modules if the reference couldn't be found, so that i didnt have to run two versions of the Front End.

Any ideas?

May 9 '12
10 12291
365 Contributor
Thanks again fellas, i must admit i do like to keep my code nice and tidy.

However, i'll give it a try, and if it becomes to tedious, ill just remove it and have a seperate version for PC with excel installed.

Ill let you know how i get on
May 11 '12 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Christian Lammel | last post by:
i'm looking for a possibility in C# to get a unique Int32 handle for an object reference. This handle must later (within the same process of course) be convertible back to an object reference (call it handle or pointer or whatever...). at the moment i'm working with a Hashtable Int32 to Object, but i want to optimize this. I know it is possible to work with pointers in unsafe code blocks, but as far as i know these pointer remain valid...
by: NickA | last post by:
I'm getting the following error: '<name>' is declared in project '<projectname1>', which is not referenced by project '<projectname2>' It just started showing up the last time I did a build. The reference is there in the project but for some reason, the IDE doesn't seem to recognize it. -- Nick
by: Richard Sherratt | last post by:
I have an Access 97 front end to an SQL Server 2000 database. One of the functions in the front-end generates an Excel spreadsheet using a template stored on a file server and plugs in some values before saving it. Sometimes, and I haven't yet been able to establish a pattern for when, the generated spreadsheet has missing references for mc2PDF and PDFMaker.XLA. The users are on SOE machines with Office XP apart from Access which is...
by: Gary | last post by:
Hi, there, I need to get the handle of a running excel application. However, there is no HWnd property. Following is my code: -------------------------------------------------------------- Process Processes = Process.GetProcesses(); for (int i = 0; i <= Processes.GetUpperBound(0); i++) { if (Processes.MainWindowHandle.ToString() == ExcelApp.Hwnd.ToString()) {
by: AP | last post by:
I have an app that has one small component that uses a reference to MS Outlook 9.0 to create an email. Now we have users on 9.0 and 11.0, sometimes it causes the reference to switch and this causes the missing reference issue. What is the best way to get around this? Thanks
by: bluewind44 | last post by:
Hello, I made a page that used for import data from .xls files. At this page, users upload the .xls file to the server, then the app uses an OleDB connection and the Jet provider to read the data using the OleDB DataAdapter, then I bind it to a datagrid. It works fine, but occationally some data is missing on a datagrid, especially number datas. Is anyone have same problem? or Is anyone can help me out?
by: =?Utf-8?B?amV6MTIzNDU2?= | last post by:
Hi experts. I have a c# widows program that uses 3rd party dlls. All works correctly on my PC but when I try to run the exe on another PC, I get an error indicating a missing reference. I checked the other PC and all the 3rd party the dlls are present and registered. Is there anything I can do to resolve this? Thanks
Nathan H
by: Nathan H | last post by:
I am getting this error when I install an Access 2007 db with the packaged runtime engine on a machine running Office 2003. When I look at the references on the developing PC, the Microsoft Excel Library is listed in the references. Any ideas how to begin to fix this problem?
by: NEWSGROUPS | last post by:
I am in the midst of trying to convert about 25 Access 2000 to Access 2003. The new environment consists of Office/Access 2003 and Outlook 2003. When converting the back ends I have no problems. When converting the front ends I get the following issues and error. If I try to import all the objects into a blank Access 2003 shell I get a missing reference error for Outlook 2000, Excel 2000, and Word 2000 or after importing all the objects...
by: DThreadgill | last post by:
Have a database that about 6 or 7 people use simultaneously with no problem and have for the past year or so. Have a new person that now needs to do work in there and she is getting Missing Reference: MS ActiveX Data Object 2.8 library. Upon checking her library, the latest version is 2.1. I don't want to make changes to the database and everything is working with ADO. What needs to be done to get her to version 2.8? Thanks in advance.
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: 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: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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...

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.