Ask Experts Questions for FREE Help !
Ask
    traka's Avatar
    traka Posts: 50, Reputation: 1
    Junior Member
     
    #1

    Feb 11, 2005, 09:37 AM
    How to Automate a macro in excel
    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    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's Avatar
    traka Posts: 50, Reputation: 1
    Junior Member
     
    #3

    Feb 17, 2005, 03:03 PM
    Thanks
    The URL does not seem to work.
    traka's Avatar
    traka Posts: 50, Reputation: 1
    Junior Member
     
    #4

    Jun 29, 2005, 01:21 AM
    Solved
    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's Avatar
    traka Posts: 50, Reputation: 1
    Junior Member
     
    #5

    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Macro system [ 2 Answers ]

:confused: what do you think is the most significant macro system in today's family life. (church, Social agencies, health care program, etc)

Excel [ 2 Answers ]

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...

Hyperlink in Excel [ 1 Answers ]

Dear Ask me, Could you please tell me how to create a hyperlink In Excel so that it opens a specific word in a Word Document? Thanks, Cris


View more questions Search