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

HELP: Debugging VB.NET Excel Add-In

I wrote an Excel Add-In in VB.NET using Visual Studio .NET 2003 and the
..NET Framework version 1.1.4322 on my previous machine. This machine
had MS Office 10 installed on it. With this configuration I was able
to run Excel from the debugger, my add-in loads on startup in Excel,
and I could debug my add in.

I got a new machine. This machine has both .NET 1.14322 and .NET 2.0
installed on it and it has MS Office 11 installed. It also has VS.NET
2003. I copied over the add-in project and rebuilt it. Then I ran my
installer to install the debug version on the machine (just as I did on
the previous machine). When I run under the debugger, Excel starts up
and then exits immediately. If I try again Excel starts and gives this
error message:

"Excel experienced a serious error the last time the add-in '<myaddin>'
was opened. Would you like to disable this add-in? To reactivate this
add-in, click About Microsoft Office Excel on the Help menu, and then
click Disabled Items"

If I disable it, I can launch Excel from the debugger, but (of course)
my add-in is disabled and does nothing. If I don't disable it, Excel
continues to exit immediately when launched from the debugger.

If I launch Excel normally, it starts up fine and my add-in is loaded
and runs. But, I can' t debug.

How can I fix it so I can launch Excel from the debugger and debug my
add-in?

Any help is greatly appreciated.

Apr 25 '06 #1
0 1758

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

Similar topics

2
by: Rudy Ray Moore | last post by:
Anybody notice that while debugging, excel (and some other apps) have a "hard time" opening? Anybody know why this is? "hard time" - takes 20 seconds to open, low CPU usage. I'm using VC++...
2
by: Mike Fellows | last post by:
within my VB.net app I use Excel a lot, so far I have used Dim excel_app As Object excel_app = CreateObject("Excel.Application") excel_app.Workbooks.Add() and parsed through the spreadsheet...
1
by: Steven | last post by:
Hello, I use the following code to make an Excel-file, which works fine with Excel 2003 (and the MS Excel 11.0 object library): Dim Excel As New Excel.Application Dim oBook As...
2
by: james | last post by:
Hi all, I am trying to convert some old VB6 code to .NET. Take this first section (there is more, but hey-ho...) Dim XLApp As Object Dim XLSheet Dim XLBook Dim HeaderItem As String Dim...
4
by: Melissa | last post by:
I currently have VBA written to export query results into an Excel file. That file is then formatted using the code below. The problem I'm having is that it keeps throwing Error 91 (Object...
1
by: Panteras | last post by:
Hi I am trying to do the following using a vbscript: connect to a database using an odbc connection and return the results to an excel file. Here is the script: ===============================...
4
by: ALaurie10 | last post by:
Hi have code below that enables a user to browse for data and import spreadsheet data. I keep receiving error message 3134 syntax error for "INSERT INTO" statement. Could someone please help me out?...
1
by: Schizoid Man | last post by:
Hi, At work I have Visual Studio 2005, and I can debug my Excel add-ins by attaching to the Excel.exe process and it works like a charm. However at home I only have access to Visual C# Express...
1
by: DennisBetten | last post by:
First of all, I need to give some credit to Mahesh Chand for providing me with an excellent basis to export data to excel. What does this code do: As the title says, this code is capable of...
1
by: ISATownsME | last post by:
HELLO world, this is my first post and heres my problem. I have an excel spreadsheet with 22 columns, and undefined amount of rows. I need vb.net to read the data from excel. Then use that data to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
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,...

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.