vbscript msgbox 1023 character limit

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
    - simple script to copy file to system32 Hi, can any one help me with a simple script to copy file call test.dll from a network path to remote computer c:\windows\system32 directory to replace an older file already there. I found some of the script on Microsoft site for copy file but it does not work. I think the problem is because copying file to system32 directory and it's protected. I want to have this script excecute maybe as a log on scrip on run on demand. Thanks in advance for your help Tag: vbscript msgbox 1023 character limit Tag: 203322
  - 2
    - How do I copy REG_EXPAND_SZ keys without expanding? I'm trying to copy a registry key and its values to another key. I can get the value of type REG_EXPAND_SZ keys but it looks like the string value is expanded in the process. As I am trying to copy from one key to another I would like to get the unexanded value. Here briefly, is how I'm getting the key: Set StdOut = WScript.StdOut Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\default:StdRegProv") oReg.GetExpandedStringValue hive,keypath,name,strValue StdOut.WriteLine " " & strValue Printing strValue out shows the expanded value. Where the content of the value "name" might be "This is the path: %PATH%" the actual printed value will show the expanded value of %PATH%. I want to copy that value as is to the new key:name. Is there a way to get the unexpanded value? I tried using oReg.GetStringValue but it operated the same way as the oReg.GetExpandedStringValue function. Any help would be appreciated Tag: vbscript msgbox 1023 character limit Tag: 203317
  - 3
    - SQL and vbscript Trying to read a sql server 2005 table from a vendor and I'm not having any luck I'm getting the error : Invalid Object Name '_SMDBA_._CUSTOMER_' on execution of the select statement I'm not real skilled when it comes to attaching to sql. I have the sa as the authorizing account so I can attach. Ideas? The vendor has just installed the software and I have to sync up fields between AD and this app and I have zero experience with SQL 2005. So maybe there is a setting in sql that has to be configured. I just don't understand the use if the two decimal name (The FROM name) and if the script can handle it correctly. Set objConnection = CreateObject("ADODB.Connection") Set objRecordset = CreateObject("ADODB.Recordset") objConnection.Open "DSN=SDE;", strUserName, strPassword objRecordset.CursorLocation = adUseClient objRecordset.Open "SELECT * FROM _SMDBA_._CUSTOMER_" , _ objConnection, adOpenStatic, adLockOptimistic -- Paul Tag: vbscript msgbox 1023 character limit Tag: 203311
  - 4
    - Opening Multiple Excel Workbooks Hi, I am tryong to creat a script that will read a server name from one workbook, do a discovery and write the results to another workbook template. I have been using a Txt file for my server name input file, but I though it would be more efficient to cut out the middle man by pulling the server names from the source. I can open both the source wookbook and my template with out a problem. The trouble arises when I try to select Cell B4 for the first server name in Book1 and then write it to book2. Any ideas? My code so far: <-------------------------------------------------------------------------------------------------------- > '******************* '* Define Constants '******************* Const ForReading = 1 '******************** '* Declare variables k = 6 ' Dim Message, result strExcelPath = "C:\Scripts" ' Define Msg Box Var Message = "Please Enter CR Number" Title = "Production Readiness Checklist" '******************** '========================================================================== result = InputBox(Message, Title, "Type CR Number Here", 200, 200) fCr = result If result = "" Then WScript.Quit End If Set oXL = Wscript.CreateObject("Excel.Application") oXL.Visible = True oXL.DisplayAlerts = False Set book1 = oXL.Workbooks.Open("C:\Scripts\Checklist.xls") 'Source for server Names set book2 = oXL.Workbooks.Open("c:\scripts \readinesschecklisttpl.xls") 'My template set book3 = oXL.Workbooks.Open("c:\scripts\Report.xls") 'An inventory that I refer to in the template book1.activate x = 4 Do Until oXL.Cells(x, 2).Value = "" If oXL.Cells(x, 2).Value = "" Then Exit Do End If strComputer = oXL.Cells(x, 2).Value 'Set objFSO = CreateObject("Scripting.FileSystemObject") 'Set objTextFile = objFSO.OpenTextFile("C:\Scripts\PRC.txt", ForReading) ' OPEN Excel Worksheet Template and fill in the blanks Set objWorksheet = book2.Worksheets(1) objWorksheet.Range("A1:S5").Font.Bold = True objWorksheet.Select objWorksheet.Cells(2, 2).Value = fCr objWorksheet.Cells(3, 2).Value = Date objWorksheet.Cells.EntireColumn.AutoFit '......And so on Tag: vbscript msgbox 1023 character limit Tag: 203308
  - 5
    - split function issue I am using the split function but have run into an issue. A spreadsheet has been saved to csv so my split function looks for seperator of ",". all works well except to when there is a comma inside quotes. As you know if there is a comma in a field when excel export it will place quotes around the value. for example: 1,test,"user, test",5590, xyz how can I overcome this issue? Is there some other function I can use? thanks in advance. Tag: vbscript msgbox 1023 character limit Tag: 203307
  - 6
    - Retrieving monitor serial numbers from EDID Hey all.. I've been toying with this script: http://cwashington.netreach.net/depo/view.asp?Index=980&ScriptType=vbscript I've been using it to pull serial numbers from PC's on the network. There is one problem.. it doesn't look like DELL flat panels store their entire S/N in EDID. It's segmented. For example: A serial number of: CN0123472872567890A comes out as: 1234567890A I know manufacturers aren't *required* to pass info into EDID, but does anyone know DELL serials well enough to know if there's a way to calculate the missing data? Or is it stored someplace else in EDID? It's a shot in the dark.. but perhaps someone can help. Tag: vbscript msgbox 1023 character limit Tag: 203306
  - 7
    - Delete Column In Excel, I need a macro that will delete a column based on a cell that will contain a name based on an input box. Thanks, Bernie Tag: vbscript msgbox 1023 character limit Tag: 203296
  - 8
    - Unzip File I've got some code that unzips a file (supposedly). The person who wrote it says that it works fine on his computer. I've seen it work, too. :) However, I'm running it from my computer and I get an error message that says "The file exists". Error occurs on this line (Watch for word wrap): objShellApp.NameSpace(strWorkFolder).CopyHere objShellApp.NameSpace(strZipFilePath).Items Has anybody used the Shell Namespace for unzipping before? And if sso, would you please point out why this might not work? I'm running XP Professional with all the latest updates. Public Sub Extract() 'Declare variables Dim objFileSystem Dim workFolder As Folder Dim workFile As File Dim objShellApp Dim strUcaseFileName As String Dim strZipFilePath, strWorkFolder 'Initialize objects Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set workFolder = objFileSystem.GetFolder(strWorkPath) Set objShellApp = CreateObject("Shell.Application") For Each workFile In workFolder.Files strUcaseFileName = UCase(workFile.Name) If (Mid(strUcaseFileName, 1, 2) = "PS" Or _ Mid(strUcaseFileName, 1, 3) = "TLD" _ Or Mid(strUcaseFileName, 1, 2) = "RP" Or Right(strUcaseFileName, 4) = ".ZIP") Then objFileSystem.DeleteFile (strWorkPath & workFile.Name) End If Next 'Copy the file with unit extension to work 'directory with the name work.zip 'for processing the zip file. Assign the 'complete path of the file to a variable objFileSystem.CopyFile strLEWkPath & Infilename, strWorkPath & "work.zip" 'ShellApp.Namespace is not able 'to accept string type variables. 'hence we are taking a variant type local variables 'to hold work folder path and zip file name and path strZipFilePath = strWorkPath & "work.zip" strWorkFolder = strWorkPath & "Extract" strWorkFolder = strWorkPath 'Use Shell.Application object's "Copyhere" 'method to extract files from the zip file 'this depends on the default file extraction 'capability of windows it works in XP '********Important*********** This code will not 'work on windows 2000 Pro. objShellApp.NameSpace(strWorkFolder).CopyHere objShellApp.NameSpace(strZipFilePath).Items Set objFileSystem = Nothing Set objShellApp = Nothing End Sub Tag: vbscript msgbox 1023 character limit Tag: 203294
  - 9
    - Unexpected Next Hi all Wicked head cold today and I can't think straight...anybody point out the obvious as my mind is incapable of any normal thought. <sniff><cough><sniff> '===============Start Here=================================== On Error Resume Next Dim EnvironmentType Dim objshell Dim dwcorrectValue Dim dwcorrectvalue2 Dim dwvalue Dim dwvalue2 Dim result '================================================== 'Check the Date seperator and the short date format 'if good then move on...if not Getdateformat.... '================================================== Set objShell = WScript.CreateObject("WScript.Shell") dwcorrectValue = objShell.RegRead("HKEY_USERS\.DEFAULT\Control Panel \International\sShortDate") dwcorrectValue2 = objShell.RegRead("HKEY_USERS\.DEFAULT\Control Panel \International\sDate") Wscript.Echo dwcorrectValue Wscript.Echo dwcorrectValue2 If dwcorrectvalue = "yyyy-MM-dd" Then Set objShell = WScript.CreateObject("WScript.Shell") dwcorrectValue2 = objShell.RegRead("HKEY_USERS\.DEFAULT\Control Panel \International\sDate") Wscript.Echo dwcorrectValue2 If dwcorrectvalue2 = "-" Then GetdateStatus Else Getdateformat End If Sub GetdateStatus() wscript.echo "Date format is correct" Wscript.Echo dwcorrectValue Wscript.Echo dwcorrectValue2 wscript.sleep 1500 End Sub Sub Getdateformat() '================================================== 'Force the Date seperator and the short date format 'then force a reboot '================================================== ' '================================================== ' 'Change the sShortDate entry 'Change the sDate entry ' '================================================== strKeyPath="HKEY_USERS\.DEFAULT\Control Panel\International" strEntryName="sShortDate" Const HKEY_USERS = &H80000003 dwValue="yyyy-MM-dd" dwvalue2="-" strComputer="." Set oReg=GetObject( _ "winmgmts:{impersonationLevel=impersonate}!\\" &_ strComputer & "\root\default:StdRegProv") oReg.SetDWORDValue _ HKEY_USERS,strKeyPath,strEntryName,dwValue oReg.SetDWORDValue _ HKEY_USERS,strKeyPath,strEntryName,dwValue2 'Set OpSysSet = GetObject("winmgmts:{(Shutdown)}//./root/ cimv2").ExecQuery("select * from Win32_OperatingSystem where Primary=true") 'for each OpSys in OpSysSet ' OpSys.Reboot() Next End Sub Tag: vbscript msgbox 1023 character limit Tag: 203290
  - 10
    - Convert .net xmlhttp code to vbs Can you please help me to finish converting the .net code below into vbscript? My vbs function at the end works when posting to another asp file on the same win server, but I need to post the xml to a .jsp file on a unix box. The jsp file just returns an internal server error. It crashes with a null pointer exception when trying to read the request. Presumably because it is not in an ascii byte array? How do I do those parts? If it is too complex, then let me know and I will use the .NET code as a relay. I would just prefer to have it all in one file. .NET CODE ========= // create a web request and set the method of the request to POST HttpWebRequest request = (HttpWebRequest) HttpWebRequest.Create(requestLocation); request.Method = "POST"; // encode the data and store the byte representation in an array ASCIIEncoding encoding = new ASCIIEncoding(); string postdata="xml="+HttpUtility.UrlEncode(xmlDoc); // string postdata="xml="+xmlDoc; byte[] requestData = encoding.GetBytes(postdata); // set the content type of the data being posted. request.ContentType="application/x-www-form-urlencoded"; // set the content length of the string being posted request.ContentLength = postdata.Length; // Status.Text += "Submitting activity message"; Stream requestStream = request.GetRequestStream(); requestStream.Write(requestData,0,requestData.Length); // flush out the data to the underlying stream and close it requestStream.Flush(); requestStream.Close(); // retrieve the response from the web server HttpWebResponse response = (HttpWebResponse) request.GetResponse(); StreamReader responseData = new StreamReader(response.GetResponseStream()); err+= responseData.ReadToEnd(); MY VBS CODE =========== Function iXMLPostSTX(STX_URL, POXMLData, ByRef XMLResp) Dim oHttp Set oHttp = Server.CreateObject ("MSXML2.ServerXMLHTTP") Dim status oHttp.open "POST", STX_URL oHttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded" oHttp.setRequestHeader "Connection", "Keep-Alive" oHttp.send POXMLData status = oHttp.statusText iLog("Status=" & status) XMLResp = oHttp.responseText End Function Tag: vbscript msgbox 1023 character limit Tag: 203289
  - 11
    - HTA to create AD user account and mailbox Has anyone got or know where to download a HTA which will create a user account in active directory and a exchange 2000 mailbox? Tag: vbscript msgbox 1023 character limit Tag: 203281
  - 12
    - checking response from readline hi, I have the following code which asks user a question and gets response. I need to check response for validity but the following if statement is always evaluated as true even when correct response is entered: wscript.stdout.write "What is the SOURCE file type? (user/computer/group): " strSourceFileType = trim(ucase(wscript.stdin.readline)) if strSourceFileType <> "user" or strSourceFileType <> "computer" or strSourceFileType <> "group" then err.raise 449 ErrHandler end if Even when I enter "user" or "computer" or "group" (without quotes) at the prompt the condition evaluates as true and returns "Microsoft VBScript runtime error: Argument not optional" I have witten value of strsourcefiletype to screen and it is populated correctly with no spaces, etc. as expected by the condition right after it is read. Now if i simply specify: if strSourceFileType <> "user" then without the other two OR conditions and type "user" at the prompt all works fine. I don't understand why I cannot look for the other values in the field too. ??? thanks again. Tag: vbscript msgbox 1023 character limit Tag: 203280
  - 13
    - reading a file that has null or blank field hi, when reading through a CSV file and a field is missing I receive a run time error. I have the on error resume next commented out for now during debugging. But, how do I handle if a field is missing when trying to assign the array? In this case would missing mean "NULL"? The code is as follows: set objFSO = CreateObject("Scripting.FileSystemObject") set objSourceFile = objFSO.OpenTextFile(strSourceFilename, ForReading) if err <> 0 then ErrHandler do until objSourceFile.AtEndOfStream arySourceFields = split(objSourceFile.ReadLine,",",-1,1) if err <> 0 then ErrHandler wscript.stdout.write arySourceFields(0) '''remove. loop . . . Example of csv file contents: 500,world,1,1,5 501,now,2,6,0 . . . 600,,, 601 the problem occurs for records like 601 above. notice there are no commas seperating other fields. the csv just has first field and nothing in remaining fields like rest of records. Code works fine for all other instances including 600,,, Assigning arySourceFields(x) to any variable or simply doing the stdout.write above causes runtime of: createfiles.vbs(102,1) Microsoft VBScript runtime error: Subscript out of range: 'wscript.stdout' How do I prevent the error from occuring in my code without the on error resume next? Isn't there a function that would check to see if the subject is valid? Thank you. Tag: vbscript msgbox 1023 character limit Tag: 203279
  - 14
    - I am having a problem with a logon script using VBscript trying to the computer name to the organizational unit in which it belongs. Dim objSystemInfo, objNetwork, CurrentComputer Dim strOu Const OrgUnit = "OU=PCBMRDD" Set objSystemInfo = CreateObject("ADSystemInfo") Set CurrentComputer = GetObject("LDAP://" & objSystemInfo.ComputerName) strOu = (Join(CurrentComputer.MemberOf)) If InStr(strOu, (OrgUnit)) Then WScript.Echo "Hello" End if Wscript.Echo "Not found" WScript.Quit I am trying to use the computername of the PC and compare it to which organizational unit belongs to. I am then going to map a drive based on the organizational unit the PC belongs to and map it to a specific location. When using the Echo statement after the GetObject statement I am able to display all the active directory information for the ComputerName. When I compile the code it will not check to see whether the computer name belongs to a specific organizational unit. Tag: vbscript msgbox 1023 character limit Tag: 203276
  - 15
    - check if file open hi, I have the following code that writes to a text file. set objDestinationFile = objFSO.CreateTextFile(strDestinationFilename,true) . . . objDestinationFile.WriteLine FileTypeVal & "," & FileTypeVal After I write lines to the file and when a field changes I need to close the file and create a new one for writing. How do I check to see if the file is open by my code so that I can issue a close? If it isn't open I don't want to close it, I just want to create new file. The only time it wouldn't be open is the first time the script executes. Would doing the following accomplish my goals and be correct? if isobject(objDestinationFile) then objDestinationFile.Close After I issue close do I need to set the object variable to nothing or can I simply issue above set again. thanks alot Tag: vbscript msgbox 1023 character limit Tag: 203275
  - 16
    - move users from AD I amusing thhis script On Error Resume Next Set fso = CreateObject("Scripting.FileSystemObject") Set objFileIP= FSO.OpenTextFile(".\IP_Users_Groups.txt", 1) Set objFileOP = FSO.opentextfile(".\OP_Users_Groups.txt",2,True,-2) Const ADS_PROPERTY_DELETE = 4 Do While objFileIP.AtEndOfStream = False username,grpname =(objFileIP.ReadLine) Set objGroup = GetObject _ ("LDAP://CN=" & (grpname) & ",OU=Dept_Grps,ou=cam,ou=im,dc=nam,dc=nsroot,dc=net") objGroup.PutEx ADS_PROPERTY_DELETE, _ "member",Array("CN=" & (username) & ",OU=Dept_Grps,ou=cam,ou=im,dc=nam,dc=nsroot,dc=net") objGroup.SetInfo Loop WScript.Echo username & grpname '************************************************************************** objfileip.close objfileop.close WScript.Quit My problem is there will be different users anf group, will the following work Do While objFileIP.AtEndOfStream = False username,grpname =(objFileIP.ReadLine) I will have a text file with username, groupname - how will the LDAP know where to go. Do I use teo text files instaed of one? Tag: vbscript msgbox 1023 character limit Tag: 203272
  - 17
    - Ad Disable Accounts We are in the need for a script that will search a dump .xls file and disable AD accounts. Can any one please help on this. Thanks Tag: vbscript msgbox 1023 character limit Tag: 203270
  - 18
    - Write excel functions with VBSCRIPT Hellow all, I want to write an expression to sum values of a column like that: objExcel.Cells(1,5).value = "=SUM(D:D)" After vbscript write in the worksheet an error its returned. I dont think thats is an error, because the expression its ok and when I edit the cell and press enter, for example, the correct value is showed. I tried to add chr(13) or chr(10) at the end of string but not work. Anyone have a suggestion? Thanks in advance, StÃ©fano Terci Gasperazzo Tag: vbscript msgbox 1023 character limit Tag: 203269
  - 19
    - Deactivating the User must change password on next logon Hi guys! Would really appreciate your help. We have an AD 2003 domain setup, similar to below. topleveldomain.com Retail OU Brand1 OU Store0001 OU Users OU User accounts in here 0001user bob jane Store0002 OU Users OU User accounts in here Store0003 OU Users OU User accounts in here Brand2 OU Store0001 OU Users OU User accounts in here What we need to do quickly is the following: Query AD for all user accounts that dont start with the numbers, in the Users OU of every StoreXXXX OU in the Brand1 OU only, not the Brand 2 OU Query these user accounts to see if the property "User must change password on next logon" is checked. If it is checked, we need the vbs script to uncheck it for every user account in the OU. Any help greatly appreciated. x Tag: vbscript msgbox 1023 character limit Tag: 203261
  - 20
    - XML, VBScript, and HTA royal rumble I just started working with XML. However, I have been working with HTAs and VBScripts for a while now. I am building an HTA that would generate data into an XML file, and display it in a Data Island (which I found is the easiest way to display it in this case.. since there would an X number of data sources, with the same XML format). The problems came when I had to filter the XML data to show only a certain criteria. I could not embed XQuery code into the document as I am not sure if there is a way to get the XQuery and Data Island to work together to produce only a limited record set in the output table. I then started looking at multidimensional array sorting and class creation and sorting, I felt as though my mind was frying. XQuery seems much easier but there was no easy way to use it since the Data Island itself is a dynamic table with a dynamic data source spanning different data types. I thought probably the best way to achieve a filtered XML would be to obtain a XQuery application (a small portable parser) that would run against the original XML file producing a newer modified XML with the needed data. I could not find such an application. Has anyone got an efficient solution to such a problem? Thank you for your time. - Nasser Tag: vbscript msgbox 1023 character limit Tag: 203260
  - 21
    - Obtain User SID from AD I need to obtain the User's SID's out of AD, but my script exits the loop after the echo statement during the first loop thru and doesn't return and presents a exit code of '0', which is success (which its not). Any other ideas?? I obtained the following code from: http://msdn2.microsoft.com/en-us/library/aa746535.aspx and http://msdn2.microsoft.com/en-us/library/aa746409.aspx Set objUser = GetObject("WinNT://" & strFQ_DomainName & "/" & objRecordSet.Fields("sAMAccountName")) arrUserSID = objUser.Get("ObjectSID") intElements = UBound(arrUserSID) Wscript.echo intElements ---> outputs 27, which is correct For intCounter = 0 to intElements wscript.echo "Loop: " & intCounter strUserSID = arrUserSID(intCounter) Next Tag: vbscript msgbox 1023 character limit Tag: 203257
  - 22
    - how to update binary field types in ADO Hi, Having some difficulties updating binary fields. This bit of code seems to work fine in VB6, but when I make the minor changes necessary for it to run in VBscript the Update never happens. In fact the assigment to fld.Value doesn't appear to happen since msgbox fld.Value(0) after the assignment does nothing. Is this something that is beyong the capabilities of VBscript? Thank You! Dim arrBin(7) As Byte Dim b As Integer Dim strBin As String strBin = "bintest" For b = 1 To 7 arrBin(b - 1) = Asc(Mid(strBin, b, 1)) Next While Not oRs.EOF For Each fld In oRs.Fields lngtype = fld.Type Select Case lngtype Case adBinary, adVarBinary, adLongVarBinary fld.Value = arrBin oRs.Update End Select Next oRs.MoveNext Wend Tag: vbscript msgbox 1023 character limit Tag: 203254
  - 23
    - SMS componets Are there any components for VBScript that will allow me to send an sms message? Thank you, Matthew Tag: vbscript msgbox 1023 character limit Tag: 203253
  - 24
    - "Internal Error 2738" due to corrupt vbscript dll? I'm trying to install a small program just released by Microsoft. Everytime i get "Internal Error 2738" after setup starts. The installer log gives this reason: "DEBUG: Error 2738: Could not access VBScript runtime for custom action". Can anyone say more? No one else seems to have this problem installing the app, so i think it must be on my machine alone. How do i check access or run a reinstall of the "vbscript runtime"? Is that a .dll that's somehow corrupted? Tag: vbscript msgbox 1023 character limit Tag: 203250
  - 25
    - Looping... I am looking for a way to pause a LOOP long enough to display the results before moving on to the next go around. In the immediate window I can see the results are there, just happening to fast to see results in form. Tag: vbscript msgbox 1023 character limit Tag: 203249
- Next
  - 1
    - OBD Explorer HTA application , logic in VBScript Make OBD acquisition from car with mobydic interface. Works in debug mode without the interface ;) Environnemetn : Internet Explorer in HTA mode, VBScript and REALTERM a terminal software It 's an exemple of data acquistion over serial protocol in VBScript Using ActiveX/COM , WSH for disk access, XML for saving results SVG for display it http://perso.orange.fr/promethee60/data/technos/obd/OBDExplorer.html IE is Great !! Tag: vbscript msgbox 1023 character limit Tag: 203248
  - 2
    - connecting to NON-Microsoft LDAP I'm trying to connect to a NON-Microsoft LDAP server. Has anyone been able to connect to a NON-Microsoft LDAP coding in vbscript and using ADSI? I sure do appreciate your response to this. Tag: vbscript msgbox 1023 character limit Tag: 203247
  - 3
    - Where to start with vbscript? Hi all, I've been given a small fairly trivial project to automatically perform some operations on a spreadsheet like calculate days from dates and create charts. I've figured vbscript is a good option, I've seen code snippets that can get me most of what I need, but I'm wondering where there is say an API or some sort of users guid that will provide me with the info I need when I come across problems. Thanks Lionel. Tag: vbscript msgbox 1023 character limit Tag: 203246
  - 4
    - Script Editor Does anyone know of a VB Script Editor/Debugger that is similar to VBSEdit? I purchased VBSEdit and it crashed. I can't get their tech people to respond to emails and I'm ready to move on to something else. Tag: vbscript msgbox 1023 character limit Tag: 203239
  - 5
    - read user name and group from one text file. I have to remove different users and groups reading one file. I know how to do it with one but not both user and group. Can someone help me Tag: vbscript msgbox 1023 character limit Tag: 203236
  - 6
    - ipaddress How can I grab just the first three oectets of a ipaddress? Regualar expression...(/\d+\.\d+\.\d+\./) For example, 10.116.189.34 after running a script I need to only have the following: 10.116.189. Tag: vbscript msgbox 1023 character limit Tag: 203234
  - 7
    - Location-based Startup Script I would like to run a script at startup (and afeter hibernation) that checked my location, based on the network connection I get. From that, I would like to establish some defaults, like default printer. I don't know much about initiating this type of script, how to evaluate my network connection, and how to control default devices. If someone can point mem toward some tutorial-like info, I would appreciate it. Thanks, Tag: vbscript msgbox 1023 character limit Tag: 203224
  - 8
    - read from excel sheet OK I have to remove about 300 users from different groups. Column A would have the different user names and column B would have the different groups than I have to write the results to a txt file ot another excel file. Tag: vbscript msgbox 1023 character limit Tag: 203221
  - 9
    - VBScript and VB6 COM object type mismatch... Hi, Folks! I am trying to use a to use a COM object written in VB6. Set oSCNTool2 = CreateObject("SomeCompanyName.Tool2") This COM object has a property called "xml" where it expects, you guessed it, an XML string. Well, it turns out it's just expecting a plain string and not any special XML node or what-have-you. The problem is when I try to assign a string to this property I get a Type Mismatch error. oSCNTool2.xml = szXMLdata 'type mismatch error The problem is VBScript deals in Variants and VBS strings are of the Variant String subtype. This "xml" property is expecting the VB6 String variable type and not a Variant subtype. I do not have access to the source code of the COM object to change it. Does anyone know how to work around this issue? TIA... Tag: vbscript msgbox 1023 character limit Tag: 203218
  - 10
    - Detect a scheduled script timed out. I have a vbscript scheduled task that has the scheduled task timeout set to 2 hours. How can I make the script aware that it is about to be terminated? Is there a script event I can use to do this? Tag: vbscript msgbox 1023 character limit Tag: 203216
  - 11
    - browseforfolder to find file This code: Set oShell = CreateObject("Shell.Application") set oFolder = oShell.BrowseForFolder(0,"Select poem",BIF_BROWSEINCLUDEFILES + 1,5) Gives This Error the system cannot find the file specified Any thoughts??? Works great if I select a folder, dies if I select a file. works OK in VB6, fails in VBScript A Tag: vbscript msgbox 1023 character limit Tag: 203208
  - 12
    - Is there a limit on WMI connections from one computer? I have some scripts which use WMI to get system info of printers, RAM, serial no., etc... Right now I want to use 10 copies of each script as there are about 10,000 computers I need to scan and doing the whole lot at once would take too long, especially if I need a report overnight. So I cut them up into 10 scripts to run at the same time, hitting 1,000 computers each, with all 10 scripts being identical except for the computer names and IPs they read from an excel sheet. The issue I'm having is that there seems to be a one session limit on WMI, so I can't run 10 scripts on one computer. The first script runs fine, the second I run on the same computer just quits after a few seconds (viewing task manager I see two wscripts, then it goes to one). Is there a way around the limit, registry hack or something? Doing a google search got me nothing on this. Thanks for any help. Tag: vbscript msgbox 1023 character limit Tag: 203207
  - 13
    - Calling a WSH application where arguments refer to folder names that have spaces In an HTA file I have the code shown below. It used to run in a directory other than "My Report". The old folder name had spaces and there were no problems. When it runs in the "My Report" directory a message appears saying "System can not find the file specified". The string being sent to WSH.Run is: C:\My%20Folder\script.vbs "C:\My Report\a.txt" "C:\My Report\b.txt" Changing the string to C:\My%20Folder\script.vbs ""C:\My Report\a.txt"" "C:\My Report\b.txt"" and "C:\My%20Folder\script.vbs "C:\My Report\a.txt" "C:\My Report\b.txt" " and "C:\My%20Folder\script.vbs ""C:\My Report\a.txt"" ""C:\My Report \b.txt"" " and other permutations didn't work. What do I need to do? Thanks. <script language="VBScript"> Function CreateReport File1 = "C:\My Report\a.txt" File2 = "C:\My Report\b.txt" Set WSH = CreateObject("WScript.Shell") WSH.Run GetPath(document.location.pathname) & "my.vbs" & _ Chr(34) & File1 & Chr(34) & " " & _ Chr(34) & File2 & Chr(34) Window.Close End Function Function GetPath(Path) ix=InstrRev(Path,"\") Path=Left(Path,ix) GetPath = Path End Function </script> Tag: vbscript msgbox 1023 character limit Tag: 203198
  - 14
    - Moving through files in a directory I am a newbie to VBScript, so any help is appreciated. I am trying to move files from one location to another. I would like to look at each file and check to see if that file is already in the destination location. If it is in that location I would like to echo out the file name. Is there a way I can create an Object and go through the files one by one? Would I try to move them all first and if I get an error message, echo out the files and keep moving on? Here is what I have so far, but this is a crude way of accomplishing the task. 'MoveFSO.vbs 'Moves files from the jump drive to network shares Option Explicit Const OverwriteExisting = True Set objFSO = CreateObject("Scripting.FileSystemObject") objFSO.CopyFile "F:\class3\*.wmf" , "O:\WWW\" , OverwriteExisting objFSO.CopyFile "F:\class3\*.jpg" , "O:\WWW\" , OverwriteExisting objFSO.CopyFile "F:\class2\*.wmf" , "N:\WWW\" , OverwriteExisting objFSO.CopyFile "F:\class2\*.jpg" , "N:\WWW\" , OverwriteExisting Const DeleteReadOnly = True objFSO.DeleteFile("F:\class3\*.wmf"), DeleteReadOnly objFSO.DeleteFile("F:\class3\*.jpg"), DeleteReadOnly objFSO.DeleteFile("F:\class2\*.wmf"), DeleteReadOnly objFSO.DeleteFile("F:\class2\*.jpg"), DeleteReadOnly Tag: vbscript msgbox 1023 character limit Tag: 203197
  - 15
    - Moving through files in a directory I am a newbie to VBScript, so any help is appreciated. I am trying to move files from one location to another. I would like to look at each file and check to see if that file is already in the destination location. If it is in that location I would like to echo out the file name and the file. Is there a way I can create an Object and go through the files one by one? Here is what I have so far, but this is a crude way of accomplishing the task. 'MoveFSO.vbs 'Moves files from the jump drive to network shares Option Explicit Const OverwriteExisting = True Set objFSO = CreateObject("Scripting.FileSystemObject") objFSO.CopyFile "F:\class3\*.wmf" , "O:\WWW\" , OverwriteExisting objFSO.CopyFile "F:\class3\*.jpg" , "O:\WWW\" , OverwriteExisting objFSO.CopyFile "F:\class2\*.wmf" , "N:\WWW\" , OverwriteExisting objFSO.CopyFile "F:\class2\*.jpg" , "N:\WWW\" , OverwriteExisting Const DeleteReadOnly = True objFSO.DeleteFile("F:\class3\*.wmf"), DeleteReadOnly objFSO.DeleteFile("F:\class3\*.jpg"), DeleteReadOnly objFSO.DeleteFile("F:\class2\*.wmf"), DeleteReadOnly objFSO.DeleteFile("F:\class2\*.jpg"), DeleteReadOnly Tag: vbscript msgbox 1023 character limit Tag: 203196
  - 16
    - WMI for Querying "Obtain DNS Server Address Automatically" Does WMI provide any way to query whether "Obtain DNS Server Address Automatically" is set for a NIC? I know that you can set the value in WMI by calling SetDNSServerSearchOrder with no parameters. So you might think that you could just query DNSServerSearchOrder and get back something empty or null if "Obtain DNS Server Address Automatically" is set. But actually, DNSServerSearchOrder returns the DNS addresses that are currently assigned, so you can't tell if they were automatically assigned or manually assigned. Thanks for any help. -- Joseph Morales Tag: vbscript msgbox 1023 character limit Tag: 203194
  - 17
    - Event Log Query I've created a script that does the following: *All output goes to a text file* Searches through AD finding computer objects running a Server OS(using wildcards). Determines the disk space free on each physical drive for each machine found. For each machine found searches through the System and Application Log for all error entries in the past 8 days. Here is the script(it's not the prettiest and I know there are better ways/methods but here it is): Option Explicit Dim objFSA Dim objLogFile Dim objFSO Dim objLogItem Dim objFSF Dim objFinalLog Dim objFSU Dim objLog Const ForWriting = 2 Set objFSU = CreateObject("Scripting.FileSystemObject") Set objLog = objFSU.CreateTextFile("C:\deletefiles.vbs") Set objFSA = CreateObject("Scripting.FileSystemObject") Set objLogFile = objFSA.CreateTextFile("C:\tmpSrvAvail.txt") Set objFSO = CreateObject("Scripting.FileSystemObject") Set objLogItem = objFSO.CreateTextFile("C:\tmpAllSrv.txt") Set objFSF = CreateObject("Scripting.FileSystemObject") Set objFinalLog = objFSF.CreateTextFile("MasterFile.txt") objLog.Write "Set objFSL = CreateObject(" & chr(34) & "Scripting.FileSystemObject" & chr(34) & ")" objLog.Write vbCrlf objLog.Write "strScript = " & chr(34) & "C:\tmpAllSrv.txt" & chr(34) objLog.Write vbCrlf objLog.Write "objFSL.DeleteFile(strScript)" objLog.Write vbCrlf objLog.Write "Set objFSM = CreateObject(" & chr(34) & "Scripting.FileSystemObject" & chr(34) & ")" objLog.Write vbCrlf objLog.Write "Set objFSN = CreateObject(" & chr(34) & "Scripting.FileSystemObject" & chr(34) & ")" objLog.Write vbCrlf objLog.Write "strScript = " & chr(34) & "C:\tmpSrvAvail.txt" & chr(34) objLog.Write vbCrlf objLog.Write "objFSL.DeleteFile(strScript)" objLog.Write vbCrlf objLog.Write "strScript = Wscript.ScriptFullName" objLog.Write vbCrlf objLog.Write "objFSN.DeleteFile(strScript)" objFinalLog.Write "All Servers in Active Directory" objFinalLog.Write vbCrlf Const ADS_SCOPE_SUBTREE = 2 Dim objConnection Dim objCommand Dim objRecordSet Dim strDomain Set objConnection = CreateObject("ADODB.Connection") Set objCommand = CreateObject("ADODB.Command") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" strDomain = "DC=dms,DC=local" Set objCommand.ActiveConnection = objConnection objCommand.CommandText = _ "SELECT Name FROM 'LDAP://" & strDomain & "' WHERE objectClass='computer' " & _ "and operatingSystem = '*Server*'" objCommand.Properties("Page Size") = 1000 objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE Set objRecordSet = objCommand.Execute objRecordSet.MoveFirst Do Until objRecordSet.EOF objLogItem.Write objRecordSet.Fields("Name").Value objLogItem.Write vbCrLf objFinalLog.Write vbCrlf objFinalLog.Write objRecordSet.Fields("Name").Value objRecordSet.MoveNext Loop objFinalLog.Write vbCrlf objFinalLog.Write vbCrlf objFinalLog.Write "FREE DISK SPACE" objFinalLog.Write vbCrlf objFinalLog.Write vbCrlf Dim g_strHostFile Dim objFse Dim objTextStream Dim objWMIService Dim colDisks Dim g_strComputer Dim objDisk Const FOR_READING = 1 g_strHostFile = "C:\tmpAllSrv.txt" Set objFse = CreateObject("Scripting.FileSystemObject") If objFse.FileExists(g_strHostFile) then Set objTextStream = objFse.OpenTextFile(g_strHostFile, FOR_READING) Else WScript.Echo "Computer list, " & g_strHostFile & " not found." WScript.Quit End If Do Until objTextStream.AtEndOfStream g_strComputer = objTextStream.ReadLine On Error Resume Next Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & g_strComputer & "\root \cimv2") Set colDisks = objWMIService.ExecQuery _ ("Select * from Win32_LogicalDisk Where DriveType = 3") If Err = 0 Then objLogFile.Write g_strComputer objLogFile.Write vbCrLf End If Dim intFreeSpace Dim intTotalSpace Dim pctFreeSpace Dim intTotalGB Dim intFree For Each objDisk in colDisks intFreeSpace = objDisk.FreeSpace intTotalSpace = objDisk.Size pctFreeSpace = intFreeSpace / intTotalSpace If Err <> 0 Then objFinalLog.Write g_strComputer & " is offline, please check manually." objFinalLog.Write vbCrLf objFinalLog.Write vbCrLf Exit For End If intTotalGB = intTotalSpace/ 1024/ 1024/ 1024 intTotalGB = FormatNumber(intTotalGB, 1) & "GB" If intFreeSpace < 1073741824 Then intFree = objDisk.FreeSpace/ 1024/ 1024 Else intFree = objDisk.FreeSpace/ 1024/ 1024/ 1024 End If If intFreeSpace < 1073741824 Then intFree = FormatNumber(intFree, 1) & "MB" Else intFree = FormatNumber(intFree, 1) & "GB" End If objFinalLog.Write g_strComputer & " " objFinalLog.Write objDisk.DeviceID & " " objFinalLog.Write intFree & " Free " objFinalLog.Write intTotalGB & " Total " objFinalLog.Write FormatPercent(pctFreeSpace) & " Percent Free" objFinalLog.Write vbCrLf objFinalLog.Write vbCrLf Next Loop objTextStream.Close Dim dtmStartDate Dim DateToCheck Dim colLoggedEvents Dim objEvent g_strHostFile = "C:\tmpSrvAvail.txt" Set objFse = CreateObject("Scripting.FileSystemObject") If ObjFse.FileExists(g_strHostFile) Then Set objTextStream = objFse.OpenTextFile(g_strHostFile, FOR_READING) Else WScript.Echo "Computer list, " & g_strHostFile & " not found." WScript.Quit End If Const CONVERT_TO_LOCAL_TIME = True Set dtmStartDate = CreateObject("WbemScripting.SWbemDateTime") DateToCheck = CDate(Date()) dtmStartDate.SetVarDate DateToCheck - 8, CONVERT_TO_LOCAL_TIME Do Until objTextStream.AtEndOfStream g_strComputer = objTextStream.ReadLine Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & g_strComputer & "\root \cimv2") Set colLoggedEvents = objWMIService.ExecQuery ("Select * From Win32_NTLogEvent Where LogFile = 'System' AND TimeWritten >= '" & dtmStartDate & "' AND EventType = 1") If Err = 0 Then objFinalLog.Write "Error Events from System Log." objFinalLog.Write vbCrLf End If For Each objEvent in colLoggedEvents If Err <> 0 Then Exit For End If objFinalLog.Write g_strComputer objFinalLog.Write vbCrLf objFinalLog.Write "Category: " & objEvent.Category objFinalLog.Write vbCrLf objFinalLog.Write "Event Code: " & objEvent.EventCode objFinalLog.Write vbCrLf objFinalLog.Write "Message: " & objEvent.Message objFinalLog.Write vbCrLf objFinalLog.Write "Record Number: " & objEvent.RecordNumber objFinalLog.Write vbCrLf objFinalLog.Write "Source Name: " & objEvent.SourceName objFinalLog.Write vbCrLf objFinalLog.Write "Event Type: " & objEvent.EventType objFinalLog.Write vbCrLf objFinalLog.Write "Time Written: " & objEvent.TimeWritten objFinalLog.Write vbCrLf objFinalLog.Write vbCrLf Next Loop objTextStream.Close objFinalLog.Write VBCrLf objFinalLog.Write VBCrLf objFinalLog.Write "Error Events from Application Log." g_strHostFile = "C:\tmpSrvAvail.txt" Set objFse = CreateObject("Scripting.FileSystemObject") If objFse.FileExists(g_strHostFile) Then Set objTextStream = objFse.OpenTextFile(g_strHostFile, FOR_READING) Else WScript.Echo "Computer list, " & g_strHostFile & " not found." WScript.Quit End If Set dtmStartDate = CreateObject("WbemScripting.SWbemDateTime") DateToCheck = CDate(Date()) dtmStartDate.SetVarDate DateToCheck - 8, CONVERT_TO_LOCAL_TIME Do Until objTextStream.AtEndOfStream g_strComputer = objTextStream.ReadLine Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & g_strComputer & "\root \cimv2") Set colLoggedEvents = objWMIService.ExecQuery ("Select * From Win32_NTLogEvent Where LogFile = 'Application' AND TimeWritten >= '" & dtmStartDate & "' AND EventType = 1") For Each objEvent in colLoggedEvents If Err <> 0 Then Wscript.Echo "We made it here." & g_strComputer Exit For End If objFinalLog.Write vbCrLf objFinalLog.Write g_strComputer objFinalLog.Write vbCrLf objFinalLog.Write "Category: " & objEvent.Category objFinalLog.Write vbCrLf objFinalLog.Write "Event Code: " & objEvent.EventCode objFinalLog.Write vbCrLf objFinalLog.Write "Message: " & objEvent.Message objFinalLog.Write vbCrLf objFinalLog.Write "Record Number: " & objEvent.RecordNumber objFinalLog.Write vbCrLf objFinalLog.Write "Source Name: " & objEvent.SourceName objFinalLog.Write "Event Type: " & objEvent.EventType objFinalLog.Write vbCrLf objFinalLog.Write "Time Written: " & objEvent.TimeWritten objFinalLog.Write vbCrLf objFinalLog.Write vbCrLf Next Loop objTextStream.Close Wscript.Echo "Job Completed, check Master File for Output." On Error GoTo 0 Dim objShell Dim strDelete Set objShell = CreateObject("Wscript.Shell") strDelete = "C:\deletefiles.vbs" objShell.Run(strDelete) I was having problems deleting the files I create earlier in the script, hence the reason my script creates another one, which deletes the files and itself. My problem is that I need to run this is in multiple domains, for different clients. I do not believe this script will work correctly in a mixed environment ie running 2003 and 2000 Server OS's, which some of our clients have. Can someone advise me on how to get this to work in a mixed environment? Short of running a search on the 2000 machines, then another on the 2003 machines. Thanks. Tag: vbscript msgbox 1023 character limit Tag: 203193
  - 18
    - Finding multiple memgers of a group Hi, I am working on a script that will determin if three different ID's are in the local Administrators group on a long list of servers. I can get my script to reliably report on ONE user, but If I try fro more than one, I get mixed results and I can't trust the accuracy. Can someone point me to a sample script or discussion on finding multiple users in a group? This script will tell me if JoeUser is a memger of the Administrators group on a list of servers. Option Explicit Dim objGroup, strComputer, objFSO, objTextFile Const ForReading = 1 On Error Resume Next Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFSO.OpenTextFile("C:\Scripts\servers.txt", ForReading) Do Until objTextFile.AtEndOfStream strComputer = Trim(objTextFile.Readline) If (strComputer <> "") Then Set objGroup = GetObject("WinNT://" & strComputer & "/ Administrators,group") Wscript.Echo "Members of local Administrators group on computer " & strComputer Call EnumGroup(objGroup, "") End If Loop Sub EnumGroup(objGroup, strOffset) Dim objMember For Each objMember In objGroup.Members 'Wscript.Echo strOffset & objMember.Name & " (" & objMember.Class & ")" If (objMember.Name = "JoeUser") Then Wscript.Echo strOffset & objMember.Name & " (" & objMember.Class & ")" End If Next End Sub Tag: vbscript msgbox 1023 character limit Tag: 203192
  - 19
    - need help creating a VBS for an Excel file. I have an Excel file with a few worksheets in it. One of those worksheets contains data that is linked to a TXT file and another is linked to another Excel file. When I open the file it prompts to "Enable Automatic Refresh". I click yes, then I get two more prompts - one for each of the links mentioned above. Here's what I'm looking to do: I want a script that will open that file and automatically respond (in the affirmative) to those 3 prompts. I then want the file saved and copied into another location - so that when the user opens it, it is more or less "stale" data - in otherwords, it doesn't give them the option to automatically refresh. Is this possible? How? Help! Thanks! Glenn Tag: vbscript msgbox 1023 character limit Tag: 203188
  - 20
    - CDO.ReplyTo Method? Is there a CDO.ReplyTo Method? I would like the email to be From a NAME but I need to include an email address for them to reply to. For instance, I do not want it to show up as FROM: email@domain.com but rather FROM: NAME and then have them able to reply to the email. Thanks. Tag: vbscript msgbox 1023 character limit Tag: 203185
  - 21
    - Interfacing with Exchange Address Contact List Hi, I have written a VBScript that takes a tab delimited file of customer's contact information and loads it into a users contact list, and loads into distribution lists by state. This works great. The user runs the script, chooses the file's location, and it runs while their outlook is open. This is great except that it needs to be run relatively often as our customer base grows. Is it possible to schedule a VBScript to run at night that will run against a file and add it to specific user's contact list? Currently, Outlook must be open and it connects to the running account. Can i write something that does this without the user needing to be logged in? Thanks very much for your help. Tag: vbscript msgbox 1023 character limit Tag: 203181
  - 22
    - How to refresh the start menu? Is there a way to script a refresh of the start menu (including Windows XP and newer)? Iâ??m using start menu redirection and when my file share (where the shortcuts are located) goes down and up again, I can refresh my desktop (which is also redirected) to get my shortcuts back, but for the start menu I have to kill and restart the explorer process, which isnâ??t the nicest way. Surely there must be a way to refresh the start menu in another way? Tag: vbscript msgbox 1023 character limit Tag: 203178
  - 23
    - 0x80041001 accessing WMI from script Hello all, I am trying to use a vbs script that changes alert resolution state in MOM2005 SP1 using WMI ROOT\MOM, class MSFT_Alert. Script is here: http://msdn2.microsoft.com/en-us/library/ms812714.aspx For some object instances when I use command "Call objAlert.Put_" I got error "SWbemObjectEx: Generic failure". Also when I am trying to change resolution state value and save the object using wbemtest utility it shows me more error data: "Number: 0x80041001, Facility: WMI, Description: Generic failure". For some object instances script works ok WMIDiag from http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en says that "SUCCESS: WMIDiag determined that WMI works CORRECTLY". I tried to update only part of an instance, but it still fails: http://msdn2.microsoft.com/en-us/library/aa393949.aspx Related link: http://www.mombu.com/microsoft/mom-sdk/t-set-alert-resolution-state-put-method-fails-with-error-generic-failure-205225.html What this error means and how to resolve the issue? Mazhas Tag: vbscript msgbox 1023 character limit Tag: 203176
  - 24
    - Screen Refresh Im having a hard time getting a hta application to update the screen while processing. >From what i have read i should be using settimeout but i can not work out how. I must be just a dunce. The vbscript file just does a wscript.sleep for 5 seconds while i troubleshoot this issue. Any help will be greatfully received. gui-report.hta <html> <link type="text/css" href="gui-report.css" rel="stylesheet" /> <head> <title>GUI-Report</title> <HTA:APPLICATION ID="objHTAGUI-Report" APPLICATIONNAME="HTAGUI-Report" SCROLL="no" SINGLEINSTANCE="yes" WINDOWSTATE="normal" > <OBJECT width="0" height="0" classid="clsid: 550dda30-0541-11d2-9ca9-0060b0ec3d39" id="complist" VIEWASTEXT=""> </OBJECT> <body onload="Initialize();" onunload="Cleanup();" class="MainBody"> <script language="vbscript"> Dim fs, sh Const sCmdString = "cscript /nologo test.vbs " Const MaxForks = 1 'starts from zero (ie, 0 = one fork, 5 = six forks) Const MaxRunTime = 15 ' Seconds 'wshExec Const WshRunning = 0 Const WshFinished = 1 Sub Initialize() Dim xmlDoc Set xmlDoc = complist.XMLDocument Const THESETTINGS = "C:\work\xmlreport\test.xml" Set fs = CreateObject("Scripting.FileSystemObject") Set sh = CreateObject("Wscript.Shell") xmlDoc.Async=False if fs.FileExists(THESETTINGS) Then xmlDoc.load THESETTINGS Else xmlDoc.loadxml ("<?xml version=""1.0"" encoding=""utf-8"" ? ><computerlist><computer><Name>BLANK NAME</Name><Status></ Status><Reboot>0</Reboot><Enabled>-1</Enabled></computer></ computerlist>") End If End Sub Sub Window_Onload End Sub Sub ChangePointer If window.event.srcElement.id = "notesbuttonrun" Then notesbuttonrun.style.cursor="hand" ElseIf window.event.srcElement.id = "notesbutton" Then notesbutton.style.cursor="hand" End If End Sub Sub OK_OnClick Dim xmlDoc Set xmlDoc = complist.XMLDocument xmlDoc.save "test.xml" SetStatus "Saved!" End Sub Sub Load_OnClick Dim fso, oFile, sHTML, sFilename, rc Dim sLine, aLine Dim xmlDoc, sXML Set FSO = CreateObject("Scripting.FileSystemObject") sFilename = FileName.Value 'on error Resume Next Dim iLine If FSO.FileExists(sFilename) Then Set xmlDoc = complist.XMLDocument Set oFile = FSO.OpenTextFile(sFilename) sXML = "<?xml version=""1.0"" encoding=""utf-8"" ?><computerlist>" Do Until oFile.AtEndOfStream iLine = iLine + 1 SetStatus "Loading Line: " & iLine sLine = oFile.ReadLine aLine = Split(sLine, vbTab) If Len(aLine(0)) > 0 Then sXML = sXML & vbNewLine & "<computer><Name>" & aLine(0) & "</ Name><Status></Status><Reboot>0</Reboot><Enabled>-1</Enabled></ computer>" End If ' ' If isArray(aLine) Then ' Else ' sXML = sXML & vbNewLine & "<name>" & TypeName(aLine) & "</ Name><Status></Status><Reboot>0</Reboot><Enabled>0</Enabled>" ' End If Loop oFile.Close sXML = sXML & vbNewLine & "</computerlist>" rc = xmlDoc.loadxml (sXML) SetStatus "Loaded file: " & RC Else SetStatus "File Not Found" End If End Sub Sub SetStatus(sMsg) code.InnerHTML = "<textarea cols=100 rows=1>" & sMsg & "</textarea>" End Sub Sub cancel_OnClick TheStatus.Value = "Cancel" End Sub Dim aThreadInfo Dim iVal Sub CheckBool() SetStatus Now() window.clearTimeout iVal MsgBox "HH" ' iVal = window.setTimeout("CheckBool()", 100) End Sub Sub Process_OnClick Call ProcessTest() End Sub Sub ProcessTest Dim xmlDoc, xmlList, xmlComp SetStatus "Processing" Set xmlDoc = complist.XMLDocument Set xmlList= xmlDoc.SelectNodes("computerlist/computer") SetStatus TypeName(xmlList) Redim aThreadInfo(MaxForks, 2) Dim i For i = 0 To UBound( aThreadInfo, 1) Set aThreadInfo(i,0) = Nothing ' wshExec aThreadInfo(i,1) = 0 ' Time Set aThreadInfo(i,2) = Nothing ' xmlComp Next Dim xmlStatus, sEnabled, sCompName ' sEnabled = xmlComp.SelectSingleNode("Enabled").text ' If cBool(sEnabled) Then ' Else ' Set xmlStatus = xmlComp.SelectSingleNode("Status") ' xmlStatus.Text = "Disabled" ' End If Dim iThread For Each xmlComp in xmlList iVal = window.setTimeout("CheckBool()", 100) Set xmlStatus = xmlComp.SelectSingleNode("Status") SetStatus "Processing: " & xmlComp.SelectSingleNode("Name").text sCompName = xmlComp.SelectSingleNode("Name").text xmlStatus.text = sCompName sCommand = sCmdString & " /Workstation:" & sCompName iThread = -1 Do until iThread <> -1 iThread = GetNextThread() SetStatus "GetNextThread = -1" ' wscript.Sleep 100 Loop Set aThreadInfo(iThread,0) = sh.exec(sCommand) aThreadInfo(iThread,1) = Now() Set aThreadInfo(iThread,2) = xmlComp Do Until ProcessCheck() ' wscript.sleep 200 Loop Next Do Until ProcessCount()=0 'call ProcessCheck () Loop End Sub Dim idTimer Sub PausedSection() idTimer = window.setTimeout("PausedSection", 2000, "VBScript") End Sub Function GetNextThread ( ) Dim i GetNextThread = -1 For i = 0 to UBound( aThreadInfo, 1) If aThreadInfo( i, 1) = 0 then GetNextThread = i SetStatus "GetNextThread" & i Exit Function End if Next End Function Function ProcessCount() Dim i, t call ProcessCheck () t=0 For i = 0 to UBound(aThreadInfo) If NOT isNothing(aThreadInfo(i,0)) Then t=t+1 End If Next ProcessCount=t SetStatus "ProcessCount" & ProcessCount End Function Function ProcessFinished() Dim i ProcessFinished = True 'wscript.sleep 100 For i = 0 to UBound(aThreadInfo) If NOT isNothing(aThreadInfo(i,0)) Then ProcessFinished = False End If Next End Function Function ProcessCheck() Dim i, stdOut ProcessCheck = False 'wscript.sleep 100 For i = 0 to UBound(aThreadInfo) If isNothing(aThreadInfo(i,0)) Then 'Check those objects that are running ProcessCheck = True Else If aThreadInfo(i, 0).Status = WshRunning Then UpdateXMLStatus aThreadInfo(i, 2), Now() - aThreadInfo(i, 1) ' If Now-aThreadInfo(i,1) > MaxRunTime Then ' Call ProcessStdIO(aThreadInfo(i, 2), "Thread took longer than MaxRunTime") ' DebugPrint "Terminating thread " & i & " and processid " & aThreadInfo(i,0).ProcessID ' DebugPrint "Terminating thread Started:" & aThreadInfo(i,1) ' 'aThreadInfo(i,0).Terminate ' Run ".\kill.exe " & aThreadInfo(i,0).ProcessID ' wScript.Sleep 1000 ' Set aThreadInfo(i,0) = Nothing ' aThreadInfo(i,1) = 0 ' aThreadInfo(i,2) = vbNullString ' End If Else stdOut = vbNullString stdOut = aThreadInfo(i, 0).StdOut.ReadAll UpdateXMLStatus aThreadInfo(i, 2), "Completed" 'ProcessStdIO (aThreadInfo(i, 2), aThreadInfo(i, 0).StdOut.ReadLine) aThreadInfo(i, 1) = 0 Set aThreadInfo(i, 0) = Nothing Set aThreadInfo(i, 2) = Nothing ProcessCheck = True End If End if Next End Function Function isNothing(oTemp) If TypeName(oTemp)="Nothing" Then isNothing = TRUE End Function Function UpdateXMLStatus(oXML, sStatus) Dim xmlStatus Set xmlStatus = oXML.SelectSingleNode("Status") xmlStatus.Text = sStatus End Function Function ProcessCompThread (xmlComp) End Function </script> <title>Gui Report Title</title> </head> <body> <table border="0" width="100%"> <tr> <td width="50%">FileName:<input type="file" value="FileName" name="FileName" size="40"> <input type="button" value="Load" name="Load" class="button"></td> <td width="50%"><input type="button" value="Process" name="Process" class="button" size=50></td> </tr> <tr> <td width="50%"> <input type="button" value="OK" name="OK" class="button"><input type="button" value="Cancel" name="Cancel" class="button"></td> <td width="50%">ReportDir:<input type="text" value="ReportDir" name="ReportDir" size="50"></td> </tr> <tr> <td width="100%" colspan="2"> <div id="InsertBuildSelect"></div> <table cellspacing="1" cellpadding="2" id="actionheader" width="100%"> <tbody> <tr> <th width="300">Computer Name</th> <th width="250">Status</th> <th width="50">Enabled</th> <th width="50">Reboot</th> <th>output</th> </tr> </tbody> </table> <DIV STYLE="overflow: auto; width: 100%; height: 550; padding:0px; margin: 0px"> <table datasrc="#complist" width="100%" cellspacing="1" cellpadding="2" id="actionlist"> <tbody> <tr> <td width="300"><span datafld="Name"></span></td> <td width="250"><span datafld="Status"></span></td> <td width="50"><input type="checkbox" datafld="Enabled" style="width:12; height:12" /></td> <td><input type="checkbox" datafld="Reboot" style="width:12; height:12" /></td> </tr> </tbody> </table> </DIV> <table> <td width="100%" colspan="2"> <div ID=code_header></div> <div id="code"></div> </td> </table> </div> </td> </tr> </table> <input type="hidden" name="TheStatus" size="20"> </body> </html> test.xml <?xml version="1.0" encoding="utf-8"?> <computerlist> <computer><Name>ADMIN</Name><Status></Status><Reboot>0</ Reboot><Enabled>0</Enabled></computer> <computer><Name>ADMIN1</Name><Status></Status><Reboot>0</ Reboot><Enabled>0</Enabled></computer> <computer><Name>ADMIN2</Name><Status></Status><Reboot>0</ Reboot><Enabled>0</Enabled></computer> </computerlist> Tag: vbscript msgbox 1023 character limit Tag: 203173
  - 25
    - Sort multi-dimensional array using vb.net Hi all, I have a recordset (result after executing a SQL query) containing names of employees and their information. The [EmployeeName] column is in unicode. Due to limition of sorting unicode results in T-SQL, I would like to dump the recordset in an array and sort them according to the [EmployeeName]. Sample data will be as follows: [EmployeeNo]......[EmployeeName]......[Dept]......[Title] 193......Peter......Finance.....Manager 632......Amy......Marketing......(blank) 8765......Chris......Marketing......Clerk 87......John......HR......(blank) I guess the data should be put in an array (arr(no.ofRecords,4))similar to the one below: arr(0,0) = 193 arr(0,1) = Peter arr(0,2) = Finance arr(0,3) = Manager arr(1,0) = 632 .... I find it impossible to use the "sort" method in vb.net because it deals with 1-dimensional array only. May I know how to sort the above data in vb .net (2003) so I can have the [EmployeeName] in ascending order? I will need to display the rest of the information as well. Thanks very much. Tag: vbscript msgbox 1023 character limit Tag: 203172

this is for logon scripting -- I'm trying to make a message box with a
rather long message string in it but the msgbox function truncates my
message after 1023 -- the apparently character limitation for the
vbscript function. If I have a string that I want to display in a
msgbox but it is > 1023 characters, is there a way I can have the
msgbox function display that?

Top

Re: vbscript msgbox 1023 character limit by Ayush

Ayush
Wed Feb 28 22:17:59 CST 2007

internetsavant@gmail.com wrote ::
> If I have a string that I want to display in a
> msgbox but it is > 1023 characters, is there a way I can have the
> msgbox function display that?

WScript.Echo String

Good Luck, Ayush.
--
Regular Expression Syntax : http://snipurl.com/RegularExpr_Syntax

Top

Re: vbscript msgbox 1023 character limit by Michael

Michael
Wed Feb 28 22:29:08 CST 2007

internetsavant@gmail.com wrote:
> this is for logon scripting -- I'm trying to make a message box with a
> rather long message string in it but the msgbox function truncates my
> message after 1023 -- the apparently character limitation for the
> vbscript function. If I have a string that I want to display in a
> msgbox but it is > 1023 characters, is there a way I can have the
> msgbox function display that?

The WshShell.Popup method doesn't have that 1023 character limit...

with CreateObject("wscript.shell")
s = String(1023,"x") & "hello"
MsgBox s
.Popup s
End with

--
Michael Harris
Microsoft.MVP.Scripting

Top

Re: vbscript msgbox 1023 character limit by internetsavant

internetsavant
Thu Mar 01 22:28:25 CST 2007

On Feb 28, 8:29 pm, "Michael Harris \(MVP\)" <mikhar.at.mvps.dot.org>
wrote:
> internetsav...@gmail.com wrote:
> > this is for logon scripting -- I'm trying to make a message box with a
> > rather long message string in it but the msgbox function truncates my
> > message after 1023 -- the apparently character limitation for the
> > vbscript function. If I have a string that I want to display in a
> > msgbox but it is > 1023 characters, is there a way I can have the
> > msgbox function display that?
>
> The WshShell.Popup method doesn't have that 1023 character limit...
>
> with CreateObject("wscript.shell")
> s = String(1023,"x") & "hello"
> MsgBox s
> .Popup s
> End with
>
> --
> Michael Harris
> Microsoft.MVP.Scripting

Gents, thank you very much for your posts. oShell.Popup worked like a
charm. I do appreciate the prompt response. Cheers.

Top