troubleshooting Question

I need a vb script that replaces text in an excel file

Avatar of jkemp761
jkemp761 asked on
Microsoft ExcelVB Script
3 Comments1 Solution358 ViewsLast Modified:
I wrote a script that pings a large list of IP addresses in my internal network and creates and excel spreadsheet that puts the results in seperate columns:

IP Address     Computer Name     Status
------------------------------------------------------
10.0.1.1          someserver-big      Pings Successfull  

This works perfectly.  But I am trying to figure out how to search this excel file from a new script and filter the computer name results so that if a servername contains "-big" in its name (example: someserver-big or big-server) I can blank the Cell or replace the Cell text with whatever I want.  I have googled around but cant find any good examples.  Anyone have an idea or example?

Note:  I am limited to the tools I can use so Unfortunately VBS is what I have to work with and since this needs to be automated I cant manually run a macro in excel.

Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros