Amerifax-Bob Posted April 26, 2011 Report Share Posted April 26, 2011 Problem is speed. Each time the macro runs if I can save 2-3 seconds it could amount to hours in a 24 hour day. The macro has apx 80 total lines of which 40-50 are a problem and these are the lines that do the data capture. The total macro takes 11 seconds to run. To capture 7 lines and turn them into variables it takes aproximately 9 seconds. It is capturing these 7 lines that I am trying to change from, right now it takes 9 seconds and I'd like to shave a couple seconds off of that. Basically what we are doing is pasting into a program called Ultra Edit, doing a control home, shift end and turn the value into a variable. We arrow down to the next line do another shift end and create another variable. And we do this for the next 5 lines of text. We are trying to find out if there is a better way to do that. Ideally it'd be nice if I could do my copy of the block of text and have the program see all the lines while it's in the buffer and create all my variables. Of course that would be similar to trying to play an MP3 file on your computer before you turn it on but actually we are looking for something that might be in between, just something better than shift end, down arrow... Bob Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.