Check out some similar questions!

traka · Feb 11, 2005, 09:37 AM

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 · Feb 17, 2005, 11:39 AM

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 · Feb 17, 2005, 03:03 PM

Thanks
The URL does not seem to work.

traka · Jun 29, 2005, 01:21 AM

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 · Jul 4, 2005, 06:09 AM

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.