randallc

hi again;

Woops - I don't think so; I doubt you could "object create" as you can in Office to do the "Com" thing; which my program relies on;

sorry! (unless you find it is posible; a quick web search found nothing)

I'm sure it is possible with AscII, just not familiar.

Best, randall

Hi!

That's a worry; think I need an explanation of why you would register those names to go any further!

Best, Randall

Hi again,

I wouldn't bother with the AscII file, but that's my prejudice; I would use excel, as it would be easy to select the row and column;

Excel Function For Wizard

Maybe someone else knows how!

Best, Randall

Hi,

Interesting!

prompt the user to click on the new file and look at it with the built-in viewer [i sure wish Mx could do that],

Then you could right click to"view" ; ie "open briefly" with Adobe or iE Explorer, and exit to select or not?

Best, Randall

Hi, kevin, Floyd,

Yes, Win XPSP2

I have found the problem, I think; all working now; the macro did not prompt for non-existent initiation folders, and dos did not tell me the error.

/-c works from dos and the macro.

The macro also made no allowance for quotes if required in the dos command (say, "%T3%" might be "InstallPath", for instance)

Best, Randall

Hi, Cory, Joe,

That macro doesn't work for me unless I remove the "/-c" switch [and some other changes!?]; have you tried it?

Best, Randall

Hi,

no, Joe's code here is not direct code to import; download his "zip", then extract the "mxe" file, then import it to your library as "playable macro import".

best, Randall

Hi,

Please see topic on other forum; still needs Wizard.exe, but not MEBasic library; just a macro download, then communicate directly with Excel files without (necessarily) opening Excel to see.

Best, Randall

Excel Function For Wizard

I agree;

here's a link to an old macro to give you an example; looks up zip codes by "text file process"; hope it helps give you a direction.

Best, Randall

Zip codes text file process

hi,

Maybe my new macro will help you;

puts the text file lines into a column in excel; though you need to use the "Wizard"

Best, Randall

Excel function for Wizard

Hi,

I can answer the second question!

If you copy the Direct text code into the scripting, editor, it imports as the script1!

Best of luck, Randall

Hi, Try prompting to select file?

Is this what you mean?

<TVAR2:01:01:c:\temp\><TVAR2:01:09:Choose Filename for attachment><TBOX4:T:1:CenterCenter000278000200:000:here it isT1=%T1%>

Variable Set String %T1% "c:\temp\"

Variable Set String %T1% from File Name

Text Box Display: here it is

Hi,

I think your options are to;

1. Save/ read variables from an "ini" file - probably best.

2. Save/ read variables from a "txt" file

3. Save/ read variables from the registry.

There are examples of usage, but I'd have to look if you need them.....

Best, Randall.

hi,

yes, quick, efficient and reliable as you plan it, I think; what other ingredients for "elegant"!

Best, Randall

Hi guys,

Unfortunately, I think your assessment may be correct, though I have no "elphi" apps to check.

On the other hand, getting the control by position might still work, even if name does not; I thought it was the "Capture" control rather than "Get " control which did it by position; am I wrong, Kevin?

Best, Randall

Yes, thanks,

I am really lazy, though!

Can you add dummy files, folders, registry settings, or prompts for these [or prompts to create what is needed?] in the macros so I can see the end product of the macro action?

At present, they do nothing if I run them.

Best, Randall

Hi, Cory,

Fantastic,

I will check later.

Can you re-paste the "Macrotext" as it does not copy properly by cut and paste?

Thanks, Randall

Hi Cory,Great to know!

Here is a Wait for increase number of files in a directory, longhand, for interest or improvement.

<TVAR2:01:10:><TMVAR2:19:01:00:000:000:FolderName><REP3:07:000001:000001:0001:0:01:%FolderName%><NMVAR:08:01:0:0000001:0:0000000><ENDREP><TVAR2:01:01:%N1%><TMVAR2:19:01:00:000:000:NumberFiles><REP3:08:000002:000001:0001:0:01:%NumberFiles%><IVAR2:01:01:0><IMSD:50><REP3:07:000001:000001:0001:0:01:%FolderName%><NMVAR:08:01:0:0000001:0:0000000><ENDREP><TVAR2:01:01:%N1%><ENDREP><TBOX4:T:1:CenterCenter000278000200:000:New Filethere are %N1% files in the folder

