Macro enabled spreadsheets

Macro enabled spreadsheets

Posted by: richard.gordon on 31 August 2018, 2:20 am EST

• 

  richard.gordon

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 August 2018, 2:20 am EST

  We are currently evaluating documents for excel and have a query about macro enabled spreadsheets (xlsm format). What we would like to do is open the spreadsheet update a load of cell values then save the spreadsheet as an xlsm format again. Not to bothered about gcExcel being able to update cells based on the macros but would like to be able to keep the format as ultimately the end user would open the file using a copy of Excel which would run any VBA macros at that point.

  Although looking further forward it would be nice if the product was able to run VBA code directly.

  At the moment the only save format seems to be xlsx which will lose any VBa macros saved in the document.

• 

  manpreet.kaur

  • Post Options:
  • Link
    Copy

  Posted 2 September 2018, 10:37 pm EST

  Hello,

  Unfortunately, Grapecity Documents for Excel currently does not supports macro operations. We have escalated the issue to the concerned team for further discussion. We will let you know as soon as we get any information in this regard.

  We deeply regret the inconvenience caused.

  Thanks,
  
  Manpreet Kaur

• 

  manpreet.kaur

  • Post Options:
  • Link
    Copy

  Posted 3 September 2018, 5:07 pm EST

  Hello,

  The issue has been escalated and the internal tracking ID for the same is 341784. We will keep you posted with the information received from the development team.

  Thanks,
  
  Manpreet Kaur

• 

  venkat.pasumati

  • Post Options:
  • Link
    Copy

  Posted 15 June 2022, 11:48 pm EST

  Was this feature ever implemented for GcExcel .Netcore?

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 16 June 2022, 7:46 pm EST

  Hello Venkat,

  Yes, this feature has been implemented for the GcExcel API.
  
  Please see the following documentation link for the same:
  
  https://www.grapecity.com/documents-api-excel/docs/online/ImportandExportMacros.html

  Regards,
  
  Prabhat Sharma.