thoraldus

I run Windows 7 64 bit. Have had the system "freeze" symptom while running MEP. System thaws after killing all MEP processes. I put "freeze" in quotes because although the system response is VERY VERY slow, if you wait long enough you can bring up the task manager and kill the MEP processes without logging out. I have tried killing everything except MEP and could not find any other process that was interacting in a bad way with MEP. I currently am only running one very simple scheduled macro that periodically moves a file form one directory to another.

 

Rick

I've found a simple solution that works for me. I have a macro that runs every night that restarts MEP.

Rick

I run Windows 7 64 bit. Have had the system "freeze" symptom while running MEP. System thaws after killing all MEP processes. I put "freeze" in quotes because although the system response is VERY VERY slow, if you wait long enough you can bring up the task manager and kill the MEP processes without logging out. I have tried killing everything except MEP and could not find any other process that was interacting in a bad way with MEP. I currently am only running one very simple scheduled macro that periodically moves a file form one directory to another.

Rick

Can MEP control specific inputs on an audio device? Is it possible to control for example, the line input [Mute/Unmute] [set Level], etc?

 

Thanks for any suggestions.

 

Rick

Stumped, eh?

I need to drop down one line every time I go back into Excel. Here is the basic of what I'm trying to do.

 

<WINDOW ACTIVATE Title="Microsoft Excel" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/>

<MOUSE LEFT CLICK/>

<GET MOUSE POSITION Option="\x01" X="%N[1]%" Y="%N[2]%"/>

<DELAY Flags="\x01" Time="2"/>

<MOUSE MOVE Option="\x01" X="300" Y="300" _PROMPT="0x000A"/>

<DELAY Flags="\x01" Time="2"/>

<GET MOUSE POSITION Option="\x01" X="%N[1]%" Y="%N[2]%"/>

<DELAY Flags="\x01" Time="2"/>

<TEXT TYPE Action="0" Text="<ARROW DOWN><ENTER>"/>

 

It is not going down a line nor is it showing an active cell. Since I can not see an active cell, maybe it is going down a line.

 

 

Bob

What version of Excel are you using. In Excel 2007 you can use an Excel function to find the last cell in the spreadsheet.

[HOME] [FIND & SELECT] [GO TO SPECIAL] [LAST CELL]

If you add the [GO TO SPECIAL] menu item to your custom ribbon you can then access it with an ALT-'n' key sequence where 'n' is the numbered position of the shortcut icon on the ribbon.

Then getting to the next line from the last active cell would be ALT 'n' ALT s DOWN ARROW

Hope this helps.

Edit:

Excel should remember and return to the last active cell when you open it. Therefore you have an opportunity to set that position before you close the program.

Can MEP control specific inputs on an audio device? Is it possible to control for example, the line input [Mute/Unmute] [set Level], etc?

Thanks for any suggestions.

Rick

Integers do not have decimal values. Try the decimal variables (%D1%).

 

From the Macro Express help:

Do I hear an echo?

Please pardon me if this subject has already been addressed elsewhere. For the record, I tried to search the forum, but the only terms I could think of to search on had four or fewer characters: GOTO, skip, jump

 

Is there a Macro Express 3 command that simulates the GOTO command in Basic, where you specify either by line number or by some other marker a place in the same macro to jump to if a certain condition is met? I'd like to avoid having it call an outside macro if possible.

Thanks in advance.

This is my approach ...

Switch (N1)
 Case: 0
   Macro Run: MAC0
 End Case
 Case: 1
   Macro Run: MAC1
 End Case
End Switch

etc.

With a "Macro Return" in each call to an external macro above the code will continue after the "End Switch" statement. Not quite the functionality of a GOTO but usable.

>rberq<Thanks for the help.

I got it to work but when I put in the value 4.75 the macro returned the value for "4". I have a feeling it's not seeing the decimal point properly. Could you help me with the adjustment I need to make so that the macro will process a number with a decimal point? Thanks a lot for your help.

 

Activate Window: "Add Permits"
Mouse Move Window 498, 302
Mouse Left Button Double Click
Mouse Move Window 501, 303
Mouse Left Button Double Click
Clipboard Copy
Variable Set Integer %N1% from Clipboard
Variable Modify Integer: %N2% = %N1% * 43560
Variable Modify Integer: Convert %N2% to text string %T3%
Mouse Move Window 501, 303
Mouse Left Button Double Click
Text Type: %T3%

 

Integers do not have decimal parts they are whole numbers by definition. Your macro is doing exactly what you are telling it to do. If you pass the value 4.75 to a integer variable the .75 will be stripped off. Try using decimal variables if you need fractional values.

 

Bob

We are planning on adding the ability to set the font and font color for Text Boxes. We will consider allowing you to change the background color of the text.

 

No, we do not yet have a scheduled date for that version.

Well it's been almost 2 years now. Any chance we will get these options? They could be VERY useful. In fact, I need them right now for some code I'm writing. ;-)