Solved

Excel VB.net: VSTO vs .NET DLLs

Posted on 2013-02-05
5
431 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

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.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

747 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

12 Experts available now in Live!

Get 1:1 Help Now