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>

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>

That works too.

OutlookTest__2.mex

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.

I'm not quite sure what is going wrong with your macro. Attached is a copy of my test macro. It should be a good starting point.

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

I hope you're not using this to send spam.

 

I got this to work. Put this into T20 using the Variable Set String command:

 

/c ipm.note /m randall&subject=help%20with%%20everything&body=The%20following%20is%20happy%20fun%20tiem:

 

Then put 'outlook.exe' in the Program Path/Name field of the Program Launch: command and %T20% in the Program Parameters field.

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

Yes, if you use a utility called AutoHotkey.

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.

i set the scope to explorer.exe and it seems to work well limiting the macro to the desktop/taskbar. but are there any potential problems with this that i'm not aware of?

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?

If I add a Window Activate command to the end of the macro I described in this thread about opening a Windows folder, it sometimes sorts it as well! Back to Name order, instead of the Modified order I keep it in. About one time in every ten. But as I use this frequently, that's irritatating. Anyone ever encounter similar behaviour please, or have any insights into what might be causing it?

 

--

Terry, East Grinstead, UK

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.

Honestly, no. My company purchased about 10 licenses to be used exclusively in my department almost 2 years ago. I was tasked with building macros to distribute to the rest of my team.

 

I was limited by a number of factors, however:

• I was given absolutely no on-the-clock time to build macros. Forcing me to sacrifice personal time to build them (what I really ended up doing, was building the macros for myself while I should have been working, then utilizing those macros to play catch-up so my productivity didn't suffer - and then I tweaked them (read: dumbed them down) for distribution.
  
• All macros I built had to be submitted to the guy who actually researched automation tools, but who had little-to-no experience actually building macros.
  
• All macros submitted to him had to be approved by senior management for the department.
  
• All macros had to be password protected to prevent fiddling (read: tweaking/improving) by other members of my team (I couldn't change their minds about that), despite the fact that no two computers in the department are even close to the same (the closest we get is that most PCs are HPs, and all are running XP Pro, but the rest of the specs vary widely)
  
• Most of the people I work with range from technilogically challenged to technophobe, with one or two others whow are either "too good for automation" or so set in their ways, that learning to run a macro is just too much work... or something.
  

 

So, thanks to the first 2 or 3 items above, distribution was a nightmare. Training on using them was a bear. And actually following-up with people to see if they were using them, and if they had any suggestions or problems was non-existent.

 

Though I love the potential MEP has, as buggy and inconsistent as it is on my machine (I used to have the worst machine in the department, so any macro that worked on my machine would work on everybody's... my new machine is in the top 2-3, performance-wise, so if they don't run on mine, they won't run on anybody's), there is no chance I'll be able to ever convince management to upgrade our licenses. At least not in the near future.

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

Macro Express must be installed in order for a macro to run.

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

(everybody else seems to fear them)

oh brother do I live in that world

have you had any success getting others to adopt them and if so how