cmoir

Thank you VERY much Zedna!! I have tested too and this works a treat I was beginning to lose hope and thought I would have to enter all these entries manually (over 1000 of them!) I can't thank you enough for the amount of time you have saved me

Hi John, Many thanks for your reply and help!! The script you have modified is unfortunately only giving me the IP/Connection Name depending which is first in the spreadsheet. Is there any way for the script (below) to do the following: Open New Connection, Copy Cell A1, Paste into Radmin THEN Alt-Tab, Copy Cell B1, then paste into Radmin, then save connection. Then repeat for A2/B2 so on and so forth. The script currently does up until the Alt-Tab stage. ; get file name $saFile = FileOpenDialog("Select file with computer names", @WorkingDir & "\", "All (*.*)", 1) If @error Then MsgBox(0, "Error", "No file selected") Exit EndIf ; open file with list of computer names $oFile = FileOpen($saFile, 0) ; Check if file opened for reading OK If $oFile = -1 Then MsgBox(0, "Error", "Unable to open specified file") Exit EndIf ; Read in lines of text until the EOF is reached While 1 $saLine = FileReadLine($oFile) If @error = -1 Then ExitLoop EndIf ; Activate Radmin Viewer window WinActivate("Radmin Viewer") ; send 'Insert' key ( 'Add new connection' ) to Radmin Viewer Send("{INSERT}") ; Split string $aID_IP = StringSplit($saLine, ",", 2) If Not IsArray($aID_IP) Then MsgBox(0, "Error", "Splitting line") Exit EndIf ; wait for the 'New Connection' window WinWait("New Connection"); ; add computer name ControlSetText("New Connection", "", "Edit2", $aID_IP[0]) ; add computer IP address ControlSetText("New Connection", "", "whatever the control is.", $aID_IP[1]) ; send 'Enter' key to add computer Send("{ENTER}") WEnd ; close file FileClose($oFile) Any help appreciated Thanks!!

Hi All, I am looking for some advice regarding an AutoIt script I have downloaded. In work we use a piece of software called Radmin to remotely connect to our site-PC's at various locations around the UK. I am trying to import a list of IP's into this software and the providers have advised using an AutoIt script as per link's below http://support.radmin.com/index.php?/Knowledgebase/Article/View/47/35/How-to-automatically-add-PCs-to-Radmin-Viewer-Phonebook- http://www.radmin.com/support/forum/index.php?PAGE_NAME=read&FID=30&TID=15954&TITLE_SEO=15954 The script that has been provided is below ; get file name $saFile = FileOpenDialog( "Select file with computer names", @WorkingDir & "\", "All (*.*)", 1 ) If @error Then MsgBox( 0, "Error","No file selected" ) Exit EndIf ; open file with list of computer names $oFile = FileOpen( $saFile, 0 ) ; Check if file opened for reading OK If $oFile = -1 Then MsgBox( 0, "Error", "Unable to open specified file" ) Exit EndIf ; Read in lines of text until the EOF is reached While 1 $saLine = FileReadLine( $oFile ) If @error = -1 Then ExitLoop EndIf ; Activate Radmin Viewer window WinActivate( "Radmin Viewer" ) ; send 'Insert' key ( 'Add new connection' ) to Radmin Viewer Send( "{INSERT}" ) ; wait for the 'New Connection' window WinWait( "New Connection" ); ; add computer name / IP address ControlSetText( "New Connection", "", "Edit2", $saLine ) ; send 'Enter' key to add computer Send( "{ENTER}" ) Wend ; close file FileClose( $ofile ) What I am trying to do is get the IP address under "IP", and the Connection Name under "Connection Name" however with this script when i try to import from Excel it just puts the text inside the IP text box as "NAME,IP" (e.g. connection1,10.1.1.1). As you can see from the links above the providers have said "just edit it" however I have zero scripting experience and wouldnt know what to change! (I have tried fiddling about with it however been unsuccessful). The excel file i have is not complicated, it is a list of connection names and IP's as per the below. Any help at all with this would be much appreciated!!! Thanks!