473,226 Members | 1,382 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,226 software developers and data experts.

Excel add-in

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
1 2390
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

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

Similar topics

0
by: Nick Carter | last post by:
The following C# lines of code work fine with Excel 2000:- ExcelApplication excelApplication = new Excel.Application(); ExcelWorkbook excelWorkbook =...
5
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
4
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...
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: 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...
4
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...
0
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:...
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...
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...
3
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"...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.