VB Script for Reading from CSV file

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ VBscripts
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - how to send email to extranet I can send email in intranet with CDO.Message,but I wonder how to send email to extranet ? Tag: VB Script for Reading from CSV file Tag: 216439
  - 2
    - How to display the status bar at the bottom of the HTA window? How to display the status bar at the bottom of the HTA window? Tag: VB Script for Reading from CSV file Tag: 216437
  - 3
    - MODAL MESSAGEBOX I'm trying to create a modal messagebox that will not allow users to move the focus away from the messagebox without first answering the question. I don't even want them to be able to click Start. Here is my code: ans = msgbox("My Message",vbYesNo + vbDefaultButton2 + vbQuestion + vbApplicationModal + vbSystemModal,"My Title") What am I missing here? Tag: VB Script for Reading from CSV file Tag: 216416
  - 4
    - stdout.writeline output issue Hello, I'm working on a program that needs to parse a text file, pulling out a field and it's corresponding value. The fields I need to search for are in a text file, one field per line. All of this is really simple and straightforward to me, but I cannot figure out why my output (to the console) is not what I expect. Below is the portion of my code that is of interest and below that is the output I'm getting. So that you do not have to guess at what I'm talking about. Let me point out the line: out.Write(trim(tmp) & "e") But the output that I get is: "e4" There should be an "A" where the "e" is and the "e" should be AFTER the "4". Thanks for the help! ********CODE*********** Set out = Wscript.StdOut ' Read in fields out.Write("Reading fields... ") set txt = fs.OpenTextFile(cfgFieldsFile,1) aryFields = trim(txt.ReadAll) txt.Close aryFields = split(aryFields,chr(10)) out.WriteLine((Ubound(aryFields)+1) & " fields found") If dbgShowFields Then For Each tmp in aryFields out.Write(trim(tmp) & "e") out.WriteBlankLines(1) Next End If aryFields = join(aryFields," ") out.writeline("start " & aryFields & " end") out.writeline(len(aryFields)) **********OUTPUT************** Reading fields... 30 fields found e4 eSTG3 eell eode e3d2fb e44d4 e5d45 esn e e2fb e3qp2 ebar ecell ecfb e3fb edg ehp ehpmr1 ehpr1 e2 e3f e5m edate ehpg1 ear0 efkrk etime egturn enf xnge Tag: VB Script for Reading from CSV file Tag: 216399
  - 5
    - Createfolder and removing readonly flag Hello. I created a folder on my local pc using CreateFolder method and I saw that the ReadOnly attribute is partialy set (it is not the check mark sign but the green filled square). I suspect this is the reason I can not copy files there using CopyFolder. Can someone give me please the code for creating a folder and coping another foder into it? Also, how can I remove this read only state. Thanks! Tag: VB Script for Reading from CSV file Tag: 216396
  - 6
    - Excel object in different subs Hi, Apologies if this is really basic! I am creating an Excel object in one sub as so:- sub form_load Set objExcel = CreateObject("Excel.application") <loads of other stuff. end sub Within that sub I can get Excel to do whatever I need..just great. But, my program contains about a dozen subs some of which also need to use the same instance of the Excel object as they will be used to read/ write/format the same sheet as the sub above. I keep getting errors when subs, other than the one that is creating objExcel, execute saying could not find or execute objExcel. How do I make objExcel available to all my other subs? Thanks, Stuart Tag: VB Script for Reading from CSV file Tag: 216388
  - 7
    - Input box set variable problem. Set oShell = CreateObject("Wscript.Shell") Set WSHShell = WScript.CreateObject("WScript.Shell") Message = "Set time till beep in miliseconds - 60000 miliseconds = 1 minute" result = InputBox(Message, "Beep", 100, 100) Script.wait = result Sub Beep (n, wait) For i = 1 To n oShell.Run "%comspec% /c echo " & Chr(7), 0, False Next End Sub .. Thats how far I got, don't really know where to go from here. How do I get the script to wait for the amount of set by the Input box. Help is greatly appreciated! Tag: VB Script for Reading from CSV file Tag: 216381
  - 8
    - Exit Do I've been instructed by a dot net / asp programmer that Exit Do is not a great way to end a loop. Can someone explain to me if this is so, or does this only apply to higher level programming languages ? I am using nested loops and need to exit out of one loop into another for something to apply. Any other functional ways of doing this ? Cheers, Tag: VB Script for Reading from CSV file Tag: 216357
  - 9
    - Folder and file management - help required - beginner This is a multi-part message in MIME format. ------=_NextPart_000_00E4_01C88C0F.C7DAC320 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I need to modify scripts under unix to adapt it to Windows XP. The first = idea was to use cygwin. It's woks correctly but for security reason it's = quite impossible to install a new tool. So the idea is to transfert all = the scripts under Windows Scripting (.vbs files).=20 We use four differents tools to design the application. Each tool = generates text file and other specific tools translates this files in C. = At the end, Visual studio 2003 compile it and make an executable file. My global process is : 1- Clearing the local environment 2- Transfering the up to date environment from an other disk 3- generating data, compiling, makefile and so on. I need help only for the 2 first steps. One of the constraint is using = the standard tools of Windows XP. *************************************************************************= ******************************************************** For the step one, how deleting folder, sub-folders and files included = (even if they are read only) to clear totally the environment on my = folder D:\Development The most faster is the best. I have done a script like Sub Recur(Byval FolderName) Set Folder =3D objFSO.GetFolder(FolderName) For Each SubFolder in Folder.SubFolders Recur subFolder.path Next ' Deleting files for ... next 'Deleting folder objFSO.DeleteFolder FolderName end sub objFSO.DeleteFolder does not work directly, I need to delete files = before. The solution works but it's slow and a bit "bourrin" (I am French, you = can translate by heavy). Furthermore it uses recursivity, not really appreciated! but it's a = tool. *************************************************************************= ******************************************************** For the second step, I need to transfert, from K:\Development to = D:\Development all the folder, sub-folders and files. K:\Development is on network and is previously mounted. The most faster is the best. For the moment I do a simple copyfolder but it's a bit slow. And it's impossible to log the files transfered (but it's not really = important) =20 *************************************************************************= ******************************************************** The third step is not a problem. If someone have good, simple and beautiful idea. Thank you for your help. ------=_NextPart_000_00E4_01C88C0F.C7DAC320 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3268" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I need to modify scripts under unix to = adapt it to=20 Windows XP. The first idea was to use cygwin. It's woks correctly but = for=20 security reason it's quite impossible to install a new tool. So the idea = is to=20 transfert all the scripts under Windows Scripting (.vbs files). = </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>We use four differents tools to design = the=20 application. Each tool generates text file and other specific tools = translates=20 this files in C. At the end, Visual studio 2003 compile it and make = an=20 executable file.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>My global process is :</FONT></DIV> <DIV><FONT face=3DArial size=3D2>1- Clearing the local = environment</FONT></DIV> <DIV><FONT face=3DArial size=3D2>2- Transfering the up to date = environment from=20 an other disk</FONT></DIV> <DIV><FONT face=3DArial size=3D2>3- generating data, compiling, makefile = and so=20 on.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I need help only for the 2 first steps. = One of the=20 constraint is using the standard tools of Windows XP.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial=20 size=3D2>****************************************************************= *****************************************************************</FONT><= /DIV> <DIV><FONT face=3DArial size=3D2>For the step one, how deleting folder, = sub-folders=20 and files included (even if they are read only) to clear totally the = environment=20 on my folder D:\Development</FONT></DIV> <DIV><FONT face=3DArial size=3D2>The most faster is the = best.</FONT></DIV> <DIV><FONT face=3DArial size=3D2> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV>I have done a script like</DIV> <DIV> </DIV> <DIV>Sub Recur(Byval FolderName)</DIV> <DIV>    Set Folder =3D=20 objFSO.GetFolder(FolderName)<BR>     For = Each SubFolder=20 in=20 Folder.SubFolders<BR>        &nbs= p;  =20 Recur subFolder.path<BR>    Next</DIV> <DIV> </DIV> <DIV>    ' Deleting files</DIV> <DIV>    for ...</DIV> <DIV>    next</DIV> <DIV> </DIV> <DIV>    'Deleting folder</DIV> <DIV>    objFSO.DeleteFolder FolderName</DIV> <DIV>end sub</DIV> <DIV> </DIV> <DIV>objFSO.DeleteFolder does not work directly, I need to delete files=20 before.</DIV> <DIV> </DIV> <DIV>The solution works but it's slow and a bit "bourrin" (I am French, = you can=20 translate by heavy).</DIV> <DIV>Furthermore it uses recursivity, not really appreciated! but it's a = tool.</DIV></FONT></DIV> <DIV><FONT face=3DArial size=3D2> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial=20 size=3D2>****************************************************************= *****************************************************************</FONT><= /DIV>For=20 the second step, I need to transfert, from K:\Development to = D:\Development all=20 the folder, sub-folders and files.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>K:\Development is on network and is = previously=20 mounted.</FONT></DIV> <DIV><FONT face=3DArial size=3D2> <DIV><FONT face=3DArial size=3D2>The most faster is the = best.</FONT></DIV> <DIV> </DIV> <DIV>For the moment I do a simple copyfolder but it's a bit = slow.</DIV> <DIV>And it's impossible to log the files transfered (but it's not = really=20 important)</DIV> <DIV>  <DIV><FONT face=3DArial=20 size=3D2>****************************************************************= *****************************************************************</FONT><= /DIV></DIV> <DIV>The third step is not a problem.</DIV> <DIV> </DIV> <DIV>If someone have good, simple and beautiful idea.</DIV> <DIV>Thank you for your help.</DIV> <DIV> </DIV></FONT></DIV></BODY></HTML> ------=_NextPart_000_00E4_01C88C0F.C7DAC320-- Tag: VB Script for Reading from CSV file Tag: 216354
  - 10
    - InputBox output detection I really need some precise information How do I make a rule based on if: 1. Cancel button is selected 2. Or if OK is selcted however no input is provided in the InputBox. I have 2 different events that are to occur depending on which occurs, and there cannot be any overlap. I have found that If IsEmpty(variable) can do detect both and so the same results for both occurs from my statements. I need more finer way of determining this. Does anyone have any tips ? Tag: VB Script for Reading from CSV file Tag: 216351
  - 11
    - Cross Child-Domain Scripting Hello, I am attempting to write a .vbs or .hta or .asp to serve my purpose. Simply enough, i need a user in sub1.dom.com to be able to write to a group in sub1.dom.com and sub2.dom.com... my issue is that i'm getting referrals from the secondary server. basically i'm simply passing in the domain by user input, then connecting to the correct domain... I'm using service accounts in each subdomain. I am having issues launching the vbscript from sub1.dom.com domain using a user residing in sub1... if i use a user in sub2.dom.com in the script running on sub1.dom.com, it will add... i'm at a loss as to the proper way to add users to universal groups... OR to be able to span child domain LDAP look ups in the same script. as simple as it is... here is an HTA snippet of my testing syntax. If choices.value = "sub1" Then strHTML = "<br> Adding User to Group " Const ADS_SCOPE_SUBTREE = 2 '################################################################### ' By: Sonny McManigle | <company> '################################################################### 'On Error Resume Next Set objConnection = CreateObject("ADODB.Connection") Set objCommand = CreateObject("ADODB.Command") objConnection.Provider = "ADsDSOObject" objConnection.Properties("User ID") = "sub1\usr1" objConnection.Properties("Password") = "djsLS7@9d2" objConnection.Properties("Encrypt Password") = TRUE objConnection.Properties("ADSI Flag") = 3 objConnection.Open "Active Directory Provider" Set objCOmmand.ActiveConnection = objConnection objCommand.CommandText = "SELECT distinguishedName FROM 'LDAP:// dc=sub1,dc=dom,dc=com' WHERE objectCategory='user'AND sAMAccountName='" & tmpusr & "'" objCommand.Properties("Page Size") = 1000 objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE Set objRecordSet = objCommand.Execute if err then wscript.echo err.number objRecordSet.MoveFirst If Err Then strHTML = strHTML & "<br> User not found in Domain" Do Until objRecordSet.EOF StrFullDN = objRecordSet.Fields("distinguishedName").Value Set objGroup = GetObject ("LDAP:// CN=Users_SUB1,CN=Users,DC=sub1,DC=dom,DC=com") Set objUser = GetObject ("LDAP://" & strFullDN) objGroup.Add(objUser.ADsPath) If Err = "0" Then strHTML = strHTML & "<br> Successfully wrote to Group" Else strHTML = strHTML & "<br> Failed writing to Group" End If If Err.number = "-2147019886" Then strHTML = strHTML & "<br> This user: " & tmpusr & " is already a member of the Group" End If strfulldn = "" tmpit = "" objRecordSet.MoveNext loop End If If choices.value = "sub2" Then '################################################################### ' By: Sonny McManigle |'################################################################### 'On Error Resume Next Set objConnection = CreateObject("ADODB.Connection") Set objCommand = CreateObject("ADODB.Command") objConnection.Provider = "ADsDSOObject" objConnection.Properties("User ID") = "sub2\usr2" objConnection.Properties("Password") = "7S&29ddo!" objConnection.Properties("Encrypt Password") = TRUE objConnection.Properties("ADSI Flag") = 3 objConnection.Open "Active Directory Provider" Set objCOmmand.ActiveConnection = objConnection objCommand.CommandText = "SELECT distinguishedName FROM 'LDAP:// dc=sub2,dc=dom,dc=com' WHERE objectCategory='user'AND sAMAccountName='" & tmpusr & "'" objCommand.Properties("Page Size") = 1000 objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE Set objRecordSet = objCommand.Execute if err then wscript.echo err.number objRecordSet.MoveFirst If Err Then strHTML = strHTML & "<br> User not found in Domain" Do Until objRecordSet.EOF StrFullDN = objRecordSet.Fields("distinguishedName").Value Set objGroup = GetObject ("LDAP:// CN=Users_SUB2,CN=Users,DC=sub2,DC=ae,DC=com") Set objUser = GetObject ("LDAP://" & strFullDN) objGroup.Add(objUser.ADsPath) Any Help would be GREAT!!!!!!!!!!!!! Tag: VB Script for Reading from CSV file Tag: 216341
  - 12
    - DSN-less Data Connection Code I manage a website that makes use of several Access databases to generate dynamic content. I would like to ensure that my code approach does not produce inefficiencies. I use the same code in multiple asp pages to open data connections (that is the same variable names, although the connection could be to a different database). My common code: Set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " DSNtemp=dsntemp & "DBQ=" & server.mappath("/database/kassaa.mdb") conn.mode = 3 ' adModeReadWrite conn.Open DSNtemp Could this present a problem? Thanks in advance. Bob Mullen Tag: VB Script for Reading from CSV file Tag: 216340
  - 13
    - How to copy Files from one computer to another using Win32_Directo Hi. I can copy a file (using Win32_Directory) from one folder to another, within one computer. But I can't figure out how to copy a file from Computer A to Computer B. I want to learn how to use Win32_Directory to copy files from one computer to another (instead of using the filesystem object, which I [mis-?]understand is less reliable on remote computers). Also, I'm hoping that learning Win32_Directory usage will facilitate my learning the ins & outs of wmi. (I'm a masochist.) The code below shows all the (various wrong) ways (that I dreamed up, and actually) attempted to use Win32_Directory to copy files from one computer to another. I'd appreciate it very much if anyone could: 1. "Show me the way ..." to copy a file using Win32_Directory, and/or 2. Suggest where I might find an example, AND where I could learn more about how it is possible to deduce the answer to my question from the MSDN reference pages, e.g.: http://msdn2.microsoft.com/en-us/library/aa389347(VS.85).aspx I really do want to learn how to find more of these answers on my own, w/o imposing on other peoples' time. Anyway, thanks again for the help you folks give people like me. My failed attempts at coding this by myself follows below.... Marceepoo 'Copy Files from one computer to another using Win32_Directory. ' ' strComputer01 = "light" Set objWMIService01 = GetObject("winmgmts:\\" & strComputer01 & "\root\cimv2") strComputer02 = "." Set objWMIService02 = GetObject("winmgmts:\\" & strComputer02 & "\root\cimv2") Set colFileList01 = objWMIService01.ExecQuery _ ("ASSOCIATORS OF {Win32_Directory.Name='C:\Apps\Deeleet02'} Where " _ & "ResultClass = CIM_DataFile") Set colFileList02 = objWMIService01.ExecQuery _ ("ASSOCIATORS OF {Win32_Directory.Name='C:\Apps\Deeleet03'} Where " _ & "ResultClass = CIM_DataFile") iTeration = 16 Do While iTeration > 0 If iTeration = 1 Then sTargetDir = "c:\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 2 Then sTargetDir = "\\" & strComputer02 & "\\c$\\Apps\\Deeleet03\\" & iTeration Call KopyFile ElseIf iTeration = 3 Then sTargetDir = "\\" & strComputer02 & "\\c\\Apps\\Deeleet03\\" & iTeration Call KopyFile ElseIf iTeration = 4 Then sTargetDir = "\\" & strComputer02 & "\c\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 5 Then sTargetDir = "\\" & strComputer02 & "\c$\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 6 Then sTargetDir = "\\" & strComputer02 & "\c$\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 7 Then sTargetDir = "\\" & strComputer02 & "\c$\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 8 Then sTargetDir = "\\" & strComputer02 & "\c:\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 9 Then sTargetDir = strComputer02 & "\\c$\\Apps\\Deeleet03\\" & iTeration Call KopyFile ElseIf iTeration = 10 Then sTargetDir = strComputer02 & "\\c\\Apps\\Deeleet03\\" & iTeration Call KopyFile ElseIf iTeration = 11 Then sTargetDir = strComputer02 & "\c\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 12 Then sTargetDir = strComputer02 & "\c$\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 13 Then sTargetDir = strComputer02 & "\c$\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 14 Then sTargetDir = strComputer02 & "\c$\Apps\Deeleet03\" & iTeration Call KopyFile ElseIf iTeration = 15 Then sTargetDir = strComputer02 & "\c$\Apps\Deeleet03\" & iTeration Call KopyFile End If iTeration = iTeration - 1 Loop Sub KopyFile() For Each oFile01 In colFileList01 strNewName = sTargetDir & "pl-" & iTeration & "-" & _ oFile01.FileName & "." & oFile01.Extension errResult = oFile01.copy(strNewName) Next End Sub Sub KopyFile() For Each oFile02 In colFileList02 strNewName = sTargetDir & "pl-" & iTeration & "-" & _ oFile01.FileName & "." & oFile01.Extension errResult = oFile01.copy(strNewName) Next End Sub Tag: VB Script for Reading from CSV file Tag: 216339
  - 14
    - vbscript to leverage transactions (and rollbacks) in Vista file Hey all. Vista has hooks built into it to support transaction enabled NTFS. That means theoretically you can start a transaction scope, do stuff and then commit or rollback? Catch is Microsoft didnt include the transaction management commands that where built into the early release candidates...but they did leave the hooks for code to use the functionality. I have seen this demonstrated in C sharp, but I would like to use the functionality in vbscript if possible. Anyone know anything or have an exmaple? Its cool stuff and I am surprised theres not a lot of chit chat regarding this. Tag: VB Script for Reading from CSV file Tag: 216336
  - 15
    - Extracting test data from from XML file to an TextBox in QTP, through Hello Everybody, Can anybody help me, how to Extracting test data from from XML file to an TextBox in QTP. XML file is like this, <?xml version="1.0" encoding="UTF-8" ?> <policy name="PSLF" schema-version="2.1.5" valid="true" PolicyElementDescription="abc"> <NetworkProtectionSettings> <Firewall_rules> <ICMP_block> <Single_IP_block> <Policy_Name>xyz</Policy_Name> <Source_IP>192.22.33.112</Source_IP> <Target_IP>192.22.33.116</Target_IP> </Single_IP_block> </ICMP_block> </Firewall_rules> </NetworkProtectionSettings> </policy> I want to extract values in Policy_Name, Source_IP, Target_IP to TextBoxes in a GUI, which i am automating through QTP with VBScript. Can anybody help me in this regard. Tag: VB Script for Reading from CSV file Tag: 216332
  - 16
    - Extracting test data from from XML file to an TextBox in QTP, through Hello Everybody, Can anybody help me, how to Extracting test data from from XML file to an TextBox in QTP. XML file is like this, <?xml version="1.0" encoding="UTF-8" ?> <policy name="Proventia_Server_for_Linux_Firewall" schema- version="2.1.5" valid="true" PolicyElementDescription="Proventia Server for Linux ICMP block Policy"> <NetworkProtectionSettings> - <Firewall_rules> - <ICMP_block> - <Single_IP_block> <Policy_Name>ICMPDrop</Policy_Name> <Source_IP>172.22.33.112</Source_IP> <Target_IP>172.22.33.116</Target_IP> </Single_IP_block> </ICMP_block> </Firewall_rules> </NetworkProtectionSettings> </policy> Tag: VB Script for Reading from CSV file Tag: 216331
  - 17
    - Zip a file Does anyone have a method of zipping more than one file into one compressed file? I am trying to combine several report files into one so I can then execute command line switches for Outlook to schedule emails. I have the command line working but Outllok will not attach more than one file with this method. Any other ideas? Thank in advance -- Jeff C Live Well .. Be Happy In All You Do Tag: VB Script for Reading from CSV file Tag: 216321
  - 18
    - call a vbscript-function from a html-page Hy there, totally newbie with vbscript so here is my problem: there is an asp-file (info.asp) where a function for reading fileinfos is defined like this: Function FileInfo(ByVal strFileName) Dim fso, file, Text Set fso = Server.CreateObject("Scripting.FileSystemObject") Set file = fso.GetFile(strFileName) Text = "Path : " & file.Path & "<br>" Text = Text & "Attribute: " & file.Attributes & "<br>" Text = Text & file.Name & " in " & file.ParentFolder Text = Text & "<br>Created: " & file.DateCreated Text = Text & "<br>LastAccessed: " & file.DateLastAccessed Text = Text & "<br>LastModified: " & file.DateLastModified FileInfo= Text End Function Now I want to call this function from a html-page like: <script LANGUAGE="VBScript"> strFileName= ("hd:\PathToTheFile\File.htm") Response.Write(info.asp?FileInfo(strFileName)) </script> Got an error msg like "Identifier expected". How to make it correct? Joerg Tag: VB Script for Reading from CSV file Tag: 216318
  - 19
    - apply group policy via wmi I woule like to apply group policy via wmi Tag: VB Script for Reading from CSV file Tag: 216310
  - 20
    - Check verion if version not euql run batch file Const HKEY_LOCAL_MACHINE = &H80000002 Const ForReading = 1 Dim shell set shell=createobject("wscript.shell") Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFSO.OpenTextFile("c:\scripts\EPO.txt", ForReading) Do Until objTextFile.AtEndOfStream strComputer = objTextFile.Readline Path = ("\\" & strComputer & "\c$\Program Files\Network Associates\Common Framework\FrameworkService.exe") version = objFSO.GetFileVersion (Path) Text = "3.6.0.546" If version = text Then WScript.Echo "Versions are equal" Else WScript.Echo "Versions are not equal" End If Wscript.Echo strComputer & " EPO File Version is " & objFSO.GetFileVersion (Path) ' ======================= Get McAfee Version =============================== strKeyPath = "Software\McAfee\DesktopProtection" strValueName = "szProductVer" Set oLocator = CreateObject("WbemScripting.SWbemLocator") Set oService = oLocator.ConnectServer(Machine, "Root\DEFAULT", strAdminUser, strAdminPass) Set oRegistry = oService.Get("StdRegProv") strKeyPath = "Software\McAfee\DesktopProtection" strValueName = "szProductVer" oRegistry.GetStringValue HKEY_LOCAL_MACHINE, strKeyPath, strValueName,strValue WScript.Echo strComputer & " McAfee Version: " & strValue Loop objTextFile.Close The Script run fineso far but I want to add the following: If version = text Then WScript.Echo "Versions are equal" Else run batch file on the remote machine --- I do not know how to excute a batch file on the remote machine End If Tag: VB Script for Reading from CSV file Tag: 216309
  - 21
    - about CapabilityDescriptions I have a HP LaserJet 5100 printer.I run the following script to receive its capability description. It is strange that I receive "color" capability description,though HPLJ5100 is a black and white printer.Why? ######################VBS################################ Set colPrinters=objWMIService.instancesof("win32_printer") For Each objPrinter in colPrinters WScript.Echo "Device Name: " & objPrinter.name CapabilityDescriptions= objPrinter.CapabilityDescriptions For Each Capability In CapabilityDescriptions WScript.Echo Capability next next Tag: VB Script for Reading from CSV file Tag: 216307
  - 22
    - How to read text files on remote servers without mapping/unmapping 1) We have a script that maps and unmaps drives. This script is an audit script. So it is called say from Box1 to BoxA, BoxB, BoxZ etc... To find out where BoxA-BoxZ have been running backups, the script interrogates the backup logs on BoxA-BoxZ. To read the BoxA-BoxZ the script maps a drive ( V: in this instance) objNetwork.MapNetworkDrive "V:", "\\" & strComputer & "\" & "C$", , strUser, strPwd and open to read the back up logs strFilePath = "V:\Program Files\Tivoli\TSM\baclient \dsmsched.log" When finished the drive gets disconnected/unmapped. If there multiple script jobs running concurrently, this could be a problem as there could be a job querying the log file as the volume could have been dismounted from another job. What would be the best way to read the log on a server without mounting the drives? 2) Another reason for mounting the drives, there are some windows commands like "ipconfig" we usually run the command, save as a text file errReturn = objProc.Create ("cmd.exe /c ipconfig > C:\temp \ipview.txt", Null, Null, intPID) Is there a better way of executing command and read the output directly without having to creating an extra file? Tag: VB Script for Reading from CSV file Tag: 216293
  - 23
    - WMI and Joining Domain (sysprep related) I'm looking to add a touch more automation to our PC deployments and am starting to grasp at straws. I am currently using WDS to deploy XPsp2 (slipstreamed) pretty much unattended. Sysprep is performing a JoinDomain using a preset name with wildcards (Computer-xxxxx) which works well - I simply logon to the pc after deployment and manually rename using our naming solution (<3_letter_Building_Code><5digit_Asset_#>[special_use_suffix]) ie: EMC12345LAB Our asset database (Oracle based) contains information (entered manually) and includes mac address, building code, asset#, and any additional suffix. The db is currently exported every 10 minutes into a MySQL db. Q: Is there any way to automatically have the systems named properly by querying the database for the info (I don't want db drivers installed on the workstation though so am willing to have the db exported to csv or to some flatfile for reading if necessary). I have vbscript examples for renaming the workstation and can manually run it once the local admin group has been added to the pc but want something unattended. The local admins group isn't added to the workstations Administrators group until the workstation is moved into the proper AD container. One partial method I have available and can use after the fact is to open an IE window (scripted) with an url containing the workstations mac address which returns the full workstation name in the innerhtml (IE: objExplorer.Navigate "http://internalweb/hwaddr/?hw_address=" & MACAddress) What I'd like is to have WDS or a post-install script run (with privileges to allow renaming the pc on the domain or have the script join the domain and put it into the proper container) that will modify sysprep.inf or whatever else is needed to have the computer join with the appropriate workstation name. The only field tying the whole thing together in the db that can be automatically retrieved would be the mac address. Ideally I'd like to have 2 functions. 1: Name workstation using database info and join to domain. WDS to image the workstation. At the end of sysprep mini-setup, query for the what the workstation name should be (and maybe retrieve a container name also..based on an entry in the asset db) Join the Domain with the proper wsname. 2:via HKLM...Run: Silently run a vbscript that will check for admin privileges, check computername against the db and if it is different call a computer rename script. Can I launch a vbscript from cmdlines.txt (during the sysprep mini-setup) to get the wsname? I have a generic domain admin acct setup with its only privilege as being able to add/rename on the domain. Any help is appreciated! Eric Gustafson Springfield School District Tag: VB Script for Reading from CSV file Tag: 216287
  - 24
    - Associated External Account Question I have created a script that will disable a user's account, move it into a specified ou and then add the associated external account permission to the SELF account. My problem is that the associated external account permission only gets assigned to the SELF account in a newly created user account. If the user account is used (ie the user logs into OWA or a PC) or pre-existing then nothing happens. The script is displayed below. Any ideas? ************************************************************ 'On Error Resume Next 'Defines from which container search will start Const ADS_SCOPE_SUBTREE = 2 Const ADS_USERDISABLED = &H00002 const E2K_MB_FULL_MB_ACCESS = &H00001 const E2K_MB_SEND_AS = &H00002 const E2K_MB_EXTERNAL_ACCOUNT = &H00004 const E2K_MB_READ_PERMISSIONS = &H20000 const E2K_MB_TAKE_OWNERSHIP = &H80000 const ADS_ACE_REVISION_DS = &H00004 const ADS_ACETYPE_ACCESS_ALLOWED = &H00000 const ADS_ACEFLAG_INHERIT_ACE = &H00002 'Sets User Flag Parameter Const ADS_UF_ACCOUNTDISABLE = &H2 'Dim strUserName Dim strUserName 'Creates an input box to type in user's name strUserName = InputBox("Enter the username:") 'connect to AD Set objConnection = CreateObject("ADODB.Connection") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" Set objCommand = CreateObject("ADODB.Command") Set objCommand.ActiveConnection = objConnection objCommand.Properties("Page Size") = 1000 objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE objCommand.CommandText = _ "SELECT ADsPath FROM 'LDAP://DC=london,DC=glenrand'" & _ "WHERE objectCategory='User'" & _ "AND cn='" & strUserName & "'" Set objRecordSet = objCommand.Execute 'Get user record objRecordSet.MoveFirst Do Until objRecordSet.EOF strPath = objRecordSet.Fields("ADsPath").Value Set objUser = GetObject(strPath) intUAC = objUser.Get("userAccountControl") objUser.Put "userAccountControl", intUAC OR ADS_UF_ACCOUNTDISABLE objUser.SetInfo Call SetmsExchMasterAccountSid 'Move user to Ex Employees OU Set objNewOU = GetObject("LDAP://OU=exemployees,DC=london,DC=glenrand") intReturn = objNewOU.MoveHere(strPath, vbNullString) objRecordSet.MoveNext Loop 'msgbox "The user account for " & strUserName & " has been disabled" msgbox strUserName & "'s user account has been disabled" 'This function sets the msExchMasterAccountSid value in ADSI to SELF. 'ie Adds Associated External Account permission to the SELF account. Function SetmsExchMasterAccountSid Dim objSD Dim objACL Dim objACE Dim found 'Set the primary Account to SELF objUser.Put "msExchMasterAccountSid", objUser.Get("objectSID") 'Get the mailbox security descriptor set objSD = objUser.Get("msExchMailboxSecurityDescriptor") set objACL = objSD.DiscretionaryAcl found = false for each objACE in objACL 'Iterate through the ACL to find the SELF-Account if objACE.Trustee = "NT AUTHORITY\SELF" Then found = true wscript.echo "exists" Exit For end if next if not found then 'If no SELF-Account is present, create it set objACE = CreateObject("AccessControlEntry") objACE.Trustee = "NT AUTHORITY\SELF" wscript.echo "created" objACE.AceFlags = ADS_ACEFLAG_INHERIT_ACE objACE.AceType = ADS_ACETYPE_ACCESS_ALLOWED objACL.AddAce objACE end if 'Give the SELF-Account the External-Account right objACE.AccessMask = objACE.AccessMask OR E2K_MB_READ_PERMISSIONS OR E2K_MB_FULL_MB_ACCESS OR E2K_MB_EXTERNAL_ACCOUNT 'Save the changes objUser.Put "msExchMailboxSecurityDescriptor", objSD objUser.setInfo Set objSD = Nothing Set objACL = Nothing Set objACE = Nothing End Function Tag: VB Script for Reading from CSV file Tag: 216285
  - 25
    - Line Spacing I have a vbscript reading active directory attributes to create an email signature. When the "streetaddress" is pulled in, it double spaces the lines, even though the "streetaddress" is not double spaced. Is there a code for single line spacing i can place before the street address to force single space? Thanks, Michael Tag: VB Script for Reading from CSV file Tag: 216281
