johnboy691

Yes, as already stated you can run Macro Express off of a server. I do this for my company for a group of processors who process using Citrix. As also stated the macros have to usually be designed a little differently specifically when it comes to the timing or delays. (You know, command from computer at a distant location has to go through Citrix back to server's in many locatiosn in the US where macro express resident, then action has to be sent back to the processor in reverse.) Most of the time not a drastic time difference, but it does occur and you have to perhaps "play" with the macro script to get it working correctly...most of the time. We also save our seperate macro files to a share drive on one of the US servers. The processor chooses the file they need for the job they are doing.

Just an idea to check. I've had this happen when pasting or typing to a green screen. In my particular case I discovered the person whose computer had the "problem" had changed the keyboard stroke for that key. Look into that. John

If you haven't done so already, go to the Macro Express Help under HELP and type in capture on the Search tab. This brings up Capture Macro Introduction. You can then click on #3 Capture Quick Wizard which brings up a great Tutorial on the Quick Wizard Capture which sounds like you are looking for.

Here is my preference on this... I never touch the Options/Preference/Delay settings. I always use Timing delays between my commands. Setting the value either in seconds or miliseconds depending on the situation with the application I'm putting or taking information from and what needs to happen. (ie: pasting or typing a long string I give a few extra miliseconds, just so the program has time to accept it.) Now, with that said, sometimes our systems have slow times during the day or at certain times which might even make my time delays to short. So...to countact this I put a Macro Playback Speed delay clear at the top of most of my macros. Then if I need to slow them down I can change that without changing individual delays. Or, sometimes if I only need to slow down a certain area or part of the macro I put the Macro Playback Speed delay right at the correct spot in the scripting so I can change it and after that part is done put another Macro Playback Speed delay to re-set it back to "normal". Hope this gives you some ideas. John

Ok, I don't know why I can't get this to work? I've looked at previous posts and just can't understand what the problem is. I'm sure it's something I'm missing that stands out. What I want to do is have a repeat loop within a repeat loop. The macro will start and the first run through I need it to assign account number 1002 the first time, it will break out of the counter loop within the main loop and go do what it needs to do with that account number. When done it will loop back to the top, the counter will now be 2 and would find the second account number of 1002, break, and do what it needs to do with that account number. So on with successive account numbers. I've included the test scripting so you can more readily tell me what I'm doing wrong. THANKS! <IVAR2:01:01:0000><REP3:01:000001:000001:00010:0:01:><MSD:250><REP3:05:000001:000001:0001:1:01:><TBOX4:T:3:CenterCenter000278000200:000:StartMacro is starting at the beginning of the counter again.><DELAY:3><TBCLOSE:Start><IFVAR2:2:01:1:0000><TEXTTYPE:assign account 1000><TEXTTYPE:<NUMENTER>><BREAK><ENDIF><IFVAR2:2:01:1:0001><TEXTTYPE:Assign account 1002><TEXTTYPE:<NUMENTER>><BREAK><ENDIF><IFVAR2:2:01:1:0002><TEXTTYPE:Assign account 1003><TEXTTYPE:<NUMENTER>><BREAK><ENDIF><IFVAR2:2:01:1:0003><TEXTTYPE:Assign account 1004><TEXTTYPE:<NUMENTER>><BREAK><ENDIF><IFVAR2:2:01:1:0004><TEXTTYPE:Assign account 1005><TEXTTYPE:<NUMENTER>><BREAK><ENDIF><IFVAR2:2:01:1:0005><TEXTTYPE:Assign account 1006><TEXTTYPE:<NUMENTER>><BREAK><ENDIF><IFVAR2:2:01:4:0005><TEXTTYPE:No more accounts, Macro stopped><TEXTTYPE:<NUMENTER>><MSTOP><ENDIF><ENDREP><TEXTTYPE:Repeat has broken all repeats and will start over><TEXTTYPE:<NUMENTER>><ENDREP>

My largest macro is over 18,000 lines of scripting. I would like take another large macro with as many lines and add it to the end of the first macro so I don't have to have two seperate macros to do the job. My question is...Has anyone had any issues with macros that are that 20,000 lines in length or more? Is there anything I should watch for? Thanks, John

Kevin: Thanks, it worked! I must have mis-keyed something the first time when I added the extension. (No matter how ofter we proof something....) Appreciate you getting back to me because if ME should do it and it doesn't, I know it's my fault. :-) Happy Turkey day everyone! John

