473,396 Members | 2,081 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,396 software developers and data experts.

problem deploying an app with Excel interop

Hi all,

I've created a vb.net app that opens and manipulates an excel file. The app
works great on my system where I have all of the interop assemblies installed
for visual studio. When I go to run the application on another PC I get this
error:

File or assembly name Microsoft.Office.Interop.Excel, or one of its
dependencies, was not found.

On the target machine, there is a copy of excel2002 installed. In the
vb.net project I'm using the Microsoft Office 10.0 Object Library. I've
added references to Excel and to Microsoft.Office.Core to the project.

How do I set up the project so that any of the requisite interop files are
included with the project? Or at the very least, how do I figure out which
files have to be copied where to make it work?

TIA,
Mike E.

Nov 21 '05 #1
2 4159
I cant remember office 2002 but in 2003, the programability ( Interop )
support is an optional install. This may be the same for 2002? check your
advanced setup.

However, if you are going to need this on lots of machines, then you will
need to check the assemblies are there, I think your going to have to do
some research and I would advise to check this data on an office programmers
ng

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"Mike Eaton" <Mi*******@discussions.microsoft.com> wrote in message
news:AB**********************************@microsof t.com...
Hi all,

I've created a vb.net app that opens and manipulates an excel file. The app works great on my system where I have all of the interop assemblies installed for visual studio. When I go to run the application on another PC I get this error:

File or assembly name Microsoft.Office.Interop.Excel, or one of its
dependencies, was not found.

On the target machine, there is a copy of excel2002 installed. In the
vb.net project I'm using the Microsoft Office 10.0 Object Library. I've
added references to Excel and to Microsoft.Office.Core to the project.

How do I set up the project so that any of the requisite interop files are
included with the project? Or at the very least, how do I figure out which files have to be copied where to make it work?

TIA,
Mike E.

Nov 21 '05 #2

Hi all,

I've created a vb.net app that opens and manipulates an excel file. The app
works great on my system where I have all of the interop assemblies installed
for visual studio. When I go to run the application on another PC I get this
error:

File or assembly name Microsoft.Office.Interop.Excel, or one of its
dependencies, was not found.

On the target machine, there is a copy of excel2002 installed. In the
vb.net project I'm using the Microsoft Office 10.0 Object Library. I've
added references to Excel and to Microsoft.Office.Core to the project.

How do I set up the project so that any of the requisite interop files are
included with the project? Or at the very least, how do I figure out which
files have to be copied where to make it work?

TIA,
Mike E.


User submitted from AEWNET (http://www.aewnet.com/)
Nov 21 '05 #3

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

Similar topics

1
by: Steve B. | last post by:
Why does Office create a compile error when doing a Release compile but not when doing a Debug complie. Release compile is compiled to the network share drive - Excel Interop is added as a...
2
by: Alex D. | last post by:
Hi .I cant seem to find a way to authorize asp.net user to create an Excel application using this: Microsoft.Office.Interop.Excel.ApplicationClass excel = new...
4
by: goonsquad | last post by:
I'm writing an Excel Automation app and I'm running to a problem early on with what should be a basic step. Dim oExcel As Object Dim oBook As Object Dim oSheet As Object Dim oRng As...
5
by: kewalmehra | last post by:
Hi All, I have a requirement of saving Excel files as HTML using C#. I have managed to write code for saving as HTLM file. however this seems to be not working in the once perticular case . ...
5
by: Mike in Santa Rosa | last post by:
I'm trying to get a simple c# app built that can launch/manipulate an excel workbook, sheet. I've chased down several examples and can't any of them to work. So I must be doing somethnig obviouslt...
2
by: jereviscious | last post by:
Hi all - Last resort time. I'm importing data from a spreadsheet that I receive from one of my vendor using interop.excel. The date field in excel is entered as 4/7/2006, but when I retrieve...
5
by: =?Utf-8?B?U3R1YXJ0?= | last post by:
Hi There I have been having a play around with the following code to display a datagrid in Excel (all from Steve Orr's site): Private Sub btnTechServAccred_Click(ByVal sender As System.Object,...
0
by: Nicholas Dreyer | last post by:
Operating System: Microsoft Windows Version 5.1 (Build 2600.xpsp_sp2_gdr.050301-1519 : Service Pack 2) Visual Basic: MIcrosoft Visual Basic 6.3 Version 9972 VBA: Retail 6.4.9972 Forms3:...
2
by: Nicholas Dreyer | last post by:
The following error Run-time exception thrown : System.Runtime.InteropServices.COMException - Error loading type library/DLL. happens while running the code listed at the bottom of this...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
Oralloy
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,...
0
jinu1996
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...

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.