Jump to content
Macro Express Forums

Asm0deus

Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by Asm0deus

  1. I have a loop that repeats over and over. I can't remember how to program a timer in beginning that says

     

    If X = 10 minutes then do this action

     

    In other words, I want the macro to only do something every [x] amount of minutes while continuing a short loop thats maybe 30 seconds long.

     

    Any help is greatly appreciated!

  2. Hello everyone.

     

    I been away from the macex world for about 6months and trying to work on an old macro of mine.

     

    I can't remember how to go about reversing the output of one text file into another.

     

    TextFileA TextFileB

     

    123456 012345

    234567 567890

    345678 456789

    456789 345678

    567890 234567

    012345 123456

     

    The number of entries will be anywhere from 5-100 so I cant assign which slot to start on. Im pretty embarrsed I dont remember how to do this. Someone give me a hand?

  3. Hello.

    Been using macro express for quite a while and fairly knowledgable. I wanted to see if anyone had a macro idea for something I made up but takes to much processing time. I am creating this for work

    ---

    Create a macro that reads a text document (or excel) and compiles a new file on the following conditions:

     

    Example of text file entry: USER 987654321 6:04:54

     

    Find each unique user and find the earliest time stamp and the latest. In other words find out when he first logged on and then left.

    Now examine a file with 30,000 entries like this with on average 1000-2000 duplicate entries of each user with different time stamps.

     

    I got a macro to work however it has to many 'temp' work files that it has to use in order to process the data. It takes forever and crashes. There has to be an easier way im just not seeing it. Please post coding ideas, I would greatly appreciate it.

×
×
  • Create New...