Search results for query: *

Thanks skip, I've never used the Excel macro editor before, and it did help me line things up (as well as your explanation). I made a couple changes to make it even easier to read with the variables (at least I think) Dim PageNo As Integer Dim Month As Integer Dim Pages As...

Skip, I was able to fix the For, next issue, but I'm still missing something. My variables are not working, they are returning the same values, and are not capturing the values for all the pages in the statements. Sess0.Screen.Sendkeys("<Reset>") Sess0.Screen.Sendkeys("<Clear>")...

Skip, I'm hoping you won't mind helping me out again! I'm being asked to show the same data on subsequent pages of the statement. (the original code took the 3 returns on the 1st page of the statement. ) One issue with that is there could be any number of pages or each month, so I tried using...

Skip, Running the macro from my desktop did the trick! Thank you for all the work you did cleaning up the layout of my code, and working though my questions this past weekend; this code is going to make my life so much easier! Thank you again!

Running it from my desktop makes it fly, and I cant slow it down. I think it's going so fast that it cant keep up with the screens

Yes, I believe so

It's a 3270 emulator, yes the N drive is a network drive, I'll have to check with them on Monday. I didn't consider that the network drive drive could be the issue, I'm going to write to the C drive to see if that makes a difference, I'll let you know how that run goes

It's running at the same speed, the odd thing is that I have not been able to determine a rhyme or reason for when it fails.. There are times where it will go through a small amount of records and fail (the smallest amount of records I got through before failure was 60, and the largest is about...

WRITE #2,Ret1$,Ret1a$,Ret1b$

Skip, thank you very much for your help! I tested the code, and it gave me the same error, but at line 90 this time (at the write) it successfully went through 227 records before failing, is there a way to clear the memory after the write? Thank you again for all your help! James

I'm hoping someone could help me, I'm self taught writing macros, and am driving myself crazy with the following error "Disk Full Line Number 276 Stopping macro playback" My macro screen scrapes various values on the CSS screen, and writes those values to textpad. I have not been able to...

Hello, I'm hoping someone can help me. I've searched many, many posts and can only come up with the following formula using DateDiff("m", {datetime1}, {datetime2}) and it's not calculating what I need. I have the following report: USER_ID LOGINDT LOGOUTDT Login Profile hh...