Cory

"The ASCII File Process is a powerful command that extracts data from text files, one line at a time. The values of each record are saved to variables for later use, such as inserting the extracted values into other applications. This is an efficient method for transferring data from one file to another." - Help Might be a problem with your data file. Post a sample and I'll check it for you quick.

Every iteration of the command reads in another line of data. All the elements in that line are put into an array variable you will use to do your iterative process.

ASCII File Process is a loop.

Use ASCII File Process for the loop.

Same problem for text color.

My mistake. I left the slider all the way up. Annoying, it defaults to the top. Maybe somehting related to it not remembering the custom color. If I close the dialog and go right back in, the custom colors persist. Saving doesn't make them vanish. Only when I close the scripting editor does it vanish. I think you should report this as a bug.

Thanks for reminding me of this feature, It can be handy. I think I see what you mean. I defined a custom color and added it yo custom colors and it appeared below the basic colors. I closed out of everything saving the macro and restarted MEP. Now the custom color is missing. Another thing seems wrong. Now when I pick from the palette, the values change at the right but the "Color|Solid" box always appears white.

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.

In what?

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 hour is 12, then 12/24 = .5. You can build a decimal this way then create the DateTime variable by converting from decimal.

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.

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.

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.

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.

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.

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.

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.

Good luck.

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.

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.

What are you hoping to accomplish?

No.

"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 of troubleshooting: K.I.S.S. 🙂

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.

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 having a path suffest HTTP or other protocol that uses a path to resources.