Detect Data to save

[Former Member]

EPM 10 NW SP20 P2

I am using below API in excel auto_close routine to detect if user has any unsaved data and it works fine for a worksheet.

GetReportsDataCountToSubmit(ActiveSheet)

But my requirement is to detect unsaved data in the workbook all sheets, not just activesheet. Also this API is not detecting unsaved comments.

Any thoughts ..

1) Any equivalent for detecting workbook data

2) How to detect unsaved comments in workbook

~Dilkins

[former_member186338 · Accepted solution]

Hi Andrew,

1) Loop all worksheets with GetReportsDataCountToSubmit(ActiveSheet) (For each wsh in ThisWorkbook.Worksheets ...)

2) Looks like not possible!

Vadim