- Next
  - 1
    - New things and free download.... New things and free download.... just click the link......... u'll got a new expereience........ free download softwares and games..... etc..... http://bajagu.guys.googlepages.com/www.newinfoproducts.c-o.in Tag: VB Script for Reading from CSV file Tag: 216275
  - 2
    - How to monitor print job I write a VBS to monitor print job. The following script works well. ##############VBS-1#################### Set colPrintJobs = objWMIService.ExecQuery("Select * from Win32_PrintJob") For each objPrintJob in colPrintJobs Wscript.echo objPrintJob.caption next ######################################### But when I use ExecNotificationQuery to retrieve the object collection,it throws out a running time error which tells me that object does not support the property or method :"objPrintJob.caption".Could you tell how to monitor print job? ##############VBS-2#################### Set colPrintJobs = objWMIService.ExecNotificationQuery("Select * from __instancecreationevent WITHIN 1 WHERE TargetInstance ISA 'Win32_PrintJob'") Do While True Set objPrintJob =colPrintJobs.NextEvent() WScript.Echo "Caption: " & objPrintJob.Caption Loop ######################################### Tag: VB Script for Reading from CSV file Tag: 216273
  - 3
    - currency format How do you format the following for currency? <% varAmt = rsTemp.Fields("SAmount") %> Is it something like the following? The following doesn't however. <% varAmt = String.Format("{0:c}", rsTemp.Fields("SAmount")) %> Tag: VB Script for Reading from CSV file Tag: 216270
  - 4
    - Need script to find I/O Reads of a specified process Is there any way to find the I/O Reads value of a specific process. I looked up the properties of the Win32_Process but did not see this option. TIA -- Greg Tag: VB Script for Reading from CSV file Tag: 216269
  - 5
    - Changing power scheme for all users Hollo everyone. I have pasted a two part script. I'm new to this so I don't know how to prevent the first part from echoing the chassis type. What I need for this script to do is check the chassis type and if the chassis type is a laptop(8,9,10) the script should run the second part of the script. The second part of the script changes the power scheme for the current user. Please help. This seems like it should be easy for for someone with a scripting background. I unfortunately don't know how to script. Thank you in advance. WScript.Echo GetFormFactor Function GetFormFactor Const adTypeBinary = 1 Dim objColl, o, obj, sResult, f, fso Set fso = CreateObject("Scripting.FileSystemObject") GetFormFactor = "D" Set objColl = GetObject("winmgmts:").ExecQuery("SELECT * FROM Win32_SystemEnclosure") For each obj in objColl For each o in obj.ChassisTypes If (o = 8) or (o = 9) or (o = 10) Then : GetFormFactor = "L" Next Next End Function Dim intSleepTime intSleepTime = 5000 Set WshShell = WScript.CreateObject("WScript.Shell") ' Set the Default to be "Custom Profile" ' Turn off Hibernation WshShell.Run "%COMSPEC% /c POWERCFG /SETACTIVE ""Custom Profile""" WshShell.Run "%COMSPEC% /c POWERCFG /Hibernate off" ' Start changing Power Management profiles' settings ' Change "Home/Office Desk" profile settings WshShell.Run "%COMSPEC% /c POWERCFG /CHANGE ""Home/Office Desk"" /monitor-timeout-ac 5 /monitor-timeout-dc 5 /disk-timeout-ac 10 /disk-timeout-dc 10 /standby-timeout-ac 30 /standby-timeout-dc 30 /hibernate-timeout-ac 0 /hibernate-timeout-dc 0" WScript.Sleep intSleepTime ' Change "Portable/Laptop" profile settings WshShell.Run "%COMSPEC% /c POWERCFG /CHANGE ""Portable/Laptop"" /monitor-timeout-ac 5 /monitor-timeout-dc 5 /disk-timeout-ac 10 /disk-timeout-dc 10 /standby-timeout-ac 30 /standby-timeout-dc 30 /hibernate-timeout-ac 0 /hibernate-timeout-dc 20 /processor-throttle-ac adaptive /processor-throttle-dc adaptive" WScript.Sleep intSleepTime ' Cleanup Set WshShell = Nothing WScript.Quit(0) Tag: VB Script for Reading from CSV file Tag: 216268
  - 6
    - OutLook Express 6.0 Script Folks: I am using Microsoft Outlook Express 6 as my email client software. I would like to get access to a script that would alarm.(play an audio file) when email is received from a specific address. maybe such a script already exists. Thanks, JoJo. Tag: VB Script for Reading from CSV file Tag: 216264
  - 7
    - Quoting within already quoted command I am trying to create a script that allows a user to start and stop a service on a remote computer. I am having troubles with spaces in the command. Here is what I have so far. I am having troubles with line following Case "1" and Case "2" Any advice would be greatly appreciated. ================================================================ Option Explicit Dim objmenu, username, wshshell, fso Set WshShell = WScript.CreateObject("WScript.Shell") Set fso = CreateObject("Scripting.FileSystemObject") Username = InputBox("Enter your admin username (domain\username)", "Enter Username") 'create an object from the gui_menu class Set objmenu = New gui_menu 'start the application objmenu.getInput Class gui_menu private Input, quit, strText, cmd, arrMenu, i, return, strProg Private Sub pickInput 'if you add anything to the menu array below, make sure you add a corresponding entry here Select Case Input Case "1" cmd = " ""sc \\remotecomputer stop" "Service with spaces in name""" startProg cmd WScript.Sleep(22000) getInput Case "2" cmd = " ""sc \\remotecomputer start "Service with spaces in name""" startProg cmd getInput Case "3" quit = MsgBox ("Are you sure?", 36, "Want To quit?")'52 If quit = 6 Then WScript.Quit Else getInput End If Case "" quit = MsgBox ("Are you sure?", 36, "Want To quit?")'52 If quit = 6 Then WScript.Quit Else getInput End If Case Else MsgBox ("That is an incorrect entry, try again") getInput End Select End Sub 'pickInput Public sub getInput 'add any menu names you want in this array, make sure you adjust the select/case in pickInput() accordingly arrMenu = Array("STOP Service","START Service","Quit or click Cancel") strText = "Enter selection below." & vbNewLine 'build the menu For i = 1 To (UBound(arrMenu) + 1) strText = strText & i & ". " & arrMenu(i - 1) & vbNewLine Next Input = InputBox(strText, "Make your selection") pickInput End sub 'getInput Private Sub startProg(cmd) return = WshShell.Run("%windir%\system32\runas.exe /user:" & username & cmd, 1, False) End Sub 'startProg End Class 'gui_menu ============================================================== Tag: VB Script for Reading from CSV file Tag: 216260
  - 8
    - vbscript and Junctions Does anybody know what the syntax is to determine if a directory is a junction? In Vista the c:\documents and settings is a junction. Tag: VB Script for Reading from CSV file Tag: 216252
  - 9
    - Add network printer in WMI, how can I actually add a new network printer, configuring its properties like shared, shared name, port/portname, device etc... ? Im actually using C# to code but can understand VBScript/WMI scripting so thats no a problem, I just want to know how to do this and execute the method/operation to go ahead and create the printer. Tag: VB Script for Reading from CSV file Tag: 216241
  - 10
    - vbscript using getfolder I've posted this question in so many forum's with no answer. Why does the following script get a permission denied error on vista even when run as administrator or run while logged in as the builtin administrator? Int n On Error Resume Next Dim fs, f Set objShell = CreateObject("Shell.Application") Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.GetFolder("c:\windows\system32) n = f.Size If Err.Number <> 0 Then MsgBox Err.Number & ": " & Err.Description & " folder: " & f.name Err.Clear End If str = UCase(f.Name) & " uses " & n & " bytes." wscript.Echo str Tag: VB Script for Reading from CSV file Tag: 216226
  - 11
    - Help Required Please refer to the below vb script Dim oFS, oFolder Dim objexcel, r, lnameArray, lname, nameLength set oFS = WScript.CreateObject("Scripting.FileSystemObject") set oFolder = oFS.GetFolder("C:\test") Set objExcel = createobject("Excel.application") objexcel.Workbooks.add objexcel.Cells(1, 1).Value = "Folder Name" objexcel.Cells(1, 2).Value = "Size (MB)" objexcel.Cells(1, 3).Value = "# Files" objexcel.Cells(1, 4).Value = "# Sub Folders" objexcel.Visible = True Wscript.Sleep 20 r=2 ShowFolderDetails oFolder, r objexcel.ActiveWorkbook.SaveAs("C:\FolderReport.xls") objexcel.Quit Function ShowFolderDetails(oF,r) Dim F objexcel.Cells(r, 1).Value = oF.Name objexcel.Cells(r, 2).Value = oF.Size /1024\1024 objexcel.Cells(r, 3).Value = oF.Files.Count objexcel.Cells(r, 4).Value = oF.Subfolders.count r = r+1 for each F in oF.Subfolders ShowFolderDetails F, r next End Function Instead of the folder test, i require the script to search folder based on date - specifically folder created on the previous date. Any help appreciated. Tag: VB Script for Reading from CSV file Tag: 216223
  - 12
    - WMI error This line in our logon script... Set oWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2") ...returns an error code 80041002 on some systems. Anyone have ideas what might be causing it? Thanks, Tom Tag: VB Script for Reading from CSV file Tag: 216221
  - 13
    - Changing file/folder permissions Hi All I understand I can call the cacls command from a VB script to alter permissions on files/folders. I was just wondering if there is a pure VB way of doing this? Changing permissions of a folder on a PC which is a member of a domain (if that makes a diff?) Thanks gerryR Tag: VB Script for Reading from CSV file Tag: 216218
  - 14
    - problem with vbscript hi guys i'm Alex and i have a problem, i want create a VBscript with copyfolder command for each profile into PC: folder source: c:\test (in the folder there are many files and folders) folder destination: ...\"user profile"\Applications data this copy run for default user, administrator and all users but don't work for all profiles first create. can you help me???? Tag: VB Script for Reading from CSV file Tag: 216216
  - 15
    - Delete Local Profiles for WinPe I am trying to delete the local profiles on my computer. However, whenever I try to delete a users profiles under C:\Users\* on my Vista machine, my script fails. It seems to be that it can't some of the special folders in C:\Users\*\AppData. For example, my script always fails on C:\Users\*\AppData\Local\Application Data. This appears to be a redirector but my script sees it as a folder and tries to delete it. I have spent many hours trying to get around this but every time my script fails with an Access Denied error. I have used WMI and the FileSystemObject. Any help with this problem would be greatly appreciated. Thanks Tag: VB Script for Reading from CSV file Tag: 216204
  - 16
    - Backing up files with vbscript and maybe Volume Shadow Copy Hello, I'm looking to write a small vbscript to backup a laptop users PST files to a network drive. I would like this to happen without the need for a user to close Outlook. I have read a little about Volume Shadow Copy and I'm wondering if this is the best thing to use and how you can control it from Vbscript / Windows XP. Currently we are using a batch file however it "coughs, sputters, barfs, farts then explodes" every time it comes to a PST file (file in use). Thanks in advance. Tag: VB Script for Reading from CSV file Tag: 216200
  - 17
    - Move file if created in last two minutes I have an application which writes a txt file to a certain directory. The application writes to this file twice using the logged in users credentials, in quick succession. Once this process is finished I need to retrict access to the file by the creator. Two options spring to mind:- 1. Restrict the directory and change the file owner once the application has completed 2. Move the finished file to a directory the creator does not have access to. Option 2 seems the simplest if I can script to check file creation date is more than say 2 minutes older than current system time. There are several utilities mentioned previously in the forums but mostly they deal with date, not time. Appreciate any guidance. Tag: VB Script for Reading from CSV file Tag: 216191
  - 18
    - If possible to add domain user to a workstation's local administrators group by scrpting? I am wondering if possible to add domain user to a workstation's local administrators group by scrpting. You konw, in most scenario we use {objLocalGroup}.add function to achieve this target, but what if a workgroup? When I try this on workgroup, script prompts fails with "unknow user name or bad password". Any ideas? Tag: VB Script for Reading from CSV file Tag: 216189
  - 19
    - help with cancel loops How do I loop a the cancel button here : Do StudentUserName = InputBox ("Please Enter a Student Username ?",_ "Student User Credentials") If IsEmpty(StudentUserName) Then Wscript.Quit Loop until StudentUserName <> "" I want to loop to the start of the entire script. iAnswer = Msgbox("Would you like to configure a Student ?" &vbCrLf &vbCrLf _ & "Select Yes to Continue, Select No to Configure a Staff !",vbYesNoCancel + vbquestion, _ "Config Script") I've see this and asked a similar question before but have totally messed it up. If possible can you please explain how you did it too. I am trying to learn more about it. The entire script is below: *************************************************************************************************************** Dim user, StudentUserName, StaffUserName, StudentComputerName, StaffComputerName, iAnswer, iConfirm iAnswer = Msgbox("Would you like to configure a Student ?" &vbCrLf &vbCrLf _ & "Select Yes to Continue, Select No to Configure a Staff !",vbYesNoCancel + vbquestion, _ "Config Script") If iAnswer = vbYes Then user = "student" ElseIf iAnswer = vbNo Then user = "staff" Else iAnswer = vbCancel Wscript.Quit End If select case user case "student" Do Until iConfirm = vbYes Do StudentUserName = InputBox ("Please Enter a Student Username ?",_ "Student User Credentials") If IsEmpty(StudentUserName) Then Wscript.Quit Loop until StudentUserName <> "" iConfirm = Msgbox("Please Confirm the following Information" &vbCrLf &vbCrLf & _ "Student User Name: " & StudentUserName &vbCrLf &vbCrLf & _ "Select Yes to Continue, No to Change User Information ",vbYesNo + vbinformation, _ "Student Details") Loop StudentComputerName = StudentUserName + "x" msgbox "You username is " & StudentUserName msgbox "You Computer Name is " & StudentComputerName case "staff" Do Until iConfirm = vbYes Do StaffUserName = InputBox ("Please Enter a Staff Username ?",_ "Staff User Credentials") If IsEmpty(StaffUserName) Then Wscript.Quit Loop until StaffUserName <> "" iConfirm = Msgbox("Please Confirm the following Information" &vbCrLf &vbCrLf & _ "Staff User Name: " & StaffUserName &vbCrLf &vbCrLf & _ "Select Yes to Continue, No to Change User Information ",vbYesNo + vbinformation, _ "Staff Details") Loop StAffComputerName = StaffUserName + "x" msgbox "You username is " & StaffUserName msgbox "You Computer Name is " & StaffComputerName end selec Tag: VB Script for Reading from CSV file Tag: 216187
  - 20
    - account creation Please help I am trying to modify the below creat user account script. I would like the account creator to enter the OU in text box so account can be created in that location. (eg OU=***,OU=***,DC=***,DC=***,DC=UK) enter in text box. unfortunately I am receiving error messages. please help. strpath = ("LDAP://" & strOuList) set objOU = GetObject(strPath) Set objUser = objOU.Create("User", "cn=" & strUser) objUser.Put "sAMAccountName", LCase(strUser) objUser.SetInfo I have also tried Set objOU = GetObject("LDAP://" & strOuList) Set objUser = objOU.Create("User", "cn=" & strUser) objUser.Put "sAMAccountName", LCase(strUser) objUser.SetInfo Tag: VB Script for Reading from CSV file Tag: 216174
  - 21
    - VBS = Error - ASP = OK - Why ?? Hi I have a .VBS file - contents below: ===================================================================== dataBaseRoot = "d:\Servers\byers\data\mmailing\" DBConLS = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & dataBaseRoot & "data\listShares.mdb" set ConLS = CreateObject("ADODB.Connection") ConLS.Open DBConLS ===================================================================== When I double click on it, the error shown below is generated. --------------------------- Windows Script Host --------------------------- Script: D:\Servers\Byers\wwwroot\mmailing\connectionTest.vbs Line: 7 Char: 1 Error: Provider is not specified and there is no designated default provider. Code: 800A0EA9 Source: ADODB.Connection --------------------------- OK --------------------------- I have a Classic ASP file - contents below ===================================================================== dataBaseRoot = "d:\Servers\byers\data\mmailing\" DBConLS = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & dataBaseRoot & "data\listShares.mdb" set ConLS = Server.CreateObject("ADODB.Connection") ConLS.Open DBConLS ===================================================================== When I run the ASPage in Internet Explorer - it runs OK (and actually Opens the Database) I have tried the "Jet" provider - same results I have Installed the latest MDAC (2.8) Why does it work in the ASP but not in the VBS (It works on other servers - but not this new one) THE SERVER IS Operating System Microsoft Windows Server 2003, Standard Edition OS Service Pack Service Pack 2 Internet Explorer 7.0.5730.11 DirectX 4.09.00.0904 (DirectX 9.0c) Thank you Pete (Northolt UK) Tag: VB Script for Reading from CSV file Tag: 216170
  - 22
    - Replacing single apostrophe (') with two single quotes ('') I am using RC wintrans as the software to localize our company`s software. To localize the strings being used in our software i export all the strings with their string IDs to an excel file and send them for translation. Now when i try to import the translation back into the DB of RC wintrans, excel does not return the strings starting with single quote ' , hence the translation of such strings are not imported automatically into RC wintrans. I would like to write a script, which searches through the strings in the excel file and replace every string starting with single quote ' with two single quotes '' ( remind you its not double quote but two single quotes). Can anybody help me with that? Can you please share it with me if you have any script that could help. Tag: VB Script for Reading from CSV file Tag: 216168
  - 23
    - Trading Forex WHO WE ARE? We are a partnership based in India and USA. We have a collective FOREX trading experience of 4 years.We decided to start this venture with the intent of helping people in India and other countries take advantage of immense potential profits from the FOREX markets. We act as Liasons between our clients and our partner forex broker and ensure that our clients receive adequate support inspite of being in different countries. WHY CHOOSE US? * FREE!! No extras commission spreads. * Get a friendly advocate in USA in case of broker assistance. * FREE assistance on forex related queries [Educational /Trading Decisions /Trading Sysems /Regulations]. * Live Trading Chat facility to discuss live calls. WHY INTERBANKFX? * We have had excellent experience with InterbankFx. * Professional Charting. * MetaTrader Support. * Credit Card deposit facility available. * Minimum required to open an account as little as USD 250. * No Dealing desk. * Full hedging and trailing stops. * Efficient spreads [as low as 2 on euro, subject to market volatility]. -------------------------- http://www.eecpindia.com http://www.anchorfx.com *** Sent via Developersdex http://www.developersdex.com *** Tag: VB Script for Reading from CSV file Tag: 216166
  - 24
    - Open File with VB 6.0 Hello Y'all I am wondering if anyone knows how to open a file via VB 6.0 I don't ant to open it into VB, just use vb to open the file e.g. When cmdOpen is clicked Open run.bat Thank you, Jacob Stone Tag: VB Script for Reading from CSV file Tag: 216160
  - 25
    - I need a login script that rejoins a machine to a new domain I need a login script or script that rejoins a machine to a new domain. I have over 100 workstations in the organization and I need a script that can automate this task. Thank You Tag: VB Script for Reading from CSV file Tag: 216158

I need a script that can read Group Information from a text file
(CSV) and create groups in the AD and then add members (from a CSV) to
these groups.
(even if it is in 2 different file no problem)
the idea is that we will extract some details from an AD then we need
to add the extracted details(CSV File) to another AD
Please help it is urgent

Top

Re: VB Script for Reading from CSV file by mr_unreliable

mr_unreliable
Tue Mar 25 12:00:19 CDT 2008

85.reem@gmail.com wrote:
> I need a script that can read Group Information from a text file
> (CSV) and create groups in the AD and then add members (from a CSV) to
> these groups.

hi 85.reem, csv files are normally read using fso, (to read
line-by-line), and the "split" function, (to break down
the line into an array of the discrete values being separated
by the commas).

Is there something with either fso or the split that is causing
you a problem?

cheers, jw
____________________________________________________________

You got questions? WE GOT ANSWERS!!! ..(but,
no guarantee the answers will be applicable to the questions)

Top

Re: VB Script for Reading from CSV file by MikeB

MikeB
Tue Mar 25 14:35:18 CDT 2008

"mr_unreliable" <kindlyReplyToNewsgroup@notmail.com> wrote in message
news:edXcGjpjIHA.2268@TK2MSFTNGP02.phx.gbl...
> 85.reem@gmail.com wrote:
>> I need a script that can read Group Information from a text file
>> (CSV) and create groups in the AD and then add members (from a CSV) to
>> these groups.
>
> hi 85.reem, csv files are normally read using fso, (to read
> line-by-line), and the "split" function, (to break down
> the line into an array of the discrete values being separated
> by the commas).

Also read using ADODB:

"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" & sFolder &
";Extensions=asc,csv,tab,txt;"

I use it all the time.

> Is there something with either fso or the split that is causing
> you a problem?
>
> cheers, jw
> ____________________________________________________________
>
> You got questions? WE GOT ANSWERS!!! ..(but,
> no guarantee the answers will be applicable to the questions)
>

Top

Re: VB Script for Reading from CSV file by Pegasus

Pegasus
Tue Mar 25 16:26:23 CDT 2008

<85.reem@gmail.com> wrote in message
news:9dfee243-b070-44cb-865c-9553d108e82d@b1g2000hsg.googlegroups.com...
>I need a script that can read Group Information from a text file
> (CSV) and create groups in the AD and then add members (from a CSV) to
> these groups.
> (even if it is in 2 different file no problem)
> the idea is that we will extract some details from an AD then we need
> to add the extracted details(CSV File) to another AD
> Please help it is urgent

Have a look at this link:

Create User Accounts from Information in an Excel Spreadsheet
http://msdn2.microsoft.com/en-us/library/ms974568.aspx

Top