randallc

Hi, Try "Break"; is that in version "2.0e"? [is it there?] [if you are really using such an old version, it may "break" out of any loops it finds itself in, rather than just the one you want?..... btw] btw, I had to go back to version "3.5d" as it broke too many macros..... Anyone else? Randall

Here is the vbs version; needs only the attached macro to be imported to your library. Best, RandallTrigFunctionVBS.mxe

OK, Save your macro by. 1. File 2. Export "alt-P" [export as playable macro] 3. Name it and save (ext "mxe" comes bydefault) 4. reply to this post. 5. Attach [browse] yor mxe file 6. Add to post. 7. Submit post. I can see what you have got in your macro!... Best, Randall Types into an area or field or notepad you have already selected [instaed of Display Box]

Best, RandallPS

hmmm...! You need to paste the gear (from my quote box, not yours) into the MEX Editor, into the "MacroScript" area when your macro is open for editing (NOT in a text box) Hope this helps, - else post your script and I'll change it, Randall

Hi, Yes, you could (theoretically!) use my "MEBasic [access the example macro lirary mex file from my signature links]. You would need to add all your current macros to that library,and use the syntax as in the "Example" macros in that library ["alt-Shft-A" to run, from memory]. however, if PGMmacro library has that function, it would be more reliable than my home-made MEBasic. If you don't need all the rest, you are probably better to use Joe's approach to use a vbs script for "tan" and run it. PM or email me if you really want to go into detail. Best, Randall

As in Kevin's note avove; set Variable String from file; up comes an explorer picker..Best, Randall

Hi, Just to think laterally, can't you avoid your problem by using ME filePicker in your macros instead of explorer? , as it would not leave any extra Windoes left open Best, randall

Hi, That text box should format as starnge! Anyway, your format to follow Kevin's note should be; in the first line; thus; Best, Randall

Hi, Best, Randall

I am not sure what you mean here; if you do not want to use my folder process, the spreadsheeewt name goes into T30 for each run of the loop;Best, randall

Hi, I'd be interested to hear; 1. I guess I need to know if you have the Wizard working; it may only work in 2003 as it does not in Office97 for this task; aand may not even in XP? [check the ExcelWiz [and attached macro] macro is imported to your libraray with the correct name (see macrorun command), and Wizard. exe is in your MEX directory] 2. The macro I have sets T4 to the folder to process; change to the folder you wish to process 3. ; it will process all Excel files in that folder unless they fall out of the 4 "If" criteria; change the criteria as you find necessary. 4. Run the macro; outputs to "AnswerFile.xls" in your set directory unless you change it. 5. The extra line for name would go like so; change the row length to be imported else it won't fit if it starts at column B; thus [A2:IU2, instead of A2:IV2] [remember the second parameter is the sheet number or name too; I have them set to "1" at present] Let me know specifically what you cannot interpret; N1 for the file number in the folder you are processinng [to row number in answer sheet] XLRowsToSheet2.mxe

Hi, My Excel function will do that in the latest version, but I have not heard if the last one is running on your machine yet so have not posted. Best, Randall You need new ExcelComWIZ; And Only the "exe" in MEX directory from the zip; {_ExcelComWIZ}.mxe MEbasicWizard.zip

Hi, I have a 14-liner that will do this; but no point unless you can tell me the "Wizard" is working on your computer (ie see link in signature; ) let me know; best, randall

hi, are you serious about needing to use explorer click? some people jut don't realise tht me3 has its own windows explorer filepicker....? Randall

hi, or sometimes works; 1. Get control first to get location, 2. then use location to use capture. best, Randall

Sorry, I don't know; try yuor main "Run" command line at Windows start button; if that runs it ok, I would need to know more about js; ? a js forum?; best, randall

Hi, i have a GUI add-on in my link from signature; "GUIMenu...", which was designed for Multiple chioice menu; infinite text size and background colour (not text colour at present, but certainly possible except in the list itself..) on the "changes" tab. If you want, I could change it for text box display only, but some time and work! Let me know... Randall GUICtrlCreateListViewItem.zip

Hi, The line which detects end of spell and inserts a CRLF, ready for next line is; Change this to asemicolon instead?; -it means you have no endofline there; but I'm not sure how you are processing this? - presumably NOT (as I might) by using "ASCII file process"?) Hope this help, Randall

Hi, My Excel function will do that in the next version, but I have not heard if the last one is running on your machine yet so have not posted. Best, Randall You need new ExcelComWIZ; And Only the "exe" in MEX directory from the zip; {_ExcelComWIZ}.mxe AddNameImportSheetExamples2 MEbasicWizard.zip Best, Randall

Hi, Yes - See "Help" about running from command line Recent example in this post; Shell (MacEx3 + "meproc.exe /ARetrieverFromRegistryMacro") eg vba Best, Randall

Hi, I looked at your Field doc file; my macro seems to work; just change the field names etc and retrieve what you want, or copy contents to clipboard, vars etc....let me know if not Best, Randall [PS There are so many fields, the info needs to go to an ini or text file for processing back, I would think]

hey, Had you tried running my macro? It fixed all but your new fields. (if first changed long numbers of spaces to tabs) Here it is again; seems to work on the new fields as well. best, Randall try2.mxe

by the way, in relation to my presumption for it to work at present in those first few lines(that it was a tab mark), if there was more than one, you would need to replace strings of tabs until there was just a single tabl for this macro towork to come before starting it (or on each line). Alternatively, of course if they are spaces, you would need to replace a string of spaces with at least one tab before that! I hope that all works. Best, Randall. by the way, if you wish to actually "attach" part of a text file at least as an attachment, we can check whether those marks are tabs or whatever; you may be able to see in Word, for instance anyway.

hi, This replicates the example, but I'm still not sure either if is is exactly what you want ; all now ascii-quotes including the text as a single field. Try it. Best, Randall try1.mxe