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