randallc

Hi,

For some reason, ya gotta right click, and saveAs with mxe extension; this forum has probs, not ya PC!

Randall

Hi,

this might help ; let me know; uses vbs to calculate number of days back from today

Best Randall

DateDiff.mxe

Hi,

Using WinZip cline; will that still be locked? - or will it pass the parameters?

<LAUNCHNO3:1:0002wzzip<LAUNCH:wzzip.exe<PARAM>c:\backup\T10.zip %T10%>

Launch and Activate: "wzzip.exe"

Hi,

Looks great.

Works for me doing;

Change Directory/Folder: "C:\Programs\SearchEngine"

Program Launch: "test3.hta"

<DOFILE:01:NN:C:\Programs\SearchEngine>><LAUNCHDEL2:0:00C:\Programs\SearchEngine\test3.hta>

Perhaps you have made the new text file in nthe default directory and couldn't find it? Change directory first?

Best, randall

Hi,

I once tried to get this running better; see other link;

Make your own Forms for inputbut still too hard;

If you are willing to post your macro and javascript, every chance i can get it running!

Or pm me and attach them.

Best, randall

Kevin,

Thanks, I'll have a look..

randall

PS - I don't know why it was there! - deleting it worked; thanks heaps.

Hi,

I've had no answers; is this just me, or has everybody else got no function since ie7?

Randall

hi,

Since ie7 I get an error;

Macro Express: macexp.exe - Entry point not found

The procedure entry point getprocessImagefileNameW could not be located in the dynamic link library PSAPI.dll

Web Site: http://www.mymail.com.au [Default Browser - Wait to load]

<HTTP2:1:T:http://www.mymail.com.au>

Any ideas?

Randall

[ME 3.5.5.1 - last ? yes]

Hi,

Best to show your script;

if the integer is BETWEEN 0-6 give me a 0, BETWEEN 7-12 give me a 1, BETWEEN 13-18 give me a 3....

"int<12"

Best, Randall

Hi,

[*** This only works, of course, if Wilcards work with your planned "wait file exists" anyway?... do they?]

1. Is this the sort of thing you are asking? It allows you to set a time to wait in the "Text Box Display: timer"

Text Box Display: timer

Delay 100 Milliseconds

Wait for File Exist: "macex.000"

  OR

Wait Window Lose Focus: "timer"

If File Exists "macex.000"

  Window Close: "timer"

  Text Box Display:

End If

2. can someone remind me of a more elegant way to time out please; I know I've seen it somewhere.

Best, Randall

Hi,

What about you [loop] move 2 pixels to the right, and test for mouse cursor being an arrow (safe to click)?

Randall

<REP3:08:000002:000001:0001:1:01:T1><IFMOUSE:1><LCLK><EXITREP><ENDIF><MMP2:2,0><ENDREP>

Hi,

More "MacroExpress" friendly, you can just import the DateDiff.mxe, gives date difference as %N1% (using vbscript)

if your local dates are "MM/DD/YYYY" instead of "DD/MM/YYYY" you will need to adjust lines 3 and 4

Date/Time: Save "dd/MM/yyyy" into %T11%

Date/Time: Save "dd/MM/yyyy" into %T11%

Then you can simply "If variable" compare on %N1%

Best, Randall

DateDiff.mxe

H,

Alt-Left , then alt-right?..... if you don't mind leaving the page for a bit!

[or, better, "F5" for refresh!]

Randall

hi!

Repeat until T1<>T1

Repeat End

Best, Randall

Good point; I was only thinking of an opportunity for someone to check my macro, I guess!

Can you link even if you don't know the names of the workbook files?; maybe he does...

Randall

Hi,

It ran the second time on a new machine, but not the first; can you please try it again sometime?..

i imagine I need to declare the registry items once first in future...

Here it is (unchanged), but so it runs "visible"; easy enough to change those lines back to "InVisible"..

Best, randall

XLRowsToSheet2a.mxe

Hi,

Tahnks for looking at it; I have found some errors and corrected them elsewhere; I'll try to re-do it for MEx and let you know.

Best, randall

