Excel with macros, xlsm files

Excel with macros, xlsm files

Posted by: f.kayser on 24 October 2017, 3:32 am EST

• 

  f.kayser

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 October 2017, 3:32 am EST

  Hello,

  when i open an excel xlsm file with macros (openexcel) and then save it with saveexcel i am unable to reopen the file with Excel.
  
  are thre specifics flags to open and save an excel xlsm file

  Thanks

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 25 October 2017, 7:17 am EST

  Hello,

  You need to use DocumentCaching ExcelOpenFlags and ExcelSaveFlags for macros to be preserved while opening and saving Excel.

  http://help.grapecity.com/spread/SpreadNet10/WF/webframe.html#FarPoint.Excel~FarPoint.Excel.ExcelOpenFlags.html
  
  http://help.grapecity.com/spread/SpreadNet10/WF/webframe.html#FarPoint.Excel~FarPoint.Excel.ExcelSaveFlags.html

  Hope it helps.

  Thanks,
  
  Reeva