macro to record all actions in excel

i have several workbooks that ask to save, even if i haven't done anything to the workbook.

so i need a macro to save the log file in my personal.xlsb so i can review what is going on with the workbooks.

need to see the name of the workbook, the actions taken and the date/time that they occurred.

i searched the net (and this forum) but didn't find any results that i could use.

can this be done?

Hi there,

i have several workbooks that ask to save, even if i haven't done anything to the workbook

This can be puzzling until you realise that things like the evaluation of volatile functions (e.g. Now()) count as "changes" to a workbook.


The following link might be useful if you wish to implement some sort of logging facility:

https://www.excelforum.com/excel-pro...ml#post5184881

Hope this helps.

Regards,

Greg M

Greg,

I looked at the thread and downloaded the xlsm file but at a loss on how to:

1) record every excel action that is made to any open file
2) print out the workbook full-name, the cell address, and the change to the cells value or formula. put in sheet "Logfile" on the personal.xlsb workbook.

Can you help with that?

Hi again,

Wow! That would definitely NOT be a "quickie"!

At best you might manage to record actual changes (not calculation changes) to cells, and this could be a HUGE output if (e.g.) someone were to delete an entire column. In such a case an entry would probably be written to the logfile for EACH cell in the column

Sorry if that's not what you want to hear, but I'd certainly be happy to be contradicted on this.

Regards,

Greg M

just trying to track down what is making my files appear as if they have saved. i understand that this might be big (but really not) if i were to delete a column (wont do). just need to see why the file's appear as if changed. is that something that could be done in just those files? really only two concern me, my vendordatabase.xlsm and projectinfo.xlsm. would that make it easier?

Hi again,

Just a quick question/suggestion - is it possible that the "Workbook_Open" routine is doing something that counts as a workbook "change"? As a general rule I always include a "ThisWorkbook.Saved = True" statement at the very end of the "Workbook_Open" routine.

I'll have a think about your logging requirements, but I don't think it's going to be easy

Regards,

Greg M

.
Here is a tracker project that registers most all changes :

Please Login or Register  to view this content.

Originally Posted by Norie

Is there any code in the files?
Are there formulas?
Named ranges?
Dynamic named ranges?
Links to other files?

so no formulas, but do have named ranges (that are not dynamic)

do have a workbook open on projectinfo but that is just changing some settings. disabled the code in ThisWorkbook, saved it, closed it and reopened it. still same behavior.

Originally Posted by Logit

.
Here is a tracker project that registers most all changes :

Let me give this a whirl and i will let you know. thanks in advance for doing this.

so i made a few changes to the sheetchange event. see below. question is how to set this up with personal.xlsb so that it scans all open workbooks?

Please Login or Register  to view this content.