randallf

Arrow down > home indeed, also there is a command in Excel for 'go to' a certain cell. Keyboard shortcuts are going to be your best friend when using ME with Excel. I recommend anyone using the two brush up on their shortcuts.... From http://www.rnib.org.uk/xpedio/groups/publi...rnib003503.hcsp Navigating Description Shortcut Key Move to next cell in row Tab Move to previous cell in row Shift + Tab Up one screen Page Up Down one screen Page Down Move to next worksheet Ctrl + Page Down Move to previous worksheet Ctrl + Page Up Go to first cell in data region Ctrl + Home Go to last cell in data region Ctrl + End

Hey there Guys, Steve, how about this, using convert integer to string and if/contains? Oh I guess I didn't really notice [page 2] I thought this was still not responded to from a previous post. Oh well, was fun to have a go at it! CONCEPT only!!! Totally untested: Repeat Until %T3% = "forever" // add one to count Variable Modify Integer: %N2% = %N2% + 1 // repeat until we pull a variable that doesnt match // using repeat until as a looping 'if contains' Repeat Until %T10% Does not contain %T1% // get a number Variable Set Integer %N1% with a Random Number // convert to string Variable Modify Integer: Convert %N1% to text string %T1% Repeat End // add the last number to the long string Variable Modify String: Append "%T1%" to %T10% // add a space (dont know if this is necessary) Variable Modify String: Append " " to %T10% // check for number of integers written to string If Variable %N2% >= 5 // reset count Variable Set Integer %N1% to 0 // clean long string Clear Text Variables: From 10 To 10 End If // external functions/text box Text Box Display: Number is: %N1% Repeat End <REP3:08:000001:000001:0003:0:01:forever><REM2:add one to count><NMVAR:01:02:1:0000002:2:0000001><REM2:repeat until we pull a variable that doesnt match><REM2:using repeat until as a looping 'if contains'><REP3:08:000008:000001:0010:1:01:T1><REM2:get a number><IVAR2:01:06:100><REM2:convert to string><NMVAR:05:01:0:0000001:0:0000000><ENDREP><REM2:add the last number to the long string><TMVAR2:07:10:00:000:000:%T1%><REM2:add a space (dont know if this is necessary)><TMVAR2:07:10:00:000:000: ><REM2:check for number of integers written to string><IFVAR2:2:02:5:5><REM2:reset count><IVAR2:01:01:0><REM2:clean long string><CLEARVAR1:T:10:10><ENDIF><REM2:external functions/text box><TBOX4:T:1:CenterCenter000278000200:000:Number is: %N1%Text string should match: %T1% Long string is: %T10%><ENDREP>

Window Minimize: "Macro Express" <WMIN:Macro Express>

http://pgmacros.invisionzone.com/index.php?showtopic=3337

This has worked great for me for clipboard speed. As far as I know this is the fastest that it could possibly be because as soon as it has data it will stop: Repeat Until %T1% <> "" Clipboard Copy Variable Set String %T1% from Clipboard Repeat End

Hello, I imported macros from someone else which are password protected. I want to delete these macros from my mex file but it will not allow me to without entering the password. I do not know the password. How can I delete the macros? Why is this behavior even in place? Thanks!

why wont it parse them whyyyy whyyy :wacko: Who knew macro express was this powerful, I managed to write a macro that automatically drives me crazy whenever I run it.

It seems to work for some things and not others, specifically, for this macro <TVAR2:40:01:Kevin%20Heaton><TVAR2:41:01:help%20with%20everything><TVAR2:42:01:Clarify%20Number:%20%25T1%25Trio%20Number:%20%25T15%25Case%20Title:%20%25T11%25%0dContact%20Name:%20%25T9%25%20%25T10%25%0dContact%20Phone%20Number:%20%25T20%25%0dContact%20Location:%20%25T19%25%0dPriority:%20U%25T91%25%0dCreate%20Date/Time:%20%25T97%25><REM2:><TVAR2:20:01:/c ipm.note /m %T40%&subject=%T41%&body=%T42%><TBOX4:T:1:CenterCenter000805000223:000:DEBUG T20%T20%><LAUNCHDEL2:0:01outlook.exe<PARAM>%T20%> I get this debug /c ipm.note /m Kevin%20Heaton&subject=help%20with%20everything&body=Clarify%20Number:%20%25T1%25Trio%20Number:%20%25T15%25Case%20Title:%20%25T11%25%0dContact%20Name:%20%25T9%25%20%25T10%25%0dContact%20Phone%20Number:%20%25T20%25%0dContact%20Location:%20%25T19%25%0dPriority:%20U%25T91%25%0dCreate%20Date/Time:%20%25T97%25 and this output (the formatting will change later not worried about it atm) Clarify Number: %T1%Trio Number: %T15%Case Title: %T11% Contact Name: %T9% %T10% Contact Phone Number: %T20% Contact Location: %T19% Priority: U%T91% Create Date/Time: %T97% When I tried the stuff in the above comment for a test it worked fine, I am stumped. The only thing I can imagine is that it has a 255 character limit for parsing or something, though that doesnt fit with other tests that ive done. It's 337 characters.

