VBA in Excel

VBA in Excel

Posted by: tembel on 8 September 2017, 1:19 pm EST

• 

  tembel

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 1:19 pm EST

  Hi,

   

  I have an Excel workbook that contains both formulas and VBA scripts to calculate some stuff. I built it with Excel, of course.

  Will FPoint Spread be able to just read this sheet AS IS and perform the same calculations including Formulas AND VBA that already exists in the spreadsheet or would I have to make some modifications or recode the VBA in the application containing Spread or re-write the VBA or anything like that?
  
   
  
  Can someone point me to a Spread / .NET ready-built application that I can use as a spreadsheet to see its capabilities? (something that allows me to add VBA code will be highly appreciated).

   

  Thanks,

   

  Tembel.
• 

  bobm

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 1:19 pm EST

  Tembel -

  Our spread controls do not import any VBA scripts.
  
  

• 

  scotts-fp

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 1:19 pm EST

  Tembel,

  You can load Excel files into our Spread controls and all the formula strings will get loaded, but if any of the formula names are defined in VBA, they will not get calculated since the VBA script is not loaded. However, you can add custom names/functions into the Spread object after loading the Excel file by rewriting the VBA code in VB or C# and calling the AddCustomName or AddCustomFunction method of Spread to attach the new code.