Convert VBA Excel Workbook to Secure C# Excel Add-in with .dll (.msi file setup) -- 2
Budget: €250 – €750 EUR
Do not submit an offer without thoroughly reviewing the project, the project files, and the budget details!
• This project involves converting an advanced financial analysis Excel workbook
from VBA to C#. Currently, the Excel workbook uses VBA macros to analyze and
compare trial balance data across two or three financial periods. It dynamically
creates separate analysis sheets based on account codes and their mapping values in
the GL sheet. The VBA code performs automated grouping, sheet generation, and
financial calculations using data pasted into specific sheets (TB X, TB Y, TB Z,
Currency, and General Information). However, this VBA code is exposed, making it
vulnerable to being copied or altered by unauthorized users. The goal of the project
is to eliminate the VBA dependency and instead implement the entire logic in C# as
a secure Excel Add-in. This add-in must keep all theExcel formulas and structures,
allow user input in predefined sheets, and execute the same calculations securely.
The solution must be packaged as a .msi installer that, once installed, adds a ribbon
called 'Audit-Tool' in Excel with a button labeled 'Breakdown'. Clicking this button
will load the template file, wait for user input, and execute the analysis, finally
prompting the user to save the output file
WHAT I NEED :
I want to develop a C# Excel Add-in using Visual Studio Tools for Office (VSTO). The add-in should include a new ribbon tab labeled 'Audit-Tool' with a button named 'Breakdown'. When this button is clicked, it should open an Excel template that retains all necessary formulas but excludes any sensitive data or macros. Users should be able to paste their data into sheets such as TB X, TB Y, TB Z, Currency, and General Information, just as they currently do.
Once the user provides the required data and inputs, the tool should detect whether a two-period or three-period analysis is needed. Based on this, the C# backend should handle the analysis logic — including grouping account codes by the first three digits and mapping values from the GL sheet. The tool should dynamically create any required sheets, populate the necessary formulas, and generate the final report in Excel, replicating the functionality of the current VBA-based version — but within a more secure, managed environment.
Importantly, the solution must not use any VBA or macro code. All processing logic should be compiled within the DLL to protect intellectual property and enhance security. At the end of the process, the add-in should prompt the user to select where to save the final output file.
Please note: This is a time-consuming project that involves a high level of detail, and precision is critical throughout the implementation.
• This project involves converting an advanced financial analysis Excel workbook
from VBA to C#. Currently, the Excel workbook uses VBA macros to analyze and
compare trial balance data across two or three financial periods. It dynamically
creates separate analysis sheets based on account codes and their mapping values in
the GL sheet. The VBA code performs automated grouping, sheet generation, and
financial calculations using data pasted into specific sheets (TB X, TB Y, TB Z,
Currency, and General Information). However, this VBA code is exposed, making it
vulnerable to being copied or altered by unauthorized users. The goal of the project
is to eliminate the VBA dependency and instead implement the entire logic in C# as
a secure Excel Add-in. This add-in must keep all theExcel formulas and structures,
allow user input in predefined sheets, and execute the same calculations securely.
The solution must be packaged as a .msi installer that, once installed, adds a ribbon
called 'Audit-Tool' in Excel with a button labeled 'Breakdown'. Clicking this button
will load the template file, wait for user input, and execute the analysis, finally
prompting the user to save the output file
WHAT I NEED :
I want to develop a C# Excel Add-in using Visual Studio Tools for Office (VSTO). The add-in should include a new ribbon tab labeled 'Audit-Tool' with a button named 'Breakdown'. When this button is clicked, it should open an Excel template that retains all necessary formulas but excludes any sensitive data or macros. Users should be able to paste their data into sheets such as TB X, TB Y, TB Z, Currency, and General Information, just as they currently do.
Once the user provides the required data and inputs, the tool should detect whether a two-period or three-period analysis is needed. Based on this, the C# backend should handle the analysis logic — including grouping account codes by the first three digits and mapping values from the GL sheet. The tool should dynamically create any required sheets, populate the necessary formulas, and generate the final report in Excel, replicating the functionality of the current VBA-based version — but within a more secure, managed environment.
Importantly, the solution must not use any VBA or macro code. All processing logic should be compiled within the DLL to protect intellectual property and enhance security. At the end of the process, the add-in should prompt the user to select where to save the final output file.
Please note: This is a time-consuming project that involves a high level of detail, and precision is critical throughout the implementation.