randallc

hi guys, ** IGNORE THIS PLEASE Thanks, Randall EDIT-Sorry, tried to import IELoginPopupMenu.mex as a "playable macro"

Hi, No, I believe that is expected behaviour for Excel spreadsheets; locks out other use while open. Maybe a "save" macro that makes a copy as well with another name; which does not stay open? Best, Randall. PS I did not know you could process spreadsheets with "csv" process, anyway! - I thought you had to "saveAs" csv; are you able to post the snippet of how you do that? ThanksIA.

Hi, Like to help, but don't know enough about networks; I hope someone out there can help. Best, Randall

Hi, I gather you are saying this works at times, then stops? Kevin may be away, so pribably no Insight people on this list at present? I suspect you may need to talk to the Insight people direct? - find contacts on the ME3 site; I have not had to do that; good luck! Best, Randall

Hi, There are a number of examples on the forum, and at the Macro Express3 site; and I suspect in "help" files. See multiple choice in my signature under "DOS"; there is a link; again here; DOS multi choice In the "case" commands, just insert your directory to open. Best, Randall

Hi, You may need help from a Word group; eg Word forum I think there is a way to "find a field" in Word, but have not done it myself. (? would you have to name the fields first, then go to them by "goto" or "find"?) Best, Randall [EDIT - maybe, alternatively, just use goto and cycle through the fields as "anyfield"; like tabbing?] (post a document with your fields if you like and I'll have a look)

Hi, Is this what you did in the end? - So quick and easy... Else; really slow, but interesting to me with Excel COM in MEBasic; Best, Randall

Hi, I had hoped one of the ME guys would answer this; I don't know; I don't use "Shortkeys", only use shortcut combinations, so I guess I never see this problem. I don't know where I would use these keys you are using in preference? Best, Randall

Hi, Perhaps the "tab" after a null Texttype of T6 acts differently and takes you out of that edit box to a file-handling box? I don't have Quickbooks so can't really tell; try a text type for T6 only "If" not empty? Best Randall

EDIT - my mistake!

Hi, For my 2-penneth, looks OK to me! Good luck, Randall

Hi, I can reproduce the problem and appear to fix T1 if I put the delay 1 sec(? needs only 200msec or less) after "control-c". Copying to the clipboard often needs a delay unexpectedly (use "Clipboard Copy instead? - but may still need a delay) Watch it by inserting "Text box Display" after your first "control-c" and control up and T1 from clipboard. Best, Randall

Hi, I'd love to see and understand the problem; Can you try to select the whole script, then in the text box of the reply (like this) press "quote" button, paste the script, then "quote" again for end quote; I can then copy it to my script editor and examine. Best, Randall

Hi again, Yes, "Macro Express Explained" has really helped me heaps since it came out last year; I can thoroughly recommend it; there's so much to the program I would never have thought about otherwise (there still is...!) Best, Randall

Hi, Did you know if you copy my code into script editor, it will copy the script? - Did you try using it? You are making it more difficult to read by inserting "line breaks" etc. You are probably in trouble with the command after that you have posted; you are trying to open another window ("paste Special") and not waiting for it before sending more keys; Best, Randall PS I agree with you there seems to be lack of waiting for the "control" key sometimes here when not expected; I think there is some way to empty it from the keyboard buffer too; better to not use a key you have just pressed (Cntrl-Shft-F6) in the "wait for key" command) I would prefer to use named windows and waits if you can;

Hi, Are you leaving long enough after you pres "enter"?; this works for me; But that delay is excessive. Do you realise this will copy the cell below where you hit "enter" if "enter" is used to move down one cell (as set in my excel)? Best, Randall

Hi, Don't know; can you post a bit of code and I can test on another computer? Best, Randall

Got It - Really! Oh Dear Again! FIXED (please!) in 5.2.2. Looks as though no-one else will have had it running either! I have been lucky on my machines that I had another "ini" file present (left over from another program) AND a test file (test123.txt, with anything in it!) which saved me from the error. Best Randall

Hi, EDIT- probably was not the "new" problem; ? 5.1.9 working OK? Randall

Hi, If anyone else still has tried the Wizard and got "no "commands.ini" file, try the following; I had a Win98 machine with the same problem, and would not find the ini file until I deleted the old non-working one; now Win98 works! Try: 1. Delete “commands.ini” from ME3 directory (old non-working, empty “ini” seemed not to delete with a re-install). 2. Use most recent “zip” file download for most recent versions. 3. Start “mex” library. 4. Run “startwizard” macro (starts automatically, scheduled at startup if you terminate and restart ME) Please let me know if this does not work. You should not have to edit to change install directory if you follow above. Does it work now? Best, Randall

Hi, I presume the tab does not have a keyboard shortcut on the label? Randall

Hi, The "amateur" addon, MEBasic, now accesses Excel directly by simple "ExcelReadCell$". This also means formulas can be used in excel, and high precision maths, loan calculations, etc available in excel are available in addon ME3 (without actually running excel). (eg power(7.1,-3.1) etc, including cube etc roots) Best, Randall

Hi, I suspect it will always be a bit tricky in a game; in other apps, you would want to be sure you were in the correct Window or control by activating them first, to be sure of the correct response to "esc"; do you know if the cursor is at the right place before you press "esc"? does it work manually? I may not be able to help much. Good luck, Randall

Hi! I can't tell your problem; did you get a script to post and it might be clear? Randall

Hi, I agree with you, that the structure is way too different. You wouldn't need AutoIT, of course, the first step would be vbscript; really chalk and cheese! Best, Randall