Hi ME Lovers: Company programs/files are stored in files with the same paths except each employee has a unique folder based upon their name. So it's been hard to make a general macro to open or save a file using the macro. I tried using the Set Variable command to capture the Path to Desktop which shows "C:\Documents and Settings\jsmith\Desktop, and that works, putting it to variable T1. I was hoping I could then modify the variable T1 to capture just the jsmith...which I can. I then used the Activate/Launch Program command, set the Window Title: ORS comments (which is a notepad file) And in Program Path/Name: put C:\Documents and Settings\%T1%\Desktop\Ors comments (I've tried it like this and with the extension.) However, when I run the macro I get the error: The specified Program "Ors comments" could not be launched. The following error occured: The specified file was not found. The macro will abort. I am assuming the %T1% variable isn't being read as jsmith by the Activate/Launch Program command. Any ideas on what I am doing wrong...and/or an idea as to what new path to follow? Thanks, John

Thanks gentlemen!!! This helps put my mind at ease. Appreciate your comments. And since my company doesn't let us into the registry keys...the list will stay.

Over time, different files have been opened (made) by going to FILE / NEW MACRO FILE, and new macros have been made in them or copied to them. Going back and forth between them is done by going to FILE and REOPEN in ME. If I no longer need the macros is a particular file...I can delete them...but I can't seem to actually get rid of the file. If I go back to FILE / REOPEN the file is still there, even if there are no more macros still in it. Is there a way to get rid of it?, completely.

Cory, Glad to hear you are well. You and others from the area will remain in our prayers and thoughts. John

Ok, I haven't been able to figure this one out and was wondering if anyone else had any fun with this! I have a jpg file saved in My Documents of a stop sign. I would like to have this jpg show up inside a Text Box Display if a value is say greater than a certain amount. I'm thinking of using a variables. How/Can I get the jpg file to open up as the picture within the Text Box Display. Has anyone done this, any ideas? Be interested in hearing from you. Thanks, John

Hi Terry: I use shortkeys extensively. Shortkeys work great MOST of the time. However, I have found that in a few applications they do as you describe. I have found this is a situation with the application and not macaro express. All of my shorkeys are for printing comments and in those particular applications when I do the ##ov1 to start the shortkey it won't allow ME to take the ##0v1 back out and then print correctly. I have never found a work around for this yet. My only answer has been in those applications where a shortkey wouldn't work, I had to resort to a hotkey when I want a macro to work in those applications. I'd be interested in hearing from anyone else who has been able to find a work around. John

I work for a large corporation and as most of you know who also work for larger companies, the wheels of progress sometimes move very slow...or not at all. Believe it or not the "company" standard is ME 3.0. I know, don't laugh...I only work here. Anyway, in my department I design and implement all the ME macros for our department. Because of some of the programs we had due to security systems we use on all computers I had to have our department upgrade to 3.5.5.2 aka 3.5e. This sent the person who controls ME for our company into seizures. They were not happy. When I asked what the big deal was they said they didn't want to re-write all of the macros. Now, when my department switched to 3.5e I didn't have to re-write one macro, it just kept them from erring out...so here's my question? Have any of you had a problem or situation when you upgraded that you had to re-write macros because the older version macro wouldn't work on the newer version. If so what specifically was the reason and how time consuming was it? I'm interested in knowing as much as possible about any problems any of you had if you'd be kind enough to share. I'm sure there are more who would like to know this information. Thanks, John

My macro express is up, showing the icon on the task bar, my macro's work when I initiate them, but when I double click on the icon on the task bar to bring up the editor to view or work on a macro it won't open up on the screen. If I right click on the icon it won't come up even if I click on Open Editor. Any ideas? Thanks, John

Be nice to have the choice to be able to capture the formula in a cell instead of the result.

I have an Excel workbook open with data already populated on say...4 sheets. If I have my macro running and it needs to put information into say cell A1600 on Sheet one, whenever it does that, the same information shows up in the same cell in Sheet 2, 3 and 4 also. How can I prevent this. I've tried doing a text type with the information (ie: the word CONTINUE) I've tried putting the word CONTINUE into a variable and text typing the variable, and also pasting the variable from clipboard. Anyone have any ideas what I may be doing wrong...or what options I may need to change in excel? Thanks, John

