Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jschmidt1

  1. jschmidt1

    Statement return

    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...
  2. jschmidt1

    Statement return

    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>")...
  3. jschmidt1

    Extra! Basic Error Disk Full Error

    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...
  4. jschmidt1

    Extra! Basic Error Disk Full Error

    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!
  5. jschmidt1

    Extra! Basic Error Disk Full Error

    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
  6. jschmidt1

    Extra! Basic Error Disk Full Error

    Yes, I believe so
  7. jschmidt1

    Extra! Basic Error Disk Full Error

    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
  8. jschmidt1

    Extra! Basic Error Disk Full Error

    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...
  9. jschmidt1

    Extra! Basic Error Disk Full Error

    WRITE #2,Ret1$,Ret1a$,Ret1b$
  10. jschmidt1

    Extra! Basic Error Disk Full Error

    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
  11. jschmidt1

    Extra! Basic Error Disk Full Error

    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...
  12. jschmidt1

    Formula to determine time between a log out and next log in

    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...
See more

Part and Inventory Search

Back
Top