T1=%T1%

NumberFiles=%NumberFiles%

N1=%N1%>

Variable Set String %T1% from Folder Name

Variable Modify String: Save %T1% to Environment Variable

Repeat with Folder

  Variable Modify Integer: Inc (%N1%)

Repeat End

Variable Set String %T1% "%N1%"

Variable Modify String: Save %T1% to Environment Variable

Repeat Until %T1% <> "%NumberFiles%"

  Variable Set Integer %N1% to 0

  Delay 50 Milliseconds

  Repeat with Folder

    Variable Modify Integer: Inc (%N1%)

  Repeat End

  Variable Set String %T1% "%N1%"

Repeat End

Text Box Display: New File

Hi, Floyd,

No, I think I have tracked it down; when you Wait for file ready" for saving vbs file, you have only allowed max 5 secs; when memory is swapping there may be a delay?

Randall

Hi Rick and Floyd,

Glad to hear Floyd's string split helped.

Incidentally, [and as a reminder to myself!] to extend my comment on parsing, for large strings where even the pgmacro function fills the registry with tokens, instead of "tab" in my example above , we could relace with "crlf", save string to text file, then text file process; I haven't seen this done but should be good for parsing large web pages etc too?

Best, Randall

Hi,

Strangely, I reproduced the problem (partly!) on another computer where I had not installed 3.5d fully (just had the new exe file, but not installed!).

This machine the macro Always! seized up; fixed by re-installing.

Have you done that?

Otherwise, it is probably an installation setup problem, I would guess, and you might need a techno person at Insight to help.

Best, Randall

Hi,

If you can ignore the apparent bug for the present, I am aware that the problem was generated while trying to Login to a WebSite; there is the question of trying Joe's Web Login macro;

Login Automatically To Web Sites - the macro below should work stand-alone, having been generated by Joe's;

Attached is my generated Login for your Dallas site, for interest.

Alternatively, you could use my WebLogin by the wizard (see link in my signature), which also works for Hotmail and Yahoo, as well as here and iframe sites [still not for most banks etc] [and allows ME usual text encryption, as well as an option to leave part of password to fill in, instead] [Parameter5 gives option of naming the first link to click when site starts up too] [just change the username and passwords in encrypted text to use your own, though works as it stands with mine] -THIS ONE ONLY WORKS if you have the wizard in the ME3 directory as well as the playable macro!

{_DallasWIZ}.mxe

Best, Randall

DallasLoginGenVBS.mxe

Hi,

Working with excel, sometimes its easier to put your cell into a string containing tabs and paste them into a row you select [Excel uses the tabs to separate them into separate cells], then manipulate the cells [in your case into columns] in Excel;

<REM2:Set up tab environment variable chr 9><ASCIIC:1:1:9><TMVAR2:19:01:00:000:000:TAB><TVAR2:01:01:*123*tyu*gjh*bnm*kklj><REM2:Replace each bullet with ["tab"and bullet]><TMVAR2:21:01:01:000:000:*%TAB%*>

// Set up tab environment variable chr 9

Variable Set %T1% to ASCII Char of 9

Variable Modify String: Save %T1% to Environment Variable

Variable Set String %T1% "*123*tyu*gjh*bnm*kklj"

// Replace each bullet with ["tab"and bullet]

Replace "*" with "%TAB%*" in %T1%

Activate or Launch: "Excel" OR "excel.exe"

Text Type: %T1%

hi,

I have tried that website and cannot reproduce your problem.

Can you post your actual code?

1. ?"wait web browser launch"?

2. ? default browser?

3. ? encrypted text to variable?

Randall

Hi,

Yes. I hardly ever see them!

I have one machine with intermittent low virtual memory (tries to run VmWare with XP and only 500Mb Ram!); it seems to be when memory swaps occur after that in particular (it may take a couple of minutes to get over it!)

I have not checked how you know if "vbs" is ready?

Best, randall