Solved

Excel VB.net Add-in vs Managed Spreadsheet

Posted on 2013-01-13
2
246 Views
Last Modified: 2013-01-14
Hi. I am developing several add-ins in tandem and find that the SheetChange causes complication because it fires no matter which add-in you are using. I was thinking of just foing a straight Excel 2007 Workbook application instead. What are the advantages of doing it this way?

    Private Sub Application_SheetChange(ByVal Sh As Object, ByVal Target As Microsoft.Office.Interop.Excel.Range) Handles Application.SheetChange
        MsgBox("Hello")
    End Sub
0
Comment
Question by:murbro
2 Comments
 
LVL 11

Accepted Solution

by:
jkpieterse earned 500 total points
ID: 38773650
It all depends on what your application/add-in needs to do and what not and what this SheetChange event is supposed to do and when it is NOT supposed to do it.

So if you can try to explain that to us perhaps?
0
 

Author Closing Comment

by:murbro
ID: 38774599
thanks
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Multiple Open Excel Spreadsheets 12 41
Help with converting xml file to excel using VB.NET 3 20
Excel - Data Validation 3 28
excel count months in date range 6 12
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question