Click here to Skip to main content
16,018,653 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: Creating an invoice in Asp.net core Pin
Eddy Vluggen6-Mar-21 10:12
professionalEddy Vluggen6-Mar-21 10:12 
QuestionEasing the pain of updating code - Excel macros Pin
Roy935-Mar-21 20:36
Roy935-Mar-21 20:36 
AnswerRe: Easing the pain of updating code - Excel macros Pin
Dave Kreskowiak6-Mar-21 5:23
mveDave Kreskowiak6-Mar-21 5:23 
GeneralRe: Easing the pain of updating code - Excel macros Pin
Roy936-Mar-21 8:02
Roy936-Mar-21 8:02 
AnswerRe: Easing the pain of updating code - Excel macros Pin
Mycroft Holmes6-Mar-21 11:14
professionalMycroft Holmes6-Mar-21 11:14 
GeneralRe: Easing the pain of updating code - Excel macros Pin
Roy936-Mar-21 12:56
Roy936-Mar-21 12:56 
GeneralRe: Easing the pain of updating code - Excel macros Pin
Mycroft Holmes6-Mar-21 15:16
professionalMycroft Holmes6-Mar-21 15:16 
AnswerRe: Easing the pain of updating code - Excel macros Pin
Lex Goodies16-Mar-21 14:55
Lex Goodies16-Mar-21 14:55 
"
Will users need to install anything locally? 
"

Yes. I've some experience creating and deploying VSTO's. These addins are installed manually. The few ones I made were Controls (visual components with graphics in it) and some Excel Basic function extensions. You can define a Basic function in a VSTO. The sheet - or template - contains the basic code calling the VSTO. Buttons can be defined, to let the Excel create a graphics control on the sheet that is defined in the VSTO.

It works for 365. But this is not without pitfalls. The validity of a VSTO depends on the Excel version installed. If you want to use VSTO, see you standardize your users on one version of excel, before trying to distribute your VSTO. Once your VSTO is installed, it can be replaced by a newer version if needed, by manually uninstalling it, leaving Excel, entering Excel again and install the new version of the VSTO.

So, bottom line: nstead of these 130 sheets, your will worry about all these PC's that need to install your addin. An addin is not like a template on a share. It is NOT updated automatically of you correct errors in your VSTO code ! So in short, I'm afraid VSTO is not the solution to your problem. If you really want dynamic code support, use scripts instead, like Powershell or C-script. You could use Excel interop to generate sheets..

Anyway in the end this will give a version maintenance mess. What would be a solution.. is making an inventory of what you trying to visualize in these sheets, devise a data model, implement a database for all data involved. Then export views from that database and (only) visualise using VSTO. From Excel, you can access the database directly and queries are stored in the templates. Your data should reside in a central place, not in 130 Excel sheets.

And yes alas.. this is an expensive project.
QuestionCultureAwareComparer deserialization on .NET 4.6 Pin
Member 1508036222-Feb-21 15:54
Member 1508036222-Feb-21 15:54 
AnswerRe: CultureAwareComparer deserialization on .NET 4.6 Pin
Richard Andrew x6423-Feb-21 14:06
professionalRichard Andrew x6423-Feb-21 14:06 
QuestionSOAP xml Formatting Pin
Member 1508036222-Feb-21 15:51
Member 1508036222-Feb-21 15:51 
AnswerRe: SOAP xml Formatting Pin
Dave Kreskowiak22-Feb-21 17:30
mveDave Kreskowiak22-Feb-21 17:30 
QuestionNot All On Pin
michaelbarb16-Feb-21 4:14
michaelbarb16-Feb-21 4:14 
AnswerRe: Not All On Pin
Gerry Schmitz16-Feb-21 6:22
mveGerry Schmitz16-Feb-21 6:22 
GeneralRe: Not All On Pin
michaelbarb16-Feb-21 8:49
michaelbarb16-Feb-21 8:49 
AnswerWhat Objects are Included Pin
michaelbarb22-Feb-21 12:24
michaelbarb22-Feb-21 12:24 
GeneralRe: What Objects are Included Pin
Dave Kreskowiak22-Feb-21 14:42
mveDave Kreskowiak22-Feb-21 14:42 
GeneralRe: What Objects are Included Pin
michaelbarb23-Feb-21 5:28
michaelbarb23-Feb-21 5:28 
GeneralRe: What Objects are Included Pin
Dave Kreskowiak23-Feb-21 5:35
mveDave Kreskowiak23-Feb-21 5:35 
Questioni need instruction for creating simple game in .Net Core C# Pin
Member 150636903-Feb-21 4:54
Member 150636903-Feb-21 4:54 
AnswerRe: i need instruction for creating simple game in .Net Core C# Pin
Dave Kreskowiak3-Feb-21 5:45
mveDave Kreskowiak3-Feb-21 5:45 
AnswerRe: i need instruction for creating simple game in .Net Core C# Pin
Gerry Schmitz3-Feb-21 6:28
mveGerry Schmitz3-Feb-21 6:28 
AnswerRe: i need instruction for creating simple game in .Net Core C# Pin
Richard MacCutchan3-Feb-21 6:45
mveRichard MacCutchan3-Feb-21 6:45 
QuestionAnyone familiar with Ozgur Ozcitak ImageListView control ? Pin
Member 113774652-Feb-21 19:43
Member 113774652-Feb-21 19:43 
AnswerRe: Anyone familiar with Ozgur Ozcitak ImageListView control ? Pin
Gerry Schmitz3-Feb-21 6:32
mveGerry Schmitz3-Feb-21 6:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.