FTP sites Status Checking
 

Hi Friends,

I have one problem. I have more than 1000 ftp sites stored in the excel file. Now I want to check which one is active or inactive.
It is very difficult to check one by one. Because is nearly more than 1000 sites. all are stored in one excel file.
So can any one please help me on this above scenario or any scripts for this ftp sites.

Thanks in Advance.

You could write a VBA script that tries to connect to mostly all of the 1000 sites. This way you would not have check them manualy from the excel file

Hi

Thanks for the reply.

Can you give me the VBA script so that I will try.. Because I not familiar in programming.

Thanks

First, this is LINUXquestions....VBA is for Windows. Secondly, we are NOT going to write your scripts/programs for you...read the "Question Guidelines" link in my posting signature. We will HELP you, when you post what you have done/tried/written on your own, but will NOT do your work for you. Since you have "RHCA" in your user name, that means you should know how to write a script...since that was part of the 'certification' you have.

Exporting the Excel file to a CSV file is trivial...reading that CSV file and looping through it should also be fairly easy for someone with a 'certification' as well...especially given the thousands of samples scripts you could find already to help get you going.

would pinging the address be sufficient?