You said: 2 - Not a particular workbook sheet, however, that would also be some very handy knowledge to have. Here is what I did. It's probably a long way around Robin Hood's barn, but it gets the job done. I open my excel spreadsheet. I have multiple sheets with data on them and want to copy/paste or move between them as necessary. To do this you need the sheet tab NAMES in variables. Let's say I'm in Sheet1 and want to go to Sheet9, I just have ME do the following: <TEXTTYPE:<F5>><MSD:250><TEXTTYPE:%T33%!$A$%T22%><MSD:250><TEXTTYPE:<NUMENTER>><MSD:250> %T33% is the name of the sheet, the A is the column I want it to go to and %T22% is the cell number. The !, $ are the excel requierments for finding a certain position. (I actually got the idea for this from a comment Cory said about something, thanks Cory) If you don't want to type the Sheet tab names into a variable you can have the macro grab them by doing the following: <REM2:Start Copy worksheet name><MSD:150><TEXTTYPE:<ALT>o><MSD:50><TEXTTYPE:h><MSD:50><TEXTTYPE:r><MSD:50><TEXTTYPE:<CTRLD>c<CTRLU>><MSD:50><TVAR2:33:03:><MSD:50><TEXTTYPE:<ARROW RIGHT>><MSD:50><TEXTTYPE:<NUMENTER>><REM2:End Copy worksheet name> Hope this helps or gives you your own ideas, John

Hi Cory: I guess mostly it is out of habit because on some applications my company has the paste variable won't work. So, instead of spending loads of time trying to figure out why I just resorted to the Ctrld c Ctrlu command.

Sorry, bad choice of words. I had the variable %T1% in a text type command. %T1% was a value completely unrelated to the data being copied and pasted. The macro would copy from one worksheet, go to the other worksheet, then text type the value of %T1% into say cell A1, arrow right and then do the clipboard paste of the data from the previous worksheet. Which didn't work. When I took out that Text Type command of putting in the value of %T1% into cell A1, and went directly to clipboard paste, my data pasted. I now have the command to print the %T1% value do it's thing after doing the paste. Again, Thanks.

Cory: Thanks for your reply. I went back and went line by line and really couldn't find anything wrong. So because you said you copied large amounts of info all the time I figured I had something wrong. Anyway...after proofing and proofing what I finally noticed was that once I copied the data using the clipboard, the macro sent me to the next worksheet and before it would paste it would do a text type of variable %T1%, arrow right and then paste. The only thing between the copy and paste commands was the printing of that variable. I took the command out to do the T1 text type and BINGO! my data pasted. Why I don't understand why, evidently the printing of the vairable uses clipboard?, but I get my data to paste now; and I do my Text type for the T1 after the pasting. Works like a charm. Thanks, John

I am trying to capture by using Ctrl c (with control down and up commands), also tried clipboard copy, of say 1,000 to 1,500 lines and four columns of data from one Excel worksheet to another worksheet. I can't seem to get more than 150 to 200 lines to print in the new worksheet without getting garbage after that; and doing that garbage on one line. I have tried assigning the copy to a variable and printing using the variable, (that takes forever, but still only goes so far) I've tried copying and pasting using the clipboard. Nothing! Anyone have any ideas. Thanks, John

Rusty, know exactly what you mean. Our company utilizes excel with many different spreadsheets and other applications we have to move back and forth between. The only way we have been able to get around this is to open each spreadsheet in a seperate excel. Once two or three are open (along with other applications they automatically "stack" on the task bar so you don't see 4 or 5 different sessopms pf excel open, but there are. Open the first by opening the file and/or double clicking on an icon, etc. The for the second and consecutive speadsheets needed open go to Start and open a new excel. You can then use macro express commands to always find the correct spreadsheet you need. John

Mike: My company uses Microsoft Communicator also and this same thing happens with us and the Win+Q hot key. I have had this happen on other programs and/or hot keys usually with basic Microsoft applications. I therefore try to stay away from those combinations. Not much help, but at least you know you're not alone. John

Cory, Here are a couple of examples. One that doesn't have underlines and one that does. Hopefully the word document has attached. John popups_not_underlined.doc