Solved

Excel VB.net: VSTO vs .NET DLLs

Posted on 2013-02-05
5
433 Views
Last Modified: 2013-02-07
Hi

I develop VB.net Excel applications. I am currently on a project where an Excel spreadsheet containing thousands of lines of VBA has to be protected and moved over to VB.net. I want to used an Excel 2007 spreadsheet application while another developer says he wants to rather build a set of .net DLLs for it. What is the difference and what are the pros and cons
0
Comment
Question by:murbro
  • 2
  • 2
5 Comments
 
LVL 42

Accepted Solution

by:
sedgwick earned 333 total points
ID: 38858382
using separate .net dlls allows you to modify them in the future without the need to rebuild the whole excel application.
if the dlls are the heart and soul of your application it's a very good idea.
0
 
LVL 83

Assisted Solution

by:CodeCruiser
CodeCruiser earned 167 total points
ID: 38858891
DLLs would make it possible for you to reuse business and other common logic in other projects(for example winforms) if you need to.
0
 

Author Comment

by:murbro
ID: 38862863
Any cons concerning dlls
0
 
LVL 42

Assisted Solution

by:sedgwick
sedgwick earned 333 total points
ID: 38862939
the cons rises when u deal with different target platform (32/64 bit) or cross platform application.
in those cases its easy to have everything in a single executable and not dealing with marshaled data and being required to have 2 sets of dll's, 32bit and 64bit (although it hardlt ever happens).
overall, i can't think of a real reason not to use dlls.
another (big) advantage is unit testing.
when dealing with complicated business model, its easier to create test project which separately tests one or more dlls without running the whole application.
0
 

Author Closing Comment

by:murbro
ID: 38863053
Thanks very much for the help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

919 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now