Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I remove save prompts when I close a spreadsheet that was generated by xlsgen?

April 26, 2017prompts remove spreadsheet xlsgen

0

Posted

How can I remove save prompts when I close a spreadsheet that was generated by xlsgen?

1 Answer

0

Posted

The workbook.AutoRecalcOnClose property can be used to ensure that there is no prompt after closing a spreadsheet that was generated or updated by xlsgen. Simply set this property as autorecalc_standard. When I write values in pre-formatted cells, the formatting gets lost. Use the StyleOption = styleoption_preserve option available from the workbook object. There is a screen-recorded demo available here (Flash required) which shows how this works. Support email? . Two business days for an answer.