Jump to content
Macro Express Forums

All Activity

This stream auto-updates     

  1. Earlier
  2. terrypin

    Forum bug

    Thanks Paul. Can’t say I’m comfortable using WF but it was the the best of several alternatives, given two factors: a smooth transition and retention of some essential add-ons. And I note that article says ESR security support lasts until July 2018.
  3. paul

    Forum bug

    Just FYI! https://www.howtogeek.com/335712/update-why-you-shouldnt-use-waterfox-pale-moon-or-basilisk/
  4. Or, if you are just looking for number of RECORDS (as you say in the title of your posting) -- use Text File Begin Process, which transfers the records one at a time into a variable, and you can add to a counter each time through.
  5. The easiest way I found was: Create the special character Carriage Return or Line feed. (Newline) Copy the text of the first variable to a second variable. Remove all instance of the CR or LF from the second string variable. Subtract the number of characters of the second string variable from the original variable. The difference is the number of newlines. Add 1 to that value. You may want to trim the original text first to ensure there is not a trailing newline set.
  6. How to find out with MacroExpress Pro how many lines are there in text document? What is the command... I searched the help file, couldn't find it...
  7. terrypin

    Click on webpage "Next Page" button

    As @acantor implied, the devil is in the details. Getting the mouse or text cursor to the right position before selecting the required ‘total content’ is the challenge. To take an example: doing so in my Firefoxor or Waterfox browser depends on how many tabs are open. If they occupy more than one row, then appropriate adjustment has to be made. IOW a sub-macro has to be run first. Gets complicated quite soon. And that’s assuming the structure of the page remains permanently unchanged. A screenshot or link to the page is needed. Terry, UK
  8. terrypin

    macro with a list

    Pleased to hear you sorted it. And saved me some time this morning! Thanks for reporting back, disappointingly rare here. Terry, UK
  9. Ry_

    macro with a list

    I think I figured it out. nIndex was defined as an integer array and not a single value integer. Once I changed that it works great! Fantastic macro by the way, thanks for sharing!
  10. terrypin

    macro with a list

    Hi, Long while since I worked on that macro! I’ll try to take a look but to ensure there’s no ambiguity could you first upload your macro please.
  11. Ry_

    macro with a list

    Hello Terry, To pickup where Mark left off. Yes, the nIndex does exist in the Variables tab as an integer variable, but the macro is still throwing the same error: Undefined variable or the variable is the wrong type "%nindex%" Macro Name: MedicalList-James Line Number: 4
  12. jmazor

    Click on webpage "Next Page" button

    I am sorry.....I thought this response had gone out: When i move the pointer to the NEXT thing, the pointer becomes a hand. Also, this is visible in a window: <button class="next" data-ember-action="" data-ember-action-6272="6272"> <div class="next-text"> Next </div> <span class="svg-icon-wrap"><span class="visually-hidden">Next</span><li-icon aria-hidden="true" type="chevron-right-icon" size="small"><svg viewBox="0 0 24 24" width="24px" height="24px" x="0" y="0" preserveAspectRatio="xMinYMin meet" class="artdeco-icon" focusable="false"><path d="M9,8L5,2.07,6.54,1l4.2,6.15a1.5,1.5,0,0,1,0,1.69L6.54,15,5,13.93Z" class="small-icon" style="fill-opacity: 1"></path></svg></li-icon></span> </button>
  13. acantor

    Click on webpage "Next Page" button

    Depending on the webpage, this series of steps could be very simple to automate via Macro Express, or extremely complex. There are likely several ways to accomplish the task. But the method, or methods, will depend a lot on the coding of the webpage, and on the browser you are using. One quick question. What type of element is "Next >>>"? Is it a hypertext link, an image, a push button?
  14. 'all I want to do is : a. hit a hotkey & allow the macro to locate the cursor to top left of webpage; b. Press ^A to select all contents and then ^c to copy the page to clipboard; c. Then, click on the little "NEXT===>" near page bottom to go to the next webpage; I can't remember how!!!!!!!!!! Can someone tell me? Thanks, Jeff
  15. Bruce Thomson

    Find soemthing in a document and copy it out

    Paste the names into Excel. Then use the 'Capture' feature of MacroExpress to demonstrate to Excel how to do one of the names and step to the start of the next name. Then use the 'Edit macro' to insert features of the 'Repeat' menu such as 'Repeat start' 'Repeat Counter' and 'Repeat Until'
  16. 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> // Select the 2nd word Type "<CONTROL>c" // Copy to the clipboard In many text editors, pressing F3 repeats the previous search. In Microsoft Word, the hotkey is Shift + F5. Knowing these factoids might help simplify the project.
  17. Probably can be done with command Text File Begin Process, which loops for the entire file and passes one line at a time to a text variable. Read about it in the Help section. If you need to copy the whole line starting with @, it's easy. If you need to copy less than the whole line, the hard part may be where to leave off -- that is, what delineates the end of the name to be copied? Show us a couple dozen representative lines; change the names to protect the innocent, if necessary. If your files are not text files, then ????
  18. I have a windows VPS running ME3 - I have a macro designed to run once per day. At the moment it's not working.. If I trigger the macro and watch it it works, but if I close my connection to the VPS it doesn't work. Even though the VPS is still working/running. When i launch the remote connection to it again I can see Macro express still sitting there exactly how I left it. I even tested this with a repeat and delay. I set up a repeat and a 200 second delay - I ran the 1st time i triggered it as I was watching it.. but when I closed the connection and waited for the results nothing happened .. I opened remote connect to VPS again and the same thing.. The macro said it was still running ( black man icon in tray ) .. but didn't trigger and didn't work. I can check the if the macro worked by checking a shared Google Sheets page - if it worked there will be some data visible. So i don't have to launch the remote desktop to see if it works. So is there a reason why it's not working on VPS ?
  19. I've many large files over 20000 lines each In each file there is about 5000 names i need to copy out - names could be different lengths etc. All the names start with @ So I could tell ME3 to look for that - but I don't know how to tell it to only copy the name and then repeat.
  20. jp.bergeron

    Click ok

    I'll try this path tonight thanks
  21. Cory

    Click ok

    You would do better to make forum posts for each subject. Searching graphically can be done but it's code intensive. One must iterate though each pixel and observe colors and make decisions. It is cumbersome and problematic. MEP can easily click on OK buttons. Please review the help file section on Windows Controls. You will define a path to the control, get the control address at run time, and you can click on the control. You can even make the appearance of a control as an activation for the macro. There is an example macro demonstrating controls either in your installation folder or on ISS's website. I forget which. It uses Windows Calculator. Play with that to learn how to get a control's address and click on it.
  22. jp.bergeron

    Click ok

    Got the software yesterday. All I want is a macro that would search for ok buttons and click on them to close the message boxes. By the way, cant MEP search based on a graphic pattern? Thanks
  23. We are working on a new major release of Macro Express named Macro Express 5 and are looking for testers. If you are willing and interested in trying Macro Express 5 please contact us. NOTE: This should not be confused with the future update of Macro Express Pro which will be named Macro Express 6.
  24. Thank you! The Heximadecimal option worked! (Although using it in this particular application has an odd side-effect that it also triggers one of the drop-down menus, but if I add an ESC key right after the heximadecimal character in the macro the menu disappears again pretty quickly. Klugey, but I can live with that for the moment and hope to figure a better way to deal with it once I've played with it.)
  25. The Alt-Key Sequence feature of the Text Type command allows Unicode characters to be typed. The Type Special Characters macro in the samples.mex macro file contains a sample macro.
  26. Bear in mind data is a series of bytes and it's up to the program to decode it. There are different flavors of Unicode but Word is likely the UTF16 and is 16 bytes where ASCII/ANSI is 8. So it will chunk though it and break each in half and you will have seemingly random characters. But much of Unicode will have the same first 8 bytes for the same letter, say "A". So one can chunk though it by deleting every other character. And some, like UTF8 are only 8 wide for basic characters but 16 for extended. So in those cases much of it will still be legible when using the ASCII code page.
  1. Load more activity
×