Jump to content
Macro Express Forums

blopib

Members
  • Posts

    98
  • Joined

  • Last visited

Everything posted by blopib

  1. I used [%N%] instead of (%N1%) maybe this is it. I'll test it. Some good tips there! Actually there is no manipulation between copy and paste. I send out a bunch of sheets to different people and the problem is when copying from these sheets to a summative excel book and there is filtered rows it doesn't paste them in the right place, even though the files are filtered at the same way. That's when I come to think of trying this variable thing. I'll keep that in mind. Thanks for you're help Cory.
  2. I don't mean that ISS are not helpful, my point is that solving things "in public" like in this forum helps more people than one personal posted case to support. If you had been on this forum a couple years ago, you would have know what I mean. When ever I have any problem with my macros I intend to keep checking with this forum first and of course I will post it to support when it's necessary. It's not necessary for you to post comments on my subjects, ok? Bye
  3. Thx Cory, it feels good to be here again. It's a Pity. I think the hole idea with this forum is to discuss different matters and to first check with others if there is something that didn't get right in the script, before posting loads of issues and drowning Insight with things that really isn't support issues. I really hope that Insight would change their mind and turn their heads back and focusing on helping users (like myself) directly with their problems. When struggling sometimes under timepreassure, it has been a comfort to have ISS in this eminent forum. And what better way to sell the program, right? Thx for the tip, I'll try if it helps later on. Check. The thing is that I'm trying to understand how this variable evaluation works and I was testing a bit, therefore I wanted to know what the error code was and maybe better understand what I'm doing wrong. I have to admit I don't understand how it works, I've read almost every post in this forum and the ME3 forum and still don't get it. I'm thinking of starting a new thread with my problem even if it has been up on the forum before, at least in the ME3 forum. But no exact way to do it has been presented.What I'm trying to accomplish should be fairly simple. In Excel: Copy a filtered cell and save clipboard into %T%N1%%, increase N1+1, jump down and take the next cell, do this repativly from prompt and after that it should be possible to write all the T out with text type into cells in another excel file that is filtered in the same way. Does it make any sence? If you Cory or anyone else for that matter could present me such a macro I could learn from that. Any response to my problem would be highly appreciated. Regards. +5°C, a bit windy today, the snow that fell has melted away.
  4. Do you mean that there is a differens between how ME3 and ME PRO works? Maybe there is some changes in ME PRO but it should not set the macro to run faster when converting. So therefor I see it as a bug. In ME3 it worked as Johny described. My point was to verify his observation and to check if he has reported it as a bug or else I can do so. I think the hole idea with this forum is to discuss different matters and to first check if there is something that didn't get right in the script, before posting issues to Insight. Regards.
  5. Hi I'm trying to save clipboard text to a variable but keep getting I/O error 105 no matter what kind of variable name I'm trying to use. Does anyone know what I/O error 105 stands for? I didn't think I was going to struggle with simple things like this when converting from ME3 to ME PRO. Where can I read about error codes? Can't seem to find anything in the Help section about it. Regards. PS. I must ask, I haven't had time to go to this forum the past two years, (I've been helping another company and introducing ME3 to them) but as I recall it was a totally different activity from Insight (Kevin and others)on this forum. What has happened? Are they too busy now a days? Pity, there help and the direct communication was the strenght of this program in my oppinion. Well, well, luckily maybe Cory, Paul, Joe and other brilliant guys can help us instead.
  6. Hi Johnboy! I've noticed the same problem, have you reported it as a bug? If not, you should. In the help file for MEP Pro it says: Macro Speed The macro speed function is typically used with capturing (recording) a macro. The Macro Speed command occupies the first line of a recorded macro script. The speed factor is initially set for captured macros in the Capture preference settings. With all the timing delays between each keystroke and mouse movement recorded, it may be advisable to speed up or slow down the macro. Double click on the Macro Speed command in the script to edit the speed factor. Multiply Delays By To slow down a macro, place a number greater than one in the Multiply Delays By field. For example, placing a 4 in this field causes the macro to play back 4 times slower. To speed up the macro, place a value less than one in the Multiply Delays By field. For example, placing 0.5 in this field speeds up the macro by a factor of 2, using 0.25 by a factor of 4, etc. Macro Speed The macro speed function is typically used with capturing (recording) a macro. The Macro Speed command occupies the first line of a recorded macro script. The speed factor is initially set for captured macros in the Capture preference settings. With all the timing delays between each keystroke and mouse movement recorded, it may be advisable to speed up or slow down the macro. Double click on the Macro Speed command in the script to edit the speed factor. Multiply Delays By To slow down a macro, place a number greater than one in the Multiply Delays By field. For example, placing a 4 in this field causes the macro to play back 4 times slower. To speed up the macro, place a value less than one in the Multiply Delays By field. For example, placing 0.5 in this field speeds up the macro by a factor of 2, using 0.25 by a factor of 4, etc. When trying to slow down as in the example it doesn't work. When writing 4 ( <MACRO PLAYBACK SPEED Speed="4"/> ) it says: Macro Playback Speed: 0,25 times faster than normal in the script.
  7. Thanks for your reply Paul. As I said I don't normally use this in Excel, it's for the use in another program. The idea is to mark a predefined number of rows that I what to handle, and then shift to other windows within the program. If I take a to big bite, it gets to much for the program to handle. Maybe I could work something out to do this in a better way, but right now I stuck with my thoughts about why my loop doesn't work as I expect. I've looked into the code in my post again and I still can't see the reason why it takes so long time to roll through. The code is so small that this should take no time at all, as I see it. Is it because of the use of variables or what? Please could someone bring some light into this so I can sleep at night. :-) I bit more serious I think this would explain somethings about other macros that i use. Regards
  8. No ideas? Something I should do different?
  9. Take a look at Schedule Activation and the option: "Other -The Other option lets you repetitively run a macro every XX number of minutes or seconds. The intervals can be between 1second and 99999 minutes and 59 seconds. If you schedule a macro to run every 1 second and the macro takes 5 seconds to execute, then this function will not operate properly. If you plan to use macros that will run more frequently than every 10 seconds, you will need to change the Scheduler Frequency default setting. The default instructs Macro Express to check every 10 seconds to see if a timed macro is ready to play back. You will need to reduce this number in order for timed macros to play back more frequently." Maybe this is what you're looking for.
  10. Hi I've made a really simple macro that marks as many rows as I define when prompted and put it in a variable. But why is it so slow? It doesn't seem to help adjusting the general delay or even run the macro a 1000 times faster. Why is this? Is it because the use of variables? I've tried to run the macro against files on both lokal and serverplaces but it's the same result. The reason behind this is intresting for some of the other macros that I have made, so it would be nice if someone have a solution or could explain this to me. (The code is not normaly used with Excel but it is the same problem) <IVAR2:01:02:FDefine the number of loops to runFFCenter:Center><MMS2:1050,10><REP3:05:000001:000001:0001:0:01:><TBOX4:T:6:0Right000Top000200000100:000:Number of loopsNumber of loops to run: %N1% Number of loops done: %N2%><ACTIVATE2:Microsoft Excel -><WAITWIN2:000010:000000:Microsoft Excel -><TEXTTYPE:<SHIFT><ARROW DOWN>><WAITMOUSE:000010:000000:Arrow><NMVAR:08:02:0:0000001:0:0000000><TBCLOSE:Number of loops><ENDREP> Regards
  11. Alans idea works fine in Excel, if you also add a new column that contains the formula =ROW. You then have the possibility to use the row number in a variable. Copy the number of the row e.g to N1. Use Alans "Text type <F5>" and then fit "TEXT TYPE:Sheet1!$A$%N1%" into referens. In other words jump to a specific column in a specific sheet. Regards.
  12. Ok, thanx for the information. My whipping went well, I got my license yesterday.
  13. Hi This is not an big issue but hotkey Keypad. (dot) should be Keypad, (comma) it changes to Keypad, (comma) when choosen. It seems to be like this with every hotkey Keypad, alternative that one could choose from in the list. (I know bug-reports shall be sent to ISS but I like the fact that you can see all the problems or bugs presented in this nice forum). Regards *Update 090114: I've now reported this as a cosmetic bug-report to ISS*
  14. Wo-Ha! Just got back from a month of and found out that MEP has come! Eureka! Now I'm chasing the purchaser to get me upgrade for 5 lic but they are so slooooow. So my question is how long before the regular price takes effect? Is it just to the end of this month? Regards -I must go now, I'm busy, must whip the purchaser....
  15. I suggest you take a look at Repeat start with Variable and Variable set integer/Set random value.
  16. I often do this in excel, if 1 is in the cell A1, you can use =TEXT(A1;"00000") in eg. the cell A2
  17. Hi Does anyone know if you can Maximize/Minimize windows when using controls? I've tested Window Commands/Window Title and %C1% but it doesn't work. Ideas? Tuesday 12:41, a bit windy but sunny and 17°C.
  18. Thanks for all the tips and keep sending me if you have some more ideas. Yes, I know about the Get control, Launch Get Control Utility and Get Control Using Text, through Joe/Kevins eminent ME explained. I have a bunch of different child-windows in this application that I have to access, and the macro is going to be quite advanced (by my means anyway) so going thru the code to adjust control for different positions before using it the next time, isn't an option. I've got it working with some of the windows but somehow the "Get function" does not recognize one of the windows containing sheet/laps? I'm probably going for my "ugly solution", that is to launch the needed amount of application with the right window maximized and then call the right one with Activate Window needed for that task and then switch to next, just to plough through the work thats waiting. Just another thought, I think I have to start another tread, Maximize Window with the result in C1? Can that be done?
  19. Thanks for the tip Pat, but I can't install any freeware at work, I want to solve this by using the great program of ME..... Isn't it possible to somehow get Window Text shown in the Capture Window Control? Kevin? Joe? Anyone one else who has a suggestion? If I could solve this problem with this index-windows in IFS application, it would open up a bunch of other possibilitys...
  20. Uhh, we're do I start... I work in a interface connected to a database (IFS Appl.) and I'm trying to get control function to work, but after a bit of testing I've come to a point where I'm stuck. Maybe it's nothing to do, I think I still can work my way around (with a not so elegant solution). I wonder if any of you experts can help me out with this. In IFS appl. there's a lot of windows to use and the trouble is that get control doesn't recognize the different child windows, Joe describes my problem in ME explained page 337, "Still other applictions assign a seemingly random index number"....."and there is no way to predict what index number will be" There's a suggestion that one could use the capture control, but my problem is that the position of the child windows never are the same. I'am just thinking, could Me catch something else to control? -When looking at properties of this different windows in IFS appl. there is an Identity e.g frmInventoryLocation, is that something that I could catch? This not easy to answer if you haven't seen the application offcourse, I understand that. Or the Window Text shown in the Capture Window Control? This is name is always the same, it would be great if I could use that! I guess it's not possible to catch these things otherwise it would already be possible. Is there someone who has any clever thoughts about this, I would be glad to hear them..... Greetings from a 40 year old BF Heroes Beta-tester....
  21. I know, I just want to encourage to more great tips from all the ME users.
  22. QUOTE Also i think if we could increment the variable (t1, t2... automatically) when the loop repeats then many problesm would be resolved As I see it SteveK presented a solution to what you're trying to accomplish with: QUOTE which was to treat var T1 dynamically like "Save Clipboard to var T%N1%" then increment N1, thus changing the which T var is used .... Oopps! Sorry I was sure that it was possible to do, I will be more careful before saying things in the future. I'll try to look into it and see if I can help you.
×
×
  • Create New...