Jump to content
Macro Express Forums

Cory

Members
  • Posts

    4,190
  • Joined

  • Last visited

  • Days Won

    59

Everything posted by Cory

  1. Yes. However I recommend using a tab delimiter instead. This avoids needing to qualify text with quote marks. BTW this is native for the tabular exchange of Microsoft products. So you can build the big string of tabular data with tabs, carriage returns, and line feeds and either save it to a TSV or paste it into Excel where the entire table will be inserted in one action. I've written some one this in these articles. Process Tabular Data in Variables CRLF and TAB Macros If you have any other interests. If you do a lot of this sort of thing, you might want to go to the next level. I started with web automation with MEP but now due to the huge volume I do, I have .NET programs that do the work. But without having to learn a programming language there are ways to send information to a web form handler directly with a request. This requires no web browser so much simpler, faster, and more reliable. Also timing problems go away. Most web forms send their data in a HTTP POST request but some use GET. Natively MEP can only send a GET request but many form handlers will also accept the data in the parameters of a URI in a GET request. Also one can make a simple script one can use in a External Script command in MEP. If you have any interest in that, feel free to send me a PM or respond here. I'm also available for hire and am willing to teach or do. I give free consultations, often enough for one to get going on their own.
  2. It depends on what you're doing. Are you using a timing control? "Wait for"? In your code, what is waiting? Often for web pages I'd test for something in a loop with a small delay and once the condition is met, set a boolean variable for success, and advance. If it goes to the loop limit, it exits and sees the Boolean indicates a failure and handles that. Like a 1 second delay in a loop for 300 times. It would help if you gave us more details about what you're doing.
  3. That's a good point rberg. I was considering mentioning that. This is useful if the number of elements before the desired element varies.
  4. MEP isn't the greatest at web automation. I typically use other tools. But when I do, I avoid using the mouse. Generally I get to any page element by tabbing thought them. So count how many tabs to the button then text type the Enter button.
  5. I would create an Outlook rule to print the messages to file using the generic Microsoft ASCII text file printer. Then have a macro activation for folder contents changing that would extract the email address from the text file. This way it could all happen invisibly without the complications of the GUI.
  6. MEP is worth the investment. Just upgrade.
  7. You're posting in the wrong forum. YOu can do this still. DT is a decimal. You can subtract the integer 10 from it.
  8. Then the macro I provided does the date values in 2 commands. All that's needed is to combine the text to make the URI. Probably 3 more commands. Simple.
  9. This macro sets the variable to today, displays the value, adds 10 days, and displays that. Add 10 days.mex
  10. But why don't you just use the Variable Modify Date/Time command and add 10 days?
  11. I must be missing something. WHen did the OP say that where the dates were coming from? Until they respond, I don't see the point of spending time on it. Let's see what they indicate the source it. Then it should be a couple of date commands and whatever command to do something with theURI. That's the other thing. What do they want to do with the URI? If they're using HTTP GET command then one might not even need a string variable for the URI.
  12. I just showed you. You don't need ot express it as decimal. If you want the date 5 days ago, subtract 5 days. Maybe you can't see the screenshot I included?
  13. Of course you can add and subtract days. This complexity and using other apps is not necessary. Date/Time is at its core a decimal is one needs a more sophisticated operation. But just look at the Variable Modify Date/Time. You can add or subtract an integer value and select that to represent a second, day, month, year...
  14. I think it could be bulletproof. Just build the string. I'd show but the OP doesn't make any indication as to where the variable date values would come from. Offset from today? User input? A file? And the only string variables needed would be for the dates. The rest could exist in the command.
  15. Repeat Start command. Start on 100 or use a variable. Then set the increment to -1. Store the counter into a variable.
  16. So there's an error in the macro. So it's running, just aborting before any visible activity. Also I was wonder how you have the scope set. For instance sometimes people set it to the window title but if it's an exact match and something like the document tittle is in the title bar, it will not work. Is it working now?
  17. I am not having any good ideas pre-coffee-effect. Look in the Macro Explorer and see if the Last Run Time is changing. Make sure MEP is still running. You shoudl see it in the Windows System Notification Area. What happens if you run it from the Macro Explorer window or Macro Editor? I'll try to think of something else.
  18. Use the rules in Outlook. It's easy. You should see them in your Home ribbon.
×
×
  • Create New...