floyd

Other than just taking a quick look, I have not done anything with it at all. Didn't even know it was there until you mentioned it.

 

Currently we are up to our eyeballs in automation/macro work so I won't be able to learn the ins-and-outs of it any time soon. Hopefully someone else has had some experience.

What's webdav?

I have multiple files open in Excel, and I want to go from a different application to a specific window open in Excel.

Two questions:

1. Which version of Excel are you using?
   
2. When you say "specific window in Excel", do you mean a particular workbook sheet?
   

You would use a dynamic variable string. The following example loops 10 times and increments the "T" variable once every loop, and copying the clipboard contents to the incemented variable. You will need to insert your code for stuffing the clipboard, of course:

 

Repeat Start (Repeat 10 times)
 Variable Set String %T21% "<TVAR2:%N1%:03:>"
 Run Macro in Variable %T21%
Repeat End


<REP3:01:000001:000001:00010:1:01:><TVAR2:21:01:<TVAR2:%N1%:03:>><RUNMACVAR:21><ENDREP>

but one would also need to replace three spaces and so on

Yes, that's exactly what it does. It replaces two or more spaces with a single space. And it keeps doing it until only single spaces are left.

It would work if placed inside a loop:

Variable Set String %T1% "qwerty                qwerty            qwerty"
Repeat Until %N1% = 0
  Replace "  " with " " in %T1%
  Variable Set Integer %N1% from Position of Text in Variable %T1%
Repeat End


<TVAR2:01:01:qwerty                qwerty><REP3:08:000001:000002:0001:0:01:0><TMVAR2:21:01:01:000:000:   ><IVAR2:01:13:1:  ><ENDREP>

This would work for those larger ranges:

If Variable %N1% >= 1
 AND
If Variable %N1% <= 1000
 ... code block
End If
If Variable %N1% >= 1001
 AND
If Variable %N1% <= 2000
 ... code block
End If

Macro Express does not have the ability to do date calculations, at least not built-in date calculations.

 

There are, however, solutions to your problem. Randall has already posted one of his.

 

Here is another possibility. Date Functions. It is a link to our add-on PGM Functions Library for Macro Express 3. The link shows a list of included date calculation functions and a short description of each.

 

Another solution would be similar to Randall's in that a simple VBScript program is written out to a file by Macro Express, run, and the the results read back in to Macro Express.

is a FLOATING menu bar actually a running macro, or is it that it just CALLS macro's with its buttons?

It is a macro that calls other macros but it is internal to the player (macexp.exe), like a system macro.

 

will macro #2 run, or is it PREVENTED from running, since macro #1 is running?

Macro Express 3 only allows for a single macro to run at any given point in time. Your macro #2 will run, but only after #1 finishes.

 

Can multiple floating menus be present at once?

Yes.

 

but the titles do NOT show up with a mouse-over

This also answers your question in the Mouse-over, Icon, Text-display post. My theory is that, although floating menus can be set up to look like floating toolbars, they are still only windows. If you set focus to the floating menu by clicking on the title bar then the tool tips become active again because the window is active again.

Each Case / End Case is a one-on-one comparison. But, for any End Case command you can have multiple Cases. Your example would work like this:

Switch (N1)
  Case: 1
  Case: 2
  Case: 3
  Case: 4
  Case: 5
     ... Code block
  End Case
  Case: 6
  Case: 7
  Case: 8
  Case: 9
  Case: 10
     ... Code block
  End Case
End Switch

What didn't work?

If Message command

Wait Left Mouse Click

OR

Wait for Key Press: ENTER

is there a macro that can return the mouse BACK to the position it was when the hotkey was performed?

Save current window title

Save current X and Y mouse coordinates

Move to position and click whatever

Activate saved window

Move mouse to saved coordinates

moving it back to where it SHOULD be relative to how much the mouse has moved from the hotkeyed position?

This is the same question. Look, have tried any of these things before asking? It seems not because these are very basic commands listed in some very obvious default categories.

Perhaps, but tell us, what programs are they interfering with?

preference of ... macro and settings

Define what you think preferences and macro settings are. How do you currently set them. What steps do you take?

You can use variables in almost any field that takes literals as input. Macro Express substitutes the variable with its contents at run time.

Nothing except change your hotkey (your original solution) in either the app or Macro Express.

If I want to copy the macro file myself, is it:

C:\Documents and Settings\USER\My Documents\macex.mex ?

It is the default library, however, you can create your own libraries anywhere that you like.

Your question covers two different needs:

 

1) Backing up your macros. There are at least 3 ways to do this:

• Use the built-in backup feature.
  
• Copy the macro library (.mex) yourself.
  
• Do as Jason suggests (export and import).
  

2) Backing up your preference settings. These reside in your Windows Registry. The best way to do what you want is Jason's suggestion: Click on Tools and select Export Configuration.

 

If I export macros, does it save the categories I organized them in, as well?

No. An exported macro is just a text file.

They cannot be disabled. If they could be disabled they would be rather useless.

The Repeat Until %N1% <> %N1% construct is just my way (and pretty much the whole Macro Express world's way) of generating an infinite loop. N1 will always equals N1 (10 always equals 10, 3 always equals 3, etc) so the loop never rings true, and therefore always loops.

 

The Repeat Start (Repeat 9000 times) command says to loop 9,000 times.

 

The Delay 200 Milliseconds command says to wait 1/5th of a second before looping again. Changing the delay to 10 ms means it will wait for only 1/100th of a second before looping. Which means that your macro will Text Type "1" now every 1-1/2 minutes (90 seconds) instead of 30 (1,800 seconds) minutes.

 

The Delay commands are accurate unto themselves, but in the overall scheme of processor overhead and the time it takes your computer to run a command, they should be considered only as approximations. In other words, I wouldn't use them to re-sequence DNA strands.

This macro will click your mouse 5 times per second and hit the "1" key once every 30 minutes (all times are approximate).

Repeat Until %N1% <> %N1%
 Repeat Start (Repeat 9000 times)
   Mouse Left Button Click
   Delay 200 Milliseconds
 Repeat End
 Text Type: 1
Repeat End


<REP3:08:000002:000002:0001:1:01:N1><REP3:01:000001:000001:09000:0:01:><LCLK><MSD:200><ENDREP><TEXTTYPE:1><ENDREP>

And to prevent the window flash or flicker while it is being moved and resized, you could hide it first and then show it afterwards using the Window Hide and Window Show commands.

Is there any way to make this Activation thing work once and only once for each record?

No direct way that I can think of. I agree that you would need to trap the record number, save it a simple text file, to the Registry, or as an environment variable, and then wrap the macro in an If/End If construct. The macro would fire, but would not process. You may be surprised as to how fast all this can happen.

 

This is only a suggestion, there are probably other creative ways to solve the problem.