Excel add-in - .NET Framework

schouwla

I am a dotnet newbie..

Does anyone have experience with building an Excel add-in using dotnet?

NOW:
Currently I have programmed a VBA add-in that calls some C++ functions
in a dll.
The VBA code calls another VBA add-in for getting out market data (not
programmed by me).

POSSIBLE FUTURE ARCITECTURE:
I need to manipulate an Excel sheet so I guess I need vb.net for that?

If I want to create an Excel add-in then I only do that using C#?

How can vb.net and C# interact?

I still want to maintain my unmanaged C++ dll because I am doing
montecarlo simulations so need the performance of C++. Can vba.net call
an unmanaged C++ dll?

Any links to articles or code samles would be apreciated.

Regards
Lars Schouw

Jul 22 '05 #1

Subscribe Post Reply

2395

Wayne Wood

no problem i think

there're good supports for VB.NET or C# addin development for Excel
(actually every Office application)

there's no problem in interaction between vb.net and C#, you can
encapsulate the separate language code into separate assemblies, and
then do any references. or you can use basic tools provided by vs.net
to do it more freely.

calling typical C++ dll in VB.NET, according to my experience, will not
be difficult at all, but you have to pay enough attention on data type
conversion and so on, there'll be more details when you are on your real
way.

good luck

sc******@yahoo.com å†™é“:

I am a dotnet newbie..

Does anyone have experience with building an Excel add-in using dotnet?

NOW:
Currently I have programmed a VBA add-in that calls some C++ functions
in a dll.
The VBA code calls another VBA add-in for getting out market data (not
programmed by me).

POSSIBLE FUTURE ARCITECTURE:
I need to manipulate an Excel sheet so I guess I need vb.net for that?

If I want to create an Excel add-in then I only do that using C#?

How can vb.net and C# interact?

I still want to maintain my unmanaged C++ dll because I am doing
montecarlo simulations so need the performance of C++. Can vba.net call
an unmanaged C++ dll?

Any links to articles or code samles would be apreciated.

Regards
Lars Schouw

Jul 22 '05 #2

Similar topics

Automating Excel 97 and Excel 2000

by: Nick Carter | last post by:

The following C# lines of code work fine with Excel 2000:- ExcelApplication excelApplication = new Excel.Application(); ExcelWorkbook excelWorkbook =...

.NET Framework

how to use Excel.Workbooks

by: touf | last post by:

Hi, I've an error when I declare Dim oBook As Excel.Workbooks What imports, and reference do I need to use Excel.Workbooks class? Thanks

Visual Basic .NET

Problem with using Excel.Application object

by: msnnews.msn.com | last post by:

hi there, i've got a form that populates a datagrid, and a button that calls a function to export to an excel file. All is well with the export, no errors are returned, but the Excel instance...

Visual Basic .NET

vb .net and Excel 2000

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...

Visual Basic .NET

Datagrid Export to Excel - Report Headers

by: John Walker | last post by:

Hello, Below is my code for exporting a datagrid to Excel. It works fine, but we're going to need to somehow have a report header, user input parameters and system date display at the top of the...

ASP.NET

Add Header/Footer to excel report from ASP..

by: jmalvika | last post by:

Hi all, I'm trying to generate an excel report from an ASP web page using .. "response.ContentType = "application/vnd.ms-excel" .... I need to add a custom header & footer to the excel...

ASP / Active Server Pages

cannot terminate excel process

by: strider | last post by:

I have struggled with this problem and the solution is that you have to declare a variable for each and every object or collection within the Excel application that you want to use: For example:...

Visual Basic .NET

Help with talking to Excel from C#

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...

C# / C Sharp

Export complete database to excel file

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...

.NET Framework

Access VBA to run Macro when an excel toolbar button is clicked

by: JFKJr | last post by:

Hello everyone, the following is the code which opens an excel file and creates a toolbar button. And, when I click the toolbar button as shown at line #28, the code should call the "Example"...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

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...

Computer Hardware

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

Microsoft Access / VBA