Jump to content
Macro Express Forums


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Cory

  1. Saving to Excel in background

    I don't have an answer. I started using simple .NET application using Interop for this a long time ago and have never looked back. So simple and efficient. If you would like me to make you a simple application like this and show you how it works, I can. But one thing I was thinking about but have never tried is simply linking to a CSV in Excel? Excel is great at linking to databases and all sorts of data sources. They simply refresh their data on command or on schedule. It might not work for what you need however.
  2. Editing the contents of a string

    Well it doesn't appear that anyone is interested anyway. It's discouraging. I thought for sure UAMike would have loved this and yet I got absolutely no response. Pfft. That's what I get for doing something nice. There's nothing wrong with it. It's working perfectly. When I run the macro I get this. I edit it to add some text like this. Then I click the 'clip and close' button and I get this. I've tried it multiple times and it always works. It's too simple not to. Maybe you can show me what you mean with some screenshots.
  3. Wait till website is fully loaded

    Read some of the posts here. This is a common problem. Web pages are more complex than you realize. "Loading" usually entails several events. When the HTTP Request is received the web browser renders the page. Then it is done and loaded and MEP stops waiting. But most pages these days contain many scripts that go and download more content and do more things after the initial load. There's no way for MEP to predict what the active content will do. Many people have created ways of detecting the completion of all the scripts and there are many examples here in the forum. Please take a look at them and see if any will work for you. BTW waiting a prescribed period of time doesn't always work either.
  4. MEX PRO and Win 10 Pro Problems

    There must be something wrong in line 3 then. Maybe something environmental in that line. can you share that line so we can examine it?
  5. Help Me: Macro command in doc

    I'm struggling to understand the question from the OP.
  6. Different screen resolutions

    You say it doesn't work. Can you explain how it doesn't work?
  7. Editing the contents of a string

    Here's a little present for you. It's a simple WinForm that is designed to be a multi-line editor that works with MEP. When you launch the program you can start typing straight away. Then when you're done, click Clip & Close button or, if your'e keyboard-centric like me, tab t hen enter. MEP can be set to wait for the program to close and grab the clipboard contents. There's a demo macro too. Just change the first line to be the path of the executable on your system. I.E. wherever you saved it. I was too lazy to get the relative path in the macro. I had a subroutine for that once, but I've lost it. TextBoxEditor.zip
  8. Editing the contents of a string

    I've used Variable Set String like this in the past but this is too much. I think Notepad is your best bet. I wouldn't paste however. I'd use Windows Controls commands.
  9. These are the things that drove me bonkers. I decided to write simple programs that send HTTP requests and receive HTTP Responses. IE no web browser. Most forms use the POST method for forms so all I do is copy the POST data and modify it myself. In most browsers hit F12 and you can see the requests and responses. Right after you click you will likely see a POST request. Look at the POST (form) data. Usually it's something like this: "name=Fed&email=Fred@SlateRockAndGravel.com&message=Yabba%20Dabba%20Dooo". This returns the source HTML of the resulting web page. And super fast. Typically 3 per second. Then I get what i need from there. One can navigate many pages and never actually render a page in a browser. If anyone is interested i could create a helper app for MEP to do this method. Or if they would like to learn to do it my way.
  10. Retrieve Sheetname from Excel

    I haven't read all this in detail but I had a passing thought. Is it possible that MS uses different letters because the words are different in German? Like f they wanted "p" to print in German that might be nonsense because the German word for print it "drucken" (according to Google translate). So to be intuitive it would want to be "D" in the German version.
  11. Retrieve Sheetname from Excel

    Yes. It's the "Home" tab. https://goo.gl/hK3g7g It exposes all the shortcuts for the items in the ribbon. https://goo.gl/NebpGV
  12. Type text misses words

    Two things. First, slow down your Keystroke speed. Second, and maybe not necessary, you might add a delay in between each field. IE make it several commands with a delay between. Some web forms do things programmatically in their scripts when you type something in a field and leave it. Like validation. It takes time and the form might not be ready for more input. On second thought, I would try to add the delays between fields first.
  13. Retrieve Sheetname from Excel

    If you put =Sheet() in an empty cell it would give you the sheet number. You could write a VBA macro to pop up a dialog box with the sheet name. Trigger it with a hotkey in Excel.
  14. Shortcuts extremely slow

    Is the Ctrl+k being 'typed' from a macro? Or are you saying that you're experiencing this when you manually type Ctrl+k?
  15. Shortcuts extremely slow

    To be clear, if you terminate MEP, the keyboard shortcuts in Outlook are responsive again?
  16. Hi Jeff! I can't think of any way to circumvent the password. ISS might be able to help you with that. Off the top of my head all I can think of is to create a new file. Then import all the macros except the PGM macros from the old file.
  17. I requested a feature to find and replace in multiple macros.
  18. That's a hard one. I think Terry has more experience with this. One thing that I suggest is that you never use Magic Numbers. That is to say, things like this shouldn't be hard coded. You should keep them as a setting in an INI file or something. I prefer to use the Windows Registry. I'm sure by now you can see the reason why.
  19. It does see that way. Timing for web pages is often a difficult thing in MEP. Search here if you have troubles, there are a lot of posts explaining techniques we use.
  20. Sub with parameters

    Not exactly. What I do is to create macros as subroutines but you can't pass parameters like a normal program. So I use variables that are scoped properly. If you notice when you define a variable there's an option for it to be available to sub-macros. I found scope in MEP to be confusing so I wrote this page to explain it. You can also use some other mechanism like the registry.
  21. You might need to add a delay. Often the web page technically loads but then there are additional scripts that execute after this. Timing of web pages is one of the greatest challenges in MEP.
  22. Macro Express Pro v

    Awesome! Thanks for all your hard work.
  23. Waiting for Key Press - more choices

    You might consider making a feature request on their website. I've been thinking of creating a generic .NET webform that a macro could define. Mainly people want to have multiple text fields. In my vision there my program would take text file as a command line parameter. Each line of the text file would create the form controls in a simplified way. EG text boxes, buttons, radio buttons, check boxes. Look in my posts for my offer. I could see creating a 'wait for key press' control. However no one seems interested in it so I can't justify spending the time to make what could be a very useful add-in. I would also like to make add-ins for RegEx, Web tasks and other functions MEP doesn't have.
  24. Integer seconds to yyyymmdd-hhmmss ?

    I'm very behind with work and don't have time. Can you make a simple macro that demonstrates the problem. Also instead of using a dialog box to prompt the user, can you just set a text variable? I'm thinking it should be a 2 line macro.
  25. Cannot run any PGM macros

    I meant to suggest you turn off ANTI-malware or ANTI-virus, not that you have malware. For instance I know McAfee makes it impossible to install Carbonite or any of it's updates. It blocks many changes the installer tries ot make. So I disable it, run the install, then re-enable.