charlesa920
12-20-2007, 03:16 PM
I marked earlier thread "Solved" but it ain't.
I have an application that PINGS IP addresses. I can supply these by range or have it point to an external file.
My file with the IP addresses is Radio_SpreadSheet.xls
which contains a sheet "all IPs". column A in this sheet has a list of 500 IPs of which 250 are assigned.
So when I run the PINGscanner it tries to ping all of the IPs and I only need it to ping the ones currently assigned. Successful pings are green, time_outs are red... with all the IPs being pinged the results are meaningless. I need to be able to quickly identify any IPs that are off the network. Somehow it needs to skip unassigned IPs.
When an IP gets assigned the user name goes into column B. I tried for a solution by adding another sheet in the Radio_SpreadSheet.xls named "IP". Here is the formula I used in IP column A
=IF('[Radio_SpreadSheet.xls]all IPs'!B1<>"",'[Radio_SpreadSheet.xls]all IPs'!A1,"")
OK so far as the sheet IP only shows IPs that are assigned....but when I run my PINGscanner it defaults to scan the "all IPs" sheet. So I created another workbook "activeIPs.xls" with a sheet "activeIPs" which includes the same formula as above.
So I tell PINGscanner to scan based upon this "activeIPs.xls" and it appears to work...until:
1) I handout a new IP and
2)the workbook "activeIPs.xls" which has not been updated to reflect the newly assigned IPs
Do I need a bit of code that everytime I save "Radio_SpreadSheet.xls" it will also update the linked values in "activeIPs.xls"?
Perhaps I am going about this all wrong, I just don't know?
Any suggestion, solutions, even finger pointing will be appreciated!
Charles
I have an application that PINGS IP addresses. I can supply these by range or have it point to an external file.
My file with the IP addresses is Radio_SpreadSheet.xls
which contains a sheet "all IPs". column A in this sheet has a list of 500 IPs of which 250 are assigned.
So when I run the PINGscanner it tries to ping all of the IPs and I only need it to ping the ones currently assigned. Successful pings are green, time_outs are red... with all the IPs being pinged the results are meaningless. I need to be able to quickly identify any IPs that are off the network. Somehow it needs to skip unassigned IPs.
When an IP gets assigned the user name goes into column B. I tried for a solution by adding another sheet in the Radio_SpreadSheet.xls named "IP". Here is the formula I used in IP column A
=IF('[Radio_SpreadSheet.xls]all IPs'!B1<>"",'[Radio_SpreadSheet.xls]all IPs'!A1,"")
OK so far as the sheet IP only shows IPs that are assigned....but when I run my PINGscanner it defaults to scan the "all IPs" sheet. So I created another workbook "activeIPs.xls" with a sheet "activeIPs" which includes the same formula as above.
So I tell PINGscanner to scan based upon this "activeIPs.xls" and it appears to work...until:
1) I handout a new IP and
2)the workbook "activeIPs.xls" which has not been updated to reflect the newly assigned IPs
Do I need a bit of code that everytime I save "Radio_SpreadSheet.xls" it will also update the linked values in "activeIPs.xls"?
Perhaps I am going about this all wrong, I just don't know?
Any suggestion, solutions, even finger pointing will be appreciated!
Charles