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.