blopib

First off get out of the T habit. Name your variables. Le'ts call the T array %Cell% and the integer %N%, OK? Now first off your syntax is incorrect. A change from ME3. It should be %Cell(%N%)%. This may be the root of your error. Try that and get back to me.

I used [%N%] instead of (%N1%) maybe this is it. I'll test it.

 

While you're doing that I suggest copying the entire column at once. When Excel data is copied into a string var in MEP it's converted to a tab delimited format. Live CSV but with tabs. You can copy and entire column and use the Split command to break it into an array. You didn't mention any manipulation in between the copy and paste but i assume there is because there's no reason not to copy and paste the whole block from the one Excel to the other. So copy, split, manipulate, and paste back. Also if you use the array Join command you can join on CRLF and create an entire column which can be put on the clipboard and pasted in one go in Excel.

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.

 

Finally advice I give to all people messing with Excel. People often use Excel because it's a handy grid for data. If you are not doing a lot of formulas save the files in CSV format instead. Now you can natively access them in MEP using the ASCII File Process and other means instead of using Excel which causes all kinds of problem including data corruption. It often tries to guess what you mean and messes things up. EG an account code "12-4" pasted gets converted to the date "12/4/2011". And you can still open the CSV in Excel and view and manipulate it's contents.

I'll keep that in mind. Thanks for you're help Cory.

Have you even tried their support? Just because they do not post here does not mean they are not "focused on helping users directly with their problems." Their support seems very clear to me: Reporting bugs and requesting features.

 

Insight has been helpful whenever I have asked them for support. You should send them an email or call them.

 

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

Welcome back.

Thx Cory, it feels good to be here again.

ISS doesn't contribute much anymore but I believe they do still monitor.

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?

BTW I suggest you change the MEP preference Activations > General > "Use the clipboard hook" to off if you are not in the habit of using clipboard contents for activation.

Thx for the tip, I'll try if it helps later on.

Make sure you are running the most recent version of MEP.

Check.

Can you create a simple macro that demonstrates the problem and post it for us to check out? I use the clipboard a lot and never have a problem. Could be some other program or utility causing a conflict.

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.

The Macro Playback Speed command only changes the delays in your macro. If you have no delays, the speed will not change.

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.

In the ME 3 version I had a Macro Playback Speed commant that was 10 times Slower than Normal. When it is converted into ME Pro is shows as being 0.33 times faster than normal.

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.

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.

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.

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

No ideas?

 

Something I should do different?

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.

 

 

I have a loop that repeats over and over. I can't remember how to program a timer in beginning that says

 

If X = 10 minutes then do this action

 

In other words, I want the macro to only do something every [x] amount of minutes while continuing a short loop thats maybe 30 seconds long.

 

Any help is greatly appreciated!

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

If you need to process a column of cells, "Text Type <ARROW DOWN>" should move down to the next cell. You may need to use <ESC><ARROW DOWN> instead.

 

If there is an advantage to specifying a cell, use "Text Type <F5>"

 

 

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.

Ok, thanx for the information. My whipping went well, I got my license yesterday.

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*

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

First of all , i am really sorry for my terrible english..

 

I created a macro which works brilliant for me

But i want my macro to start at random times..

 

For Example :

I clicked and activated it , it finished it work , it will start 5 minutes later

It will finish the work again and it will start 6 minutes later , not five..

The time must always different..

I will activate it , and it repats its work with random time differences..

 

I hope , I did explainep my situation and problem

And You understood it..

 

Work + Random Time 1 + Work Again + Random Time + Work + Random Time..

 

I suggest you take a look at Repeat start with Variable and Variable set integer/Set random value.

Thanks very much that worked for me. I appreciate the help.

 

I often do this in excel, if 1 is in the cell A1, you can use =TEXT(A1;"00000") in eg. the cell A2

This works for a Firefox window. Maybe it will work for your application.

Get Control %C1% (Maximize/Minimize windows when using controls? - Macro Express Forums - Mozilla Firefox: )
Variable Get Control Text: %C1% to %T1%
Activate Window: "%T1%"

 

 

Ok, thanks Kevin, I will try that.

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.

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?

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

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

Bear in mind there is a fundamental rule in Windows that all things should be capable of being done without a mouse. Of course I can think of several violators but 98% of the time it's followed. And since I distribute my macros I avoid mouse moves like the plague so these lists come in handy.

 

I know, I just want to encourage to more great tips from all the ME users.

ALT+Space then X.

 

http://support.microsoft.com/kb/126449

 

 

Nice tip Cory, thanks for the link.

Thanks for guidance Kevin.

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.