A program logs files at random in txt.
abc_log.txt (example)

When new info. is added to the txt file,manualy activate macro and it does what it suppose to do, all ok there.

Is there a way a macro code or excel, or perhaps a BAT program can be made to simply "detect" when new data is added to the txt file and activate the macro automaticaly ?

Thanks.

ScottGem

Not sure of the code, but you could read the date of the file and compare it to a date stored in the spreadsheet.

If you need help with coding this, you might try www.utteraccess.com and post your question there.

Sorry, the - shouldn't have been there

traka

Thanks
The URL does not seem to work.

traka

Solved.

A "detection device" had to be made by small external Utility Program (U.P.)

It activates a macro in excel without having to click on the activate key/button.

Much coding went into this and now the rest of the project may proceed.
The U.P. eliminates several mouse kliks.

Moral
Never give up.

traka

This issue has now been solved with software.
It works ok
Was very complex to define,but at the end of the day it got working.