searching through Microsoft excel...

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
Mark Gevry
Pro Scripter
Posts: 63
Joined: Sat Dec 25, 2004 3:23 pm

searching through Microsoft excel...

Post by Mark Gevry » Wed Jan 05, 2005 10:14 pm

Hi. My father wanted me to create a program for him. He has about 200 IP address and the computers info saved inside of a .XML file in MS excel.
He wants to be able to type in the ip address and it finds it withing the 200+ IP address inside the colums. Can you give me a few ideas on how to do this. Because you have to scroll down to see all the IP address obviously.

armsys
Automation Wizard
Posts: 1108
Joined: Wed Dec 04, 2002 10:28 am
Location: Hong Kong

Post by armsys » Thu Jan 06, 2005 12:06 am

Hi Mark,

Can you use Ctrl+F to locate the IP address in Excel?

Mark Gevry
Pro Scripter
Posts: 63
Joined: Sat Dec 25, 2004 3:23 pm

Post by Mark Gevry » Thu Jan 06, 2005 12:24 am

Wow thats an excelent idea! I never use excel so i had no idea. Thnx so much!

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts