Jump to content
Macro Express Forums

Leaderboard

Popular Content

Showing content with the highest reputation since 02/22/2013 in all areas

  1. Also remember to check out the a&ccelerator key things... from the help file (bottom of "Multiple Choice Menu" page): =========== Multiple Choice Tips Make one of the Multiple Choice selections the Default Let's say you want option B to be your default selection. Use the Variable Set String command and select the Set Value Now option. Set the value of variable T1 to B. Insert this command before your Menu command in the macro script. When the macro runs, option B will display as the default selection. Allow users to select a menu item with the keyboard instead of clicking wi
    3 points
  2. Preselect a value in the multiple choice by setting the result value to that value before showing the menu. IE when the multiple choice pops up one will already be selected. Then you can arrow up and down to select different values. Enter to accept.
    3 points
  3. You're welcome. Perhaps you could add something like this: Variable Modify String: Replace ":\\" in %tFolder% with ":\"
    1 point
  4. Be kind. He has been told this three times now across two or three threads. I think he's a newbie trying to get a feel for ME, so best not to scare him away. When I think of the questions I asked when I started using ME, most people must have assumed I was a total moron. Happily most of those posts are lost in the mists of history, but I could come up with more at any time. 🤔
    1 point
  5. Simpler than mine. Hardest part of making the macro is looking up the Excel keyboard shortcuts.
    1 point
  6. We can cut your nine lines down to eight, if we eliminate Variable Set String %b% to "%a%" and then do all operations on %a%. That should help us finish before the universe either collapses or squirts through a black hole into somebody else's universe. I tried all day to figure out how to use Terry's CRLF idea, just because I wanted so badly to use the Strip feature. Couldn't come up with a reasonable way to deal with even-length space strings. I did find that my version runs considerably faster if I precede my Repeat loop with the following series -- but only i
    1 point
  7. You could also restore syntax checking by running the MacDef.exe program in the c:\Program Files (x86)\Macro Express 4 folder. But, if you do that, all of your preferences will be reset to their default values.
    1 point
  8. That’s easy enough: copy the code section (not the command text), open a new empty macro, and paste it in. Or you can just import the finished macro I exported and attached for you, and run that directly.
    1 point
  9. ... If the older version does what you want, and is simpler to use, then it's perfectly OK to stick with it. After all, I still use the old Macro Express Version 3, and so far it does everything I want. If you have an experienced carpenter with an old hammer, why push him to buy a new one? 😉
    1 point
  10. Yes, me too. I chose a similar location, with separate keys for Integer and Text, and made it a 'Favorite' for fast access.
    1 point
  11. 1 point
  12. Trigger the counting macro when the entry screen appears. Then: // Variable Set Integer %N1% to 0 Repeat Until %N1% >= 6 Wait for Key Press: Any Key Variable Modify Integer: Inc (%N1%) Repeat End Text Box Display: xxxxxxxxxx (done, so start whatever other macro you want to run) //
    1 point
  13. Generally, in Windows, this appears as CRLF, not LFCR. Try this: Variable Modify String: Replace "-A%CR%%LF%" in %Temp% with ""
    1 point
  14. 2D 41 0D 0A 2D 42 0D 0A 2D 43 0D 0A 2D 44 0D 0A 2D 45 THis is how your text actually looks like to the computer internally. Each of those pairs is a hexadecimal representation of the binary. Each represents a byte, 8 bits, of data. By applying the ASCII encoding, you will get the letters and such that you are used to seeing. Click here to see a table of the value, E.G. 2D is a hyphen, 41 is "A". I think it helps people if they can see what it's happening behind the scenes. And in binary. How it actually is in memory or on disk. Cut those into chunks of 8 and you can manually d
    1 point
  15. Neat solution. I wonder if other browsers have such an extension available. You could also try this -- I do it with a number of web sites. Might be handy for a browser that DOESN'T have a similar extension. 1) Activate the macro based on window title. 2) In the macro, Alt-d to highlight the URL. 3) Copy URL to clipboard, then examine it to see if it's the one you want. 4) Fill in the screen, or exit the macro, as appropriate.
    1 point
  16. Hard to advise without seeing an example macro. For instance, are you activating it when a window is opened with that title? Or when it gains focus as @acantor assumes? And must it be an exact title or a partial one? What operations is it performing after starting? If for instance it's using a Text Box Display (TBD) to give you a message then as soon as you close that TBD it will probably regain focus and start the macro again. However, I've found that MEP sometimes does not respond reliably to window title commands. Timing or other obscure conflicts with the OS may be the cause. I
    1 point
  17. There are thousands of hotkeys. For example, there are about 750 hotkey assignments in Microsoft Word alone. So if you're into the macro scripting game, you will, in time, face situations where you find yourself "expropriating" built-in hotkeys. Most of the time, my philosophy can be summed up as, "built-in hotkeys be damned!" If there is a task that I need to automate via macros, and the hotkey I have in mind is consistent with other hotkeys, if it's memorable, if it's logical, and if the user has no use for the built-in hotkey and/or isn't aware it exists, then that's the key ass
    1 point
  18. It looks like there is a difference between a Floating menu and a Popup menu. When I click to choose the Menu Style for a popup menu I see: When I click to choose the Menu Style for a floating menu I see: It looks like the "Nickname and Scope" choice is only available for a Popup menu.
    1 point
  19. How many words in each name? Or does the number of words vary? If it's a fixed number of words, then selecting the names and copying them may be straightforward. Part of your script might look like this, assuming each name is two words long. (This is in pseudocode, but it's similar to Macro Express code Type "<CONTROL>f" // Find Type "@<ENTER>" // Search for @ and initiate the search Type "<ESC> // Cancel the search Type "<CONTROL><SHIFT><RIGHT> // Select the 1st word Type "<CONTROL><SHIFT><RIGHT> // Selec
    1 point
  20. It's nearly impossible without seeing all of your code. You have a loop or condition out of order someplace. Bear in mind that the line number it cites is often not the one that is out of whack. I find in cases like this about 50% of the time a line of code not even in the errors is the culprit. If you don't want to share your code then I recommend starting a new macro. Copy over only the loops and conditions with dummy code to track your progress. Work it out there to find your error. Also I will sometimes print my code and with a pencil write brackets tho the left of all the condition
    1 point
  21. I prefer to use an external script or program to get the source of a web page but if you prefer to CTRL+A and copy from the browser window (or use the control method) you can do so directly in Chrome. Simply prefix your URI with "view-source:" E.G. "view-source:http://bluepointdesign.com". Edge and Internet Explorer do not support this convention. I've only verified this works in Chrome and FireFox.
    1 point
  22. texttype win not working on my x64 windows 10 laptop. I am using mex 3.11a
    1 point
  23. Text Type (Simulate Keystrokes): <CONTROL>g Works for me.
    1 point
  24. I want to copy a column of excel and paste each cell values one by one below into another excel column where my cusror is, ignoring blank cells. I need one by one. paste cell one value then down arrow then cell two value its important. Splitting the array into each cell value is tricky for me and later pasting one by one value Please help
    1 point
  25. This will remove the name that is contained in %T[2]% from variable %[T3]%. Variable Modify String: Replace "%T[2]%" in %T[3]% with "" // Leave the "Replace Text With" box empty
    1 point
  26. If you sink enough time and effort into the problem, you may come up with a solution that almost always works. But you gotta love experimenting and tweaking, or you will likely find the experience a miserable drudge! I use a combination of techniques, including: - Clicking on a "neutral" part of the screen that resets the tab order. Then send tabs/shift tabs to the control. - Searching for a pixel colour on a control, or to something near the target, and then tabbing and/or clicking. - Searching for text on the screen. Then give the word or phrase focus, and then tab to the
    1 point
  27. I think this will work: Repeat with Folder (folder E:\Temp, putting file name only into text variable T1) Use Variable Modify Text commands to copy T1 to T2 and strip off the file extension from T2 Create Folder: "C:\%T2%" Wait for Folder Exist: "C:\%T2%" Copy File or Files: "E:\Temp\%T1%" (destination C:\%T2%\%T1%) Repeat End
    1 point
  28. Others can better help you if you post your macro in a form that can be copied (as you did) and in a form that can be read, like this: // Accepte l'invitation. Variable Set Integer %N[1]% to %bleu_invitation% Repeat Until %N[1]% Does not Equal "%bleu_invitation%" Mouse Move: %pos_accepter_invitation[1]%, %pos_accepter_invitation[2]% Relative to Screen Mouse Left Click Text Box Display: débug : Delay: 500 seconds Mouse Move: 0, 0 Relative to Screen Delay: 500 milliseconds Get Pixel Color at (%pos_inte_invitation[1]%, %pos_inte_invitation[2]%) Relative to Screen into %N[1
    1 point
  29. I hope this is ok being posted like this. A review of the forum guidelines didn't stand out to me as such, but I am tired and could have easily missed it. So if this isn't allowed, admins, please delete and I'll rephrase the request. Here's the short and sweet. I'd like to have someone review a video of a macro running I've developed for a client that's the first of many projects that we have to do through the rest of the year. I want to have a discussion about what's viewed at the 10,000 foot level with maybe the occasional 10 foot level. I don't need a bullet list of what's wrong an
    1 point
  30. I threw together a macro using ASCII File Process. Hope this helps. BTW, i'm using ME3 not MEP but there shouldn't be any differences here. This file process seems to ignore blanks. Hope this helps! How this works is that each loop it moves down a line. So data from A4 = %t1%, B4 = %t2%, ect. When it loops A5 = %t1%, B5 = %t2%, ect. That is why you would only need %T1% // Save a text file called asc processing file.txt // Have a spread sheet called Microsoft Excel - Book 1 Temp open Activate Window: "Microsoft Excel - Book 1 Temp" Text Type: <F5> Delay 0.5 Seconds Text Type: S
    1 point
  31. I can't see the screen image you attached. But I think you're talking about the icon that disables individual line(s) in a macro. For example in my screen shot below, I have highlighted three lines. If I click the icon the lines will appear with a line drawn through them, and will be ignored when the macro runs. In Macro Express 3.x it just happens that the icon is opposite line 9; it has nothing to do with line 9. As to why a line in your macros is not running, we would have to see the macro scripts.
    1 point
  32. My German is worse than your English, so I won't even try. I don't know if this will work or not. It depends whether the multiple choice menu is seen by Macro Express as a window. The multiple choice menu has a title. Start a second macro based on the menu's window title appearing. In the second macro, wait for a keystroke (any key) making the choice. In the second macro, type ENTER or use the mouse to click the OK key. The original macro that displayed the multiple choice menu should then continue. I can't test this because I have Macro Express 3, not Pro, and ME3 doesn't al
    1 point
  33. In Windows Explorer, manually place mouse over file name, click once to select the name. You could use other techniques, manual or macro-driven to do the selection. Macro can then do this: Type <ALTD>f<ALTU>m which highlights the name to be changed. Clipboard Copy the highlighted name. Set String T1 from clipboard. Variable Modify String: Lowercase %T1% Text Type T1 which overtypes the highlighted name. Text Type <ENTER>
    1 point
  34. Attached is a sample macro file for you. Below is the text for cursory reference. You should be able to at least understand the approach here. Also good to save this as a macro you can call later in other applications. Here I snab the text values for day, month, and year and convert them. Then tweak them and add them to the default value of a DateTime variable. Before I used this method I tried to to do the math but it's hell once you start considering all the leap year rules and so forth. I did it but it was very complicated. In VB.NET this is a simple cast command. I hope someday ISS will ad
    1 point
  35. The most important thing to know about dates is that they're internally stored as decimal values. 1 = 1/1/1990. And each date is a unit value of one. Time within a day is a decimal amount. EG. 0.5 = noon. So really all you'e wanting to do is set a date value and modify it to remove 90 days. Then compare that date to your date to determine if it's less than it. So create a variable called DateThreshold or something like that. Subtract 90 days from it. Now compare that to the suspect date..
    1 point
  36. I frequently struggle with this limitation of MEP. I even offered to write a generic .NET add-on program to create a multiple-input form on the fly for users. But there was no interest. The best advice I can think of for you is to use a multiple choice menu but use the multiple choice option instead of the single choice. However this will only work if you have Boolean responses. Another option might be to have a Text Box with multiple lines that would act as a display that you leave up. Then use a variable Set form user input box to affect it. I'm thinking you could enter a line number fol
    1 point
  37. Thought I would pass this along to the forum ... Started the new Professional Grade Macros website. Not much there yet, but over the past few weeks I was working on its overall design and layout. The first task was to get all the tutorial videos, as well as the mex library, which were created for the Macro Express Explained book onto the site so people could still get access to them. Over the past couple of weeks there were plenty of downloads. Posted an MXPro article today. - Joe
    1 point
  38. Hi Cory I just published a preliminary video on my pgmacros website. It's about an MXPro multiple field utility close to its initial release. Something that was done by myself and good 'ol Floyd way way way back when was not really suitable for today, so it is something new and completely different from what we did for MX3. Maybe there would be some good ideas in it for your .net project. Joe
    1 point
  39. Out of curiosity I decided to see how quickly I could write a macro to calculate elapsed time. Here is my sample macro: // Get Starting time Date/Time: Set %StartTime% to the current date/time Variable Set Integer %RandomDelayTime% to a random value between 0 and 15 Delay: %RandomDelayTime% seconds // Get Ending time Date/Time: Set %EndTime% to the current date/time // Calculate elapsed time Variable Modify Date/Time: %ElapsedTime% = %StartTime% - %EndTime% Variable Modify Date/Time: %decElapsedTime% = %EndTime% - %StartTime% Variable Modify Decimal: %ElapsedSeconds% = %decElapsedTi
    1 point
  40. In Variables, choose Variable Set String. Then set the variable to use and "Set Value to File Name (Prompt)" This will open a file selection box.
    1 point
  41. Alien - Not that it helps you any, but these are the problems that were fixed with Mouse Locator in the previous build 4.5.0.1 (Dec 2013): 9. The Mouse Locator now displays the pixel color in separate values for Red, Green and Blue. 10. The Mouse Locator now displays the hexadecimal value of the pixel color in BGR format instead of RGB to match what is normally used by programs that accept hexadecimal values for colors. 11. Pressing Ctrl-C in the Mouse Locator now copies the Screen Position and color values to the clipboard. 12. Made a change to the Mouse Locator to eliminate a proble
    1 point
  42. Click the "A" icon to modify the Accelerator...
    1 point
  43. Hi All, Can any one suggest on how to export the Macro POP UP along with inside MEX files to another user Machine. I have created the Categories ( like department wise ) and under that created Macros and Macro Pop up for each category. In my system Icon tray macro pop up displaying the macro files which are lying under that macro pop up. So, now i want to export the same Macro pop up along with macro files to another machine on single click( or export). In another User machine also if I import the (Exported) .MEX file or Playable file that should import all the .mex files along with Macro PO
    1 point
  44. You don't know how to edit a text file? Well OK.... I'll do it for you. See attached. WCFG file edited by Cory.zip
    1 point
  45. For the rest of this conversation let's assume you have the full version of MEP installed on the destination machine. There is no other way. If you have any more questions you can respond by number in my list below. To load a macro file (MEX) simply double click on it. MEX are like Word documents or any other kind of data file. Once installed an association is made to the MEX and MXE extensions. To be clear the user need not have Macro Explorer installed. I envision you email the user the macro, have them save it to their desktop, and double click it. Nothing will appear to happen but it w
    1 point
  46. If you install Macro Express without the Editor the only way "a tech savvy user can work around" it would be to reinstall Macro Express with the Editor. To "lock down a full installation" you would assign a password to a macro file that prevents a user editing any of the macros in that macro file. (Look in the help and search for 'password' for more information.) All the macros are stored in a file. The default macro file is saved in the user's My Documents folder. To replace this file simply copy your version of macex.mex over the existing macex.mex. (Macro files can have any nam
    1 point
  47. I don't have a lot of time but I don't see a sort and like Samrae asked this is important. If not sorted I would first sort. Then I would make everything arrays and not use ASCII File process except to load the arrays. I think I posted here once my sort routine. Then I would keep track of the indexes of your high and low marks. EG if you know you're already in the C's no need searching A's and B's. And of course when you find one of course do not continue searching. Another thing you can do with sorted arrays is a binary search. It sounds like a techy word but it's not. You have probably d
    1 point
  48. I can't tell you how many of my clunky short term solutions have never been fixed :-)
    1 point
  49. Look at the "Calc ulator and Note pad" macro in samples.mex. This sample macro file may be found in the folder where Macro Express is installed. Or you can download it here: Sample Macro Collection
    1 point
  50. Windows allows windows to be hidden or visible. (Check out the Window Hide and Window Show macro commands.) Some applications do not remove windows but hide them. Other times there are both hidden and visible copies of a specific window. Since Macro Express gets the list of windows from Windows itself it can seem to be confused. You might be able to do something with the Repeat with Windows command. That command can return only visible windows. Maybe something like this: Variable Set String %T2% "" Repeat with Windows: Place title in %T1% If Variable %T1% contains "Information" Bre
    1 point
×
×
  • Create New...