Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Reading data from a csv into a array
On Error Resume Next 'Object Variables SET objNet = CreateObject("WScript.NetWork") SET objfso = CreateObject("Scripting.FileSystemObject") SET objtextfile = objfso.OpenTextFile("C:\pmdata.csv") Set clrprinters = objNet.EnumPrinterConnections pcdomain = objNet.UserDomain pcname1 =... -
Reading data from a csv into a array
Think i've got it sussed now going to use ubound and add a seperate loop with a different split in it to add the printers should allow it go on add infintum in theory. Many thanks for all the help on this. I'll let you know how I get on. -
Reading data from a csv into a array
Printer# one is used later on to give the name of the printer thats needs to be mapped. see below: DO Until pcname1 = masPC OR objtextfile.atendofstream arrStr = split(objtextfile.ReadLine,",") masPC = arrstr(0) LOOP IF pcname1 = masPC THEN Printer1 = arrstr(1)... -
Reading data from a csv into a array
DO Until pcname1 = masPC OR objtextfile.atendofstream arrStr = split(objtextfile.ReadLine,",") masPC = arrstr(0) LOOP IF pcname1 = masPC THEN Printer1 = arrstr(1) Printer2 = arrstr(2) this method is working but i'm hoping to future proof the script so if the... -
Reading data from a csv into a array
Hi wonder if anyone can help me with this. I have a csv file which contains a list of prtinters and the corrosponding machine name. I have the script pull the text out into a string array (correct term?) and then have it assign the printers printer 1 = arrstr(1) printer 2 = arrstr(2) etc etc...
