Geek asks and answers

Choosing between an Excel add-in, template, and workbook?

I am looking for some high-level help with determining the best type of Visual Studio 2010 project to use in a custom Excel application.

I will develop a program that requires the user to enter a data set in a certain way. Not using the form as such, but rather in the columns, and the program will have to perform some random check of the elements in order to prepare the data. From there, the user will be able to perform various operations with data through the user feed and related options. The program will also transfer data through a web service.

I deceived myself with the Add-In project, and it gives me a lot of everything I need, but I wonder if the user or template is better for this Template or Workbook project in terms of data entry and the ability to "lead".

How do you choose which type of project to use? Do all project types support custom feed?

+5
source share
1 answer

Sorry if this is too far from the topic. I mean VBA, not Visual Studio, but it can still be relevant.

Using AddIn, compared to a workbook, you can separate your code from user data. So, if the code is complex and you need to update it separately from user data books, this is not a bad idea.

AddIn , , check, , - . AddIn , Excel. , . AddIn, , , ..

, , , , - , , , . , , , .

AddIn (.xlam) ( ).

, .

+3

More articles:


All Articles