Results 1 to 3 of 3

Thread: VSTO Application with Excel model

  1. #1
    VBAX Regular
    Sep 2021

    VSTO Application with Excel model

    Dear Gurus,
    I have a quite simple model in Excel which is made by a set of sheets where I'm inserting data in two tables, merging them through Power Query and I'm planning to add a sheet to perform a non linear regression calculation. The model already contains some data.

    Now, I would like to bind it to an application to be developed in VB by Visual Studio.
    I'm ignorant, but my expectation is to include the Excel model into the tool I will develop and have then a visual rendering through forms where I can add data into excel table and display the results.

    I understand this is also achievable through VBA directly in Excel, but I would like to have at the end an .exe file to installed on the laptop which will include the excel workbook too and connect to it automatically to save additional data and perform the needed calculation via forms.

    Now, is this possible? Am I missing any consideration on this? Is there any guide that I can follow to set this up?

    Thanks in advance,

  2. #2
    Listen, buddy, this is a great solution, but only if you use it to use it yourself and for small financial transactions. For example, to save your family budget

  3. #3
    Since such not particularly professional applications can spoil financial statements to large enterprises, if not a very qualified accountant in their hands. You know, I studied financial modeling paths using the platform and know about all the importance of this procedure. So be very neat with it! Good luck!!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts