How to detect modified file before it saved?

[lsakizada]

For instance

1) A file opened

2) Some text inserted into the file but without saving the file.

Is there a way to detect the status of the file?.

[PsaltyDS]

For instance

1) A file opened

2) Some text inserted into the file but without saving the file.

Is there a way to detect the status of the file?.

That doesn't actually make sense. If you FileOpen() for write, and then FileWrite() anything, it is already saved.

You probably mean you did FileRead() (or maybe _FileReadToArray()), changed data in memory, and want to track changes. That would be handled by a flag variable like:

Global $fDataChanged

Where you read the data into memory, add "$fDataChanged = False", and anywhere in your script where you change any of the data, add "$fDataChanged = True". When it is time to decide if it needs to be saved, it would just be:

If $fDataChanged Then

[lsakizada]

That doesn't actually make sense. If you FileOpen() for write, and then FileWrite() anything, it is already saved.

You probably mean you did FileRead() (or maybe _FileReadToArray()), changed data in memory, and want to track changes. That would be handled by a flag variable like:

Global $fDataChanged

Where you read the data into memory, add "$fDataChanged = False", and anywhere in your script where you change any of the data, add "$fDataChanged = True". When it is time to decide if it needs to be saved, it would just be:

If $fDataChanged Then

I think you missed my point.

I am actually openning excel file, and typing some text into a cell.

At this point I want to know that the file modified with no save.

I want to know that status since my application is crashing inside the excel UDF file.

here is a link to my example with reproduction steps.