Buzz Posted March 23, 2008 Report Share Posted March 23, 2008 Brand new to ME here, hoping to find out if this is even possible to automate with ME... I have an Excel list of 200+ IP Addresses, that I have to manually ping and note the results "Failed or Successful". Can this be done ? Quote Link to comment Share on other sites More sharing options...
johnboy691 Posted March 24, 2008 Report Share Posted March 24, 2008 Did you go to Macro Express help and type PING in the search. There seems to be a good tutorial/directions on how to get ME to do a ping and return results. You may have to manipulate it a little, but by using If statements and variables I would think you should be able to get the results you want. I have never used this tool, but it seems pretty easy to get the results you are looking for. Good Luck! Quote Link to comment Share on other sites More sharing options...
stan Posted March 24, 2008 Report Share Posted March 24, 2008 The other part to this is to save the Excel file to a .csv file. Use the ASCII Begin File Process command to read each line of the file - each IP address. It will read the first address and save it to a variable such as T1. Enter %T1% as the address to Ping in the Ping Site command and save the results to variable T2. Do your IF statements to find the results and post to another file. Close the loop with an ASCII File End Process command. The loop then starts over again with line two, or your second IP address and does the comparison, etc. It will do this for all 200 addresses in the file. Look at the ASCII Begin File Process topic in the help as well. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.