can't for the life of me figure out what the difference is here These two lines are topologically very similar yet the 'test' one works and the real one doesn't. Stumped. <TVAR2:42:01:test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%test%0dtest%T1%> <TVAR2:42:01:Clarify%20Number:%20%25T1%25Trio%20Number:%20%25T15%25Case%20Title:%20%25T11%25%0dContact%20Name:%20%25T9%25%20%25T10%25%0dContact%20Phone%20Number:%20%25T20%25%0dContact%20Location:%20%25T19%25%0dPriority:%20U%25T91%25%0dCreate%20Date/Time:%20%25T97%25>

It sure does! I must have been fumbling the nesting of everything, (yes in fact I was messing up the set string > set string > use variable combo) thanks a ton this is going to be really great! I have tried literally five different ways of populating emails in ME and this is by far and away the quickest.

Exactly, but inside that first 'variable set string' I want to use more variables like %T45% or whatever... It doesn't seem to parse them first, it just outputs that string directly, but I was wondering if there's a way around that... Variable Set String %T20% "/c ipm.note /m Kevin%20Heaton&subject=help%20with%20everything&body=The%20following%20is%20happy%20fun%20time:%T20%" (or whatever T20 is in unicode)

Oh hrm, might it be possible to do this by having mex create a custom batch script that executes the command? I wonder if it wouldn't be any faster like that, with all the file writes it'd have to do

oh, hrm, was this the answer I wanted? You can just directly put /c ipm.note /m randall&subject=etc into the command line section of the dialogue and it works fine, the problem is I want to do like /c ipm.note /m randall&subject=%T20% And have it parse %T20% to the mex variable and not just display the ascii string... I tried doing like Variable set string T98 Whatever Subject Variable set string T99 /c ipm.note /m randall&subject=%25T98%25 I then put T99 in the command line field of the macro command but I just get the same output of %T98% in that place instead of the parsed variable I need to get the variables to parse from ME before they are input into the email... am I missing something basic here? I have an email that has like 12+ fields in it that the first part of the macro pulls from a ticketing system, I then need to send someone an email with those bits of information and headers like Case number: %T23% End user: %T44% etc and it would be WAY faster if I could just command line it up by building a custom command line each time, I just can't see how it's possible The way I have been doing it is to launch a blank email and then populate it but that is much, much more difficult and WAAAAY slower You can see more on this here: http://support.microsoft.com/kb/287573

oops

NEVER!!! Well, some people see it that way, but the end-result of my work on this team is a phone call or email, it's a high-paperwork environment and any way that I can speed it up is good. THANKS for the input, I'll give it a try! Brilliant, BTW, should have seen this

Hello all, I want to launch an outlook email from a command line like: outlook.exe /c ipm.note /m randall&subject=help%20with%%20everything&body=The%20following%20is%20happy%20fun%20tiem: And this works, but I want to use a variable in that ASCII string... /c ipm.note /m randall&subject=help%20with%%20everything&body=The%20following%20is%20happy%20fun%20tiem:%T20% and use multiple lines, etc, I found a converter for the string but is it possible to insert variables in here? Will it work if I use the ascii for %, etc? EDIT: I tried that, it just inserts %T20% into the email.... %25T20%25 for the record What's the fastest way to craft a new email without a template or issuing text type that the community knows? Is there a way to force it to parse? OutlookTest.mex

Thanks for the bump... that software actually looks pretty interesting... ever tried automation/production with it vs me? Edit: Wow... time to move on up... I highly recommend this for those who feel that macro express is slow or limiting. AHK is more of a language than ME is. ME is really easy to use and plain in it's usage but AHK seems to be much more powerful (faster!) pound for pound, though WAY not as easy for beginners.

In the 'sound wave file' macro command there is a check box for 'wait for file to finish'. Make sure this is not checked if you are issuing successive commands. There are probably other programs that are more suited to your needs, like a virtual synthesizer or something.

That's exactly what I would have tried first... explorer is everything desktop, if you kill it you can see that when it auto-recovers. I can't imagine a better way.

Is it possible to activate a macro with mousewheel up or mousewheel down?

When opening windows in windows explorer there is a default state for new windows and another state for existing windows. There is also some insanity with how it decides what is a new window, if you launch it from within a session from the file menu it will inherit certain views but new launched explorer.exe processes to view folders have a state in XP that you can set by going to tools > folder options > view and clicking 'apply to folders'... I think that dialogue has an explanation too... and I'm not sure how macro express goes about opening a folder to browse, probably by issuing c:\whatever\folder\ to shell. I made some assumptions there and maybe that's a bit disorganized but suffice to say I think you need to look at the default views. Just a thought!

The other huge thing that helps that worked for me on the last team that I was on was to create a macro suite that made me so highly efficient that it could simply no longer be ignored because I was totally outperforming everyone else on the team by a factor of three to five. That really turned heads, but that was a different environment. heh I just had a talk with my sup about it, they might be interested in using them to help standardize message formatting... maybe we'll get a good look at macro implementation in a production environment out of it Edit: I've learned so much. It seems what I'm asking for here is for macro express 3 to have function for regular expressions which is an extremely unlikely candidate for late implementation into a sunsetting product. Oh well.

You got way further than I did. Nobody really understands their purpose and the others on my team are somewhat non-technical, (read: frustratingly ignorant) so it's hard to get more than a couple of them to want to even try it, let alone the fact that I am working my ass off trying to disseminate them. The biggest thing I've found that helps is finding anyone who agrees with you on it lol gatta run

There are other options though, such as launching ME itself from a flash drive (some come with software that does this)

oh brother do I live in that world have you had any success getting others to adopt them and if so how