script to launch a program from excel

[calvin]

i need to launch a telnet program from excel and get the result

i have a bunch of ip address that i used to telnet into and run a script
file, i want to link both files together

 

[Gary''s Student]

Just hyperlink to the program and click the link:

In some cell, enter something like:

=HYPERLINK("file:///C:\test\telnet.exe","Telnet") and click the link

Of course, you would modify this to refer to the proper folder on your
computer.

 

[calvin]

thats part of what i want the 2nd part is once i open the telnet program
(procomm plus) i need to tell it to run a particular script and copy the
result back to excel.i have over 600 ipaddress in the network and i am
looking to automate the process

 

[Gary''s Student]

I don't know enough about procomm to tell you the specifics, however the
general idea of using Excel to control and interact with another application
is illustrated in:

http://msdn.microsoft.com/en-us/library/aa266281.aspx

 

[calvin]

ok i will look into that thanks

I don't know enough about procomm to tell you the specifics, however the
general idea of using Excel to control and interact with another application
is illustrated in:

http://msdn.microsoft.com/en-us/library/aa266281.aspx