Jump to content
Macro Express Forums

Trixie

Members
  • Posts

    4
  • Joined

  • Last visited

Everything posted by Trixie

  1. Same versioning on all applications. And I believe she even has a newer laptop...mine is probably a year or two older. I will try your solution on Monday and see if it yields results. Thanks for your response!
  2. Hi, I'm hoping the pros can help me with this one. I have a macro that is running that basically copies the entire screen (looking for the screen to change...IBM 3270 is sooo slow) and save the screen data to my T1 variable. It looks for data in a specific position by column/row and when that data changes the macro moves on to the next command. I have one user who runs macros that call the 'change screen' macro whose computer does not seem to be storing the screencap data to the T1 variable, so my error handling kicks in, even though her screen has refreshed. Using Macro Stop and debugging I can tell that the variable is not being written to the T1 field. Several others use the code, myself included, with no problem. Is this a timing issue (preferences are set the same) or potentially something else? Thanks~
  3. Thanks Rand! I did go in and update the ME code to change the <ENTER> to <ARROW DOWN><HOME>.
  4. Hi, Gosh, it's amazing what kind of communities you can find when you Goggle things! I have been looking for somewhere where someone might have a little expertise with ME & Excel, as I'm one of only a couple in my office who use the combo. I created some ME macros last summer, that have been working just fine thank you until I started adding some formulas, validation & VBA to my workbooks to make them smarter. The issue I am seeing is that when I execute an 'Enter' function at the end of a row in Excel to move back to the beginning of the next row to copy through, it now pastes instead of 'carriage returning'. The Macro Express macro copies & stores each cell between A6 & P6, tabs through to Q6 and then executes the enter function to move back to copy same for rows 7, 8 & 9 before moving to the next application to paste the data. Instead of entering(carriage return) it pastes the last piece of data copied in Q6 and then runs amok. I could work around by changing all of my ME code to <ARROW DOWN><HOME> instead of enter, but lots of updating to do. Has anyone here run into this within Excel? I have had my Excel VBA vetted, and that doesn't seem to be the problem. It's nice to know that you all are out here...I'm going to have to poke around to see what tips I can pick up. Thanks~ Trixie
×
×
  • Create New...