Jump to content
Macro Express Forums


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Cory

  1. I don't have much time here but I would like to mention an alternative. After thousands of hours of trying to find boxes and do anything in a web browser with MEP and a mouse, I gave up and learned to do everything by keyboard, mostly using the tab key. Hit the home button and count the number of tabs to the control you want.
  2. There's no magic way to cast a date string to Date/Time. First I'd like to let you know dates are at the core level decimals. 1 = 1 day starting 1/1/1900. But you can also build a date using the method I Described above. Add years, months, days and so forth. Or you can create the values then cast them. First you should parse the string, I'm guessing using the spaces. Remove the commas. A 'Select Case' for the months. January = 1 month. Look at the Split command. That's how I'd start it. However you could also do the math. That so many hours and minutes are fractions of a day. So if the
  3. Check the Help file. Variable Modify Date/Time. In the lower right you can choose to add an amount. So you can add 8 and select the Hour option in the dropdown. If you need to subtract, add a negative. Are you're sure you're UTC +8? If you're like me on the west cost of the USA, it's UTC -8 for PST.
  4. A good idea. You can also use the special "view-source" protocol in the URI. EG: https://en.wikipedia.org/wiki/Mayday is view-source:https://en.wikipedia.org/wiki/Mayday. I don't know if all browsers support it, but I know Chrome, Edge, and FireFox do.
  5. You shoudl be able to enter your registration information during install just like the first time. If you have a problem contact ISS support and they will help you quickly.
  6. Oh! also you can link actively to a web page in Excel. If you're planning on going to Excel with this data, this is the better option. Go to the Data section of the ribbon bar, then "from web" and follow the wizard.
  7. Another thing: HTML is more complicated, but sometimes there are labels for elements that make it super simple to find what you want. Also if the web page is secure, you might not be able to do it with the GET method.
  8. You can copy the text to your clipboard and process it. Normally a table will come in with tabs between cells that you can parse. Though my prefered way it so use the GET command and process the data out of the HTML.
  9. Many email applications support rules. Gmail even. I use Outlook. I would recommend a user exhaust every opportunity to use the program's capabilities before writing a macro. Since I use an application with this capability, I've never had to write a macro like this so I'll not be participating in your challenge. Just tossing this information out there because many don't realize they already have a way to do this natively.
  10. No need for a macro. Windows Start > Command Prompt. MS Ping reference. You probably want to use \t is memory serves to make the pinging perpetual.
  11. I wouldn't bother creating a macro for which many programs already exist. You could use a monitoring program for instance. I use Net Uptime Monitor. Quire useful. You can also use Windows command program Ping. You can set the number of pings to infinite and control the time between pings. Say have it try every 10 seconds.
  12. "The ping command ignores protocols such as HTTP, HTTPS, FTP, or SMTP" Not exactly. As I stated clearly in a precious message, it it it's own protocol along side these. You can take a train, plane, or an automobile. They don't ignore the others, they're completely different methods of travel and have nothing to do with each other. So too are the protocols in TCP/IP. Thanks for explaining the mistake in the help. Now it makes much more sense. I suggest that you suggest using an IP address to avoid failures associated with DNS lookups. One of the most useful principles o
  13. Windows API and such: Correct. But the purpose of the timeout in the Windows Ping command is for network delays. A ping packet is sent and tries to route itself as any packet. It does a cost analysis and makes the best decision on the route. A ping is sent to one router to the next and to the next. TraceRoute shows this better. At each router the transmitting router waits a given period of time before giving up and sending the result of failure back. The user can specify how long to wait on each hop. This is the Ping timeout parameter.
  14. If you disable your network then there is no path an an ICMP ping will complete quickly and tell you there's no route. Kevin: Please explain how ICMP Ping can access a resource only accessible with HTTP. In the Help for MEP is clearly shows an example of a URI pointing to "support.htm". Also it says to omit the scheme. HTTP requires a scheme to access a resource. It needs to know if it's HTTP, HTTPS, FTP, SMTP, or whatever protocol to use. It seems contradictory to omit she scheme suggests ICMP ping as it is a protocol (IMCP is a protocol like HTTP) and doesn't use it, but ha
  15. Also I tried a URL without the https:// that I know takes a long time. It just happens to be a thorn in my side for some software I'm developing right now. Their response times are typically around 30 seconds as their back end servers are slow as molasses in a Montana winter. I tried with a 5 second parameter in the Ping Site command and it returned as failed immediately. I also increased the parameter to 5000 in case there was a mistake in units, milliseconds instead of seconds, but it came back immediately also. Once we know the mechanism being used we can judge if it's be
  16. In my test in the last paragraph I forgot to mention I disabled my network.
  17. I have some ideas, but I think I need some explanation from ISS. ISS: Is Ping using ICMP or and HTTP request? I don't think this is a "ping", I think it's a HTTP HEAD Request. Ping uses ICMP packets and is below the HTTP protocol. If memory serves, it's a part of the Internet Protocol. You might have seen the initialism TCP/IP before. I think it's part of the "IP" suite. But ISS shoudl be able to tell us. You see a ping only accepts a domain or subdomain as a parameter, one can't ping to a resource. That is, no path or resource name like "support.html" and this is what they sh
  18. I think it can be done in the registry also. Probably would need to logout and back in though. Better yet the Taskbar section in Settings and change it there. The "Taskbar location on screen" is a drop-down where you can choose bottom, top, left, or right.
  19. The only way I can of with MEP would be to do so with the mouse drag and drop. It would have to be unlocked first.
  20. I never muck about in the GUI of the Save-As dialog. I use MEP's commands. In this case I'd take the path from the nav bar at top using control commands and then create the folder in MEP. Then, alternatively, navigate to that folder.
  21. I don't have time to do a proper review of your samples, sorry, but did you try changing the shortkey sequence on the one that doesn't work to somehting simple as a test?
  • Create New...