randallc

Hi again, THIS MACRO GOES THE WRONG WAY: FINDS THE ZIP FROM FIRST FEW LETTERS OF THE TOWN NAME; is the State in that text file to do your request? I looked into it ; I could only find November 2004 on the net.Large txt file, so you would have to put it n your ME Install directory as "txt" file. Fast, I think (2 secs? Only takes the first 34 possibilities unless you have code Wizard and my MEbasic (needs new version rather than those posted; let me know if you want them) installed (as limitation of multi choice menu). Best Randall USZIPCODESDATATEXT.zip

Hi, John, I'd be interested to see how reliable my new Excel com macro function was in this sort of situation; I have no zip codes, not being n USA, but could you email me the excel sheet to try? (prima facie, of course, it may work better with "text file process" anyway if you changed it to a text or csv file?) Best, Randall

Hi, Cory, I wonder if you would be interested in adding any subroutines to the MEBasic set of UDFs I have been putting together? The aim is; 1. Add simple re-callable UDFs to ME. 2. Make them simple to write with the Wizard. 3. "demo" therefore what we would like in ME itself (and/or PGMmacros) As you know, it is buggy (less so as time goes on, despite your experience!) and a private set of UDFs. Each macro just needs to be a sub-routine with certain parameters input to start, and certain others output at the end. I have just got going some other ones not in the posted form; Excel com read/ write/ add to cell; Folder picker starting at a given directory, and others. I have dates working for any input I have been able to imagine, (including Region- appropriate), and checking now to avoid crashes. I am planning File Write Date stamp and others. I am especially interested in getting some com for other Office suites, but do not know Outlook command lines etc which you seem to do, and I have not used email subroutines at all in ME. Best, Randall (Same invitation to any others with sub-routines out there!)

hi, Cory, I would also be interested in this. 1. I know there is a facility in PGMacro library for this (layers of variable usage), and maybe Floyd can explain that. I have not used it yet. 2. where I am repeatedly calling routines, and self- calling recursing multiple times, and have this problem, is obviously in my home-made "MEBasic". I usually have only a few "parameters" (1-4, say), and an "Answer" at the end, so I do a full "Save" at the beginning , once only, then "Restore" after each recursion or sub, and save any required vars as environment vars (eg "Parameter1", and "AnswerString". I think it is not perfect, but the naming is easy, and after each I only have to retrieve "AnswerString". and however many other variables, by number and parameter name, that i know should be returned. I'll be interested to see what you come up with. Best, Randall

Hi, Cory, My experience with a variety of macros is that control can be much more precise and generally make macros more reliable. I think it may be because you can choose them more precisely for timing than "Wait for Window", which can sometimes be hard to differentiate from each other? A while since I changed over, and maybe just re-writing the macro timing did the trick rather than the controls, though! Now I realise I can use "Wait for Window1" OR "Wait for Window2" etc, I might not need them so much; not sure. Multiple Choice With Wait For... You're right about the "intuitive"; it "feels" better to write text to a control than rely on the keys posting to the right spot! Also, I haven't used it much apart from on trial basis, but theoretically, i quote from elsewheree; This woul avoid requiring focus, and decrease broken macros further? Best, Randall

On one machine I get "Can't find [long filename].vbs the first time I run, intermittently; usually when it is running slowly, then runs OK the 2nd time Randall

You only have to create them once for each macro session (till you terminate Macro Express session)! Sure, they are not preserved, but that is good as far as I'm concerned; I wouldn't want to have to keep track of them and empty them after each macro session. (They would clog memory eventually) My point is the lack of having to remember which "T string"variables to use. Best, Randall

Or to take it further, use no strings at all; or only 2, and then empty them; I have started using environment variables a lot more as I only need to keep track of their names, not whether I've used them before; Best, Randall

OK Kevin, I will change it in time; I have not heard of any more problems with the install path since I fixed the syntax, but that may just be because people have given up after all yesterday's glitches! Please let me know if you are able to get the Wizard running. (anyone?....) Best, Randall (PS I think some machines are too fast, and have not been taking in the installation path; today i have added a delay

Hi, Cory, [(PS I think some machines are too fast, and have not been taking in the installation path; today i have added a delay] cf previously in this thread; (I am not sure what the Macro Express guys would say about a "List box" being part of any program"; I doubt that would be the case for most macro programs, which were not usually designed with GUI interface) Instructions on Wizard thread Very much a personal add-on program of mine, very early and buggy at times ( I hadn't realised it still was). I have added this feature to it just because of your problem, and can't get enough exact feed back from people to find out why it runs for me and not others. I thought you had given up on it anyway! The instructions for intallation of the Wizard are on the links in my signature (only needs to be ["MEbasicWizard.exe"] latest upload, put it in your ME installation directory), but I think you are too hassled and busy to have read them all. You shouldn't need MEBasic for the text line picker. Hope it works out, Randall

Hi, Cory; (Standalone with the wizard installed; I meant don't need MEBasic or import into library.... it is based on using external program, and that .exe file needs be in ME directory....) Wizard Randall PS EDIT 16th June; delays help on some machines[Probably a limit of 4096 lines?] TextPickerWizard.mxe

Hi, Kevin, Yes, I use the "RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Insight Software Solutions\Macro Express\Miscellaneous","Install Path")" in the Wizard; but I added the extra "\" by mistake, replacing "\macex.exe" with "\" instead of ""! I still may have the script wrong....? WOOPS! - Sorry again, I had the fileexists directory wrong in MacroExpress, not Wizard! line 13 if you want to fix it manually; I've uploaded it again Randall TextPickerWizard.mxe

Hi, 1. If you have a vbs script already, it may be easier to run that from ME and send the answer back to ME via an ini file, registry entry, text file or similar (see Floyd's examples) 2. Others have got this sort of thing going, I think; but I have not used either; pixels You might ask "ol3ears" about his - (from that other linked thread)? Best, Randall EDIT - fixed reference link

Hi, Sorry! - Thanks for looking - See latest version (start of thread); ? corrected path; both work for me; mustn't matter if its on C:\ drive, I guess! Randall WOOPS! - Sorry again, I had the fileexists directory wrong in MacroExpress, not Wizard! line 13 if you want to fix it manually; I've uploaded it again TextPickerWizard.mxe

Hey, Cory, I think it is working.. Screenshot Using latest upload of Wizard. Wiz TextPickerWizard macro can even be standalone.. (Sorry - Standalone with the wizard installed; I meant that you don't need MEBasic, nor do you need to import into library.... it is based on using external program, and that .exe file needs be in ME directory....) Randall WOOPS! - Sorry again, I had the fileexists directory wrong in MacroExpress, not Wizard! line 13 if you want to fix it manually; I've uploaded it again TextPickerMacro

OK, I think I kno wall that has been on the site, then; I was only able to work out how to script those HTA listboxes by copying the scripting Floyd wrote; HTA script is very cumbersome for this; although there may just be commands that I don't know; I doubt it as I think it is a very basic approach there. I'll look at modifying the Wizard, though! Tell me if the TextpickerHTA2 does what you expect in the list selection? - I was concerned it would be slow if you open 1000 lines? Best, Randall

Hey, OK I did attach a modified one! -Let me know... Randall

OK! Couldn't you have deleted those 3 lines?!!! Good luck - I don't know if it will do what you want. What is this one of "Kevin's"; do you have a link? Best, Randall (Seems to have a limited nember of lines, though) TextPickerHTA2.mxe

Hi, As the "HTA" in this instance is "written " line, by line, in the macro, before it is created, and contains the requested lines within itself, i think you can't do it here. Whether vbscript has an inbuilt "listbox", I doubt. The "Wizard" program (using AutoIT program externally) could be kept running and make such a listbox, say, to send back to an "ini" file or registry; I would have to write the script, though, so time -consuming, and not a rapid answer for you. You will have seen the "formmaker" wizard i wrote; very basic, and no list boxes, only form fields; FormMaker7.mex Form maker topic (btw your query about linking to macro; 1. Macro write HTA in process, then creates and runs it (so info contained) 2. sends back via "registry" entry Randall

Hi,Cory, I don't know if I can help you get there quickly. Although I wrote it, I did so by "hard coding", I think! Modified a previous vbscript, put it in special lines in mE macro as you can see in "filepicker" or txt picker" macros. Explanation of Filepicker I would like to help; but i suspect you were hoping therer were an easier aswer? lwet me know if I can do more! In the text picker, you can see in the macro that I just wanted to show the possibilities. You would need to modify those lines above for; 1. Checking input 2. Modify the match (all I have is checking if the 3 keys "are comtained" in the first 6 letters of the text lines so far; you could modify them to be the exact first 3 letters etc? Best, Randall cf

Hi again! This version is "spiffier", doesn't search in Notepad (only copies the source and closes) It also does not need MEBasic MEX, and so can even run standalone on your desktop as a demo of opening and shutting sites etc. you would still need to import it to your own macro library for editing to make it do as you want in the Edit site! Otherwise the same; in your own scripts, add the timing frequently , extra 1/2 sec delays for copying and tabs may help. Best, Randall WebEditButtons3.mxe

Hi, Try "Variable set String" Option "from file name (Prompt) Best, Randall

Hi, Yes, it is confusing. If you would like to try my working macro, you will need to follow instructions below; let me know if not clear enough. 1. Download MEBasic current version "mex" (not mxe) library, eg to desktop, double click on it (replaces your current macro file library, but leaves it intact to reload later (Menu / File/Reopen/1 (or "macex.mex" in a certain directory as shows at the top of the ME Editor). (Go to the forum location for download from the link in my signature "Basic ME".) [Actually, to make it easy, download it from here as latest version, and I have included it] ME Basic zip Discussion if needed [Normally, you would then; 2. Download the "WebEditButtons.mxe", and import it into the library; Menu / File/Import/Import a playable Macro/ select from Desktop or wherever you downloaded it) 3. Open your Web page 4. Run the macro (Hotkey is set as "Alt-Control-W) Let me know if not working! Best, randall. PS I "nearly" had it working the other way, by tabbing, and could have got there in the end, I think. Using source, you do not "click" on the button, you extract the address, and use it in the WebPage open command; = You will see that I Selected in source "alt='Edit', then 5 lines up to a string, then cut out the URL between href and ">". My string handling in ME Basic just saves the extra string handling macro. In the code above, (Even if it is working, you will need to modify the lines when the Editing page is open; all I do is "cntl-ENE, insert a line, tab to submit button and press enter; you would need to "crtl-a", copy, tab to the window you want, paste, tab to submit button; ) Best, Randall

Hi, I imagine the fastest and best way with a text file is to use the Text File process command; in a loop from begin to end process. I am not sure that you found that in your search? Randall Text File Process1 I have used it in; Text File Picker for instance.... Best, randall

Hi, Do you just want a picker like the file picker?? If your 1000 items are in a text file (ie each item on new line); with a few lines of code changed, it becomes a text picker; enter up to the first 3 letters (or change the code yourself of the prompt), and enter the name of the file (at present a prompt, but put in file name), and the picker list will come up. Let me know if this is useful, or you want to adjust; or do you mean something else altogether? Best, Randall EDIT - PS the lines to alter the input are early in the macro (10-19); The lines I alterd from Process in Folder for file names in directory to Text File Process for lines in a text file are nearer the end (193-205); TextPickerHTA.mxe