PS - I get the same error now; it was working when I poosted it! -Oh well, I'll let you know

Hi,

1. Slow, using vbs; are you in a rush? [** Assuming the 3 digits are day number of year and NOT after today!]

Variable Set String %T11% "210"

Variable Modify String: Save %T11% to Environment Variable

Variable Set String %T12% "2005"

Variable Modify String: Save %T12% to Environment Variable

Macro Run: DateSerialDiffVBS

Date/Time: Save "yyyyMMdd" into %T1%

Text Box Display:

<TVAR2:11:01:210><TMVAR2:19:11:00:000:000:DateSerialDiff><TVAR2:12:01:2005><TMVAR2:19:12:00:000:000:Year><MACRUN2:DateSerialDiffVBS><DT:yyyyMMddT:01:3:{P0%N1%}{P00000}{P00000}{P00000}><TBOX4:T:1:CenterCenter000278000200:000:%DateSerialDiff%(%Year%)=%DateSerialDiffAnswer%

N1=%N1%

Date in T1=%T1%>

Randall

[cf previous post for example macro]

EDIT; Of course, you only have to run this slow vbs once, because it gives you today's "Day of yaer" as sum of original number plus returned "%DateDiff%" from that; so you can

a. calculate any further differences from today's day number of year for the 3 digit

b. put them into N1,

c. put them in the "days back" from today

<DT:yyyyMMddT:01:3:{P0%N1%}{P00000}{P00000}{P00000}>

Best, Randall

DateSerialDiffVBS.mxe

Hi,

there are 2 spaces between "ams system"

what others?

Best, Randall

[see next post for necessary attached function-macro to run this]

DateSerialDiffExample.mxe

Hi, cory,

I'll be interested to hear if there's an answer to this; workaround is to paste it to an open word doc, I suppose, and retrieve again later, without using variables

best, randall

i'd have to see your exact macro to help.

Have you tried the "Launch program" command in a macro; you can specify the program and the file there...

Best, Randall

hi,

In brief, use "Text File Process" to string, say "T1"/ endprocess loop;

in the loop ; compare T1;

Variable Set String %T2% "Not Found"

// Put in your file path and name here

Text File Begin Process: "Answer.txt"

  If Variable %T1% contains "Known Good"

    Variable Set String %T2% "Found"

    // Exit here if you only need to find one instance

    Repeat Exit

  End If

Text File End Process

Text Box Display: After

<TVAR2:02:01:Not Found><REM2:Put in your file path and name here><BTFBEG:001:000001:000000:C:\Program Files\Macro Express3\Answer.txt><IFVAR2:1:01:7:Known Good><TVAR2:02:01:Found><REM2:Exit here if you only need to find one instance><EXITREP><ENDIF><BTFEND><TBOX4:T:1:CenterCenter000278000200:000:AfterT1=%T1%

T2=%T2%>

One idea would be upgrading to the latest Macro Express release. Version 3.5e.

As I said in previous thread, I have had to go back to 3.5d...

I am not sure what was changed, or corrected, but I think the windows for "copying files" and "deleting files" are behaving differently than before.

Is this deliberate , and a "fix", or a bug?

Thanks, Randall

Perhaps more useful, "eval" to evaluate a maths line; eg

4*5/sqr(64)

Best, randall

(Don't forget to download the function macro, 2 posts back,too!)

TrigExample2.mxe

See previous post (first time posted had error; fixed now?...); here is better example; does other math too; [this macro is example to run previous; import both]

// Example of Trig Functions uses vbs ; output as %TrigAnswer% env variavle; AND as %D1%

Repeat Until %T1% <> %T1%

  Variable Set String %T11% "Tan"

  Multiple Choice Menu: Trig Functions for ME3

  Variable Set String %T12% "30"

  Variable Set String %T12% from Prompt

  Variable Modify String: Save %T11% to Environment Variable

  Variable Modify String: Save %T12% to Environment Variable

  Macro Run: TrigFunctionVBS2

  Text Box Display:

Repeat End

Macro Return

Tan

Sin

Cos

Atn

Exp

Hex

Fix

Log

Sqr

Randall

TrigExample.mxe