• Spreadsheet prompts for save in 1.0 to 1.3 - residual process

    By David Turner 1 decade ago

    I've recently noticed in release 1.3 that if a spreadsheet includes a value of NOW() or TODAY() or probably anything with a dynamic value, it displays a (hidden) prompt for save dialog when the Create Mail Merge script terminates, and the Excel process remains active in the background.

     

    In the Create Mail Merge script:

    MergeXLSpreadsheet.New() calls varXLApp.Workbooks.Open strXLFilename, 0, readOnly to open the file in read-only mode, but that doesn't seem to be sufficient.

    MergeXLSpreadsheet.Delete() simply calls varXLApp.Quit()

     

    I'll need to investigate either:

    1. how to quit without prompting for save, or,
    2. how to open without any value auto-calculation.
    • Close Workbook

      By David Turner 1 decade ago

      Probably want to close the workbook before quitting the Excel app instance. E.g.

       

      Call ActiveWorkbook.Close(False) ' closes the active workbook without saving any changes

       

      I'll have to try out this change in the next release.

    • Close Workbook - Fixed in 1.3.1

      By David Turner 1 decade ago

      The Workbook.Close(False) has been added in release 1.3.1 to close without prompting for save.