script executed multiple times

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
    - Wordpad formatting My month-end reports come out looking like crap and I have to open each one in Wordpad and format them so it prints OK. [Page Setup landscape, Font=Courier New, 8; etc. I just found out about scripting this week. I've got it started below but I'm in way over my head....any help would be greatly appreciated. ------WIP-------- Option Explicit Dim shell Dim strFileName Dim strPrompt Dim strTitle Dim strDefault ' Check for a command-line argument If WScript.Arguments.Count Then ' Use the command-line argument for the file name. strFileName = WScript.Arguments(0) Else ' No command-line argument. Ask for a file name. strPrompt = "Enter the name of the file." strTitle = "Report File" strDefault = "Monthend1.rpt" ' propose a name strFileName = InputBox(strPrompt, strTitle, strDefault) ' If the user clicks Cancel or enters nothing, exit. If strFileName = "" Then WScript.Quit End If End If ' Start Wordpad with the specified file. Set shell = CreateObject("WScript.Shell") shell.Run("Wordpad " & strFileName) shell.AppActivate "Wordpad" WScript.Sleep 100 ' allow time for Wordpad to get going ' Format the file. shell.SendKeys "^A" ' select all shell.SendKeys "%oFCourier New{TAB}Regular{TAB}8{TAB}~" 'Format Courier New Size=8 shell.SendKeys "%Fu{TAB}{TAB}a{TAB}.5{TAB}.5{TAB}.5{TAB}.5{TAB}~" ' Format page setup 'shell.sendkeys "%FA" & strFileName 'shell.sendkeys ".rtf~" shell.sendkeys "^S" ' Save the file Tag: script executed multiple times Tag: 175457
  - 2
    - "Merging" Excel spreadsheets I have created a vbscript that will scan an entire domain of computers, and report a certain value about each one of these computers (ie the version of a particular software installed). The script writes the data an Excel spreadsheet. Because certain computers are not always on and the data is changing, its difficult to get a full picture of the status of things with only a snapshot of what's out there at any given time. So what I would like to be able to do is take a previous spreadsheet and combine it with the current report. The format of the spreadsheet is: Computer1 Value1 Computer2 Value1 Computer3 Value2 ...and so on. I would like to know how to tell Excel preferably through vbscript, to match and discard redundant values, and to keep differing values only from the current report. So in the script I could specify a previous spreadsheet, and using the example above, if the current value of "Computer1" now is "Value2", and Computer2 is off, the spreadsheet will show the new value of Computer1, and show the previously recorded value of Computer2. This way I could keep a running tab of how an upgrade is going for an example. Any help would be greatly appreciated. Tag: script executed multiple times Tag: 175455
  - 3
    - Script to send each jpg in a directory as a separate email I'm trying to figure a way to have a script send the first jpg in a directory by e-mail to a recipient and the jpeg as a separate e-mail. Or to put it another way; if there are five jpgs in a directory to have a script send each of them as a separate email to the same recipient. LW Tag: script executed multiple times Tag: 175454
  - 4
    - SoftArtisans.SAFile.1 error '80020009' I've tried everything to find this error. SoftArtisans.SAFile.1 error '80020009' Error occurred when moving cached file to final destination. Please check the NTFS permissions for the directory "E:\temp\" and the directory containing the file "D:\WWWRoot\rbuycom\www\Images\PropertyPhotos\190.gif". These directories require Read, Write and Delete permissions by the anonymous user ( NT account: IUSR_computername ) as well as for your authenticated users. /Forms/uploadphotopdo.asp, line 58 SCRIPT: PropertyPhotoId = RS("PropertyPhotoId") RS.Close Set RS = Nothing Line58 upl.SaveAs Server.MapPath("/Images/PropertyPhotos/") & "\" & PropertyPhotoId & "." & fileSuffix End If Else Err.Raise 2001, "Photo Limit Reached", "You may only upload five photos per property. You have reached that limit for this property." End If Set fso = Nothing Else Err.Raise 2000, "Missing Photo Link", "You failed to include a photo to upload. Use your back button to return to the previous page and try again." End If%> Tag: script executed multiple times Tag: 175440
  - 5
    - Microsoft VBScript compilation error '800a03f6' I need help with this error: Microsoft VBScript compilation error '800a03f6' Expected 'End' /Includes/MediatorFooter.asp, line 66 SCRIPT: </body> <%function getLastUpdatedDate set fso = CreateObject("Scripting.FileSystemObject") set fil = fso.GetFile(Server.MapPath(Request.ServerVariables("SCRIPT_NAME"))) getLastUpdatedDate = DateValue(fil.DateLastModified) End Function%></html> Thanks, Charles Tag: script executed multiple times Tag: 175439
  - 6
    - Client script: Adding Computer Accts to OU from the client. I recently worked on an XP migration project where they used a script that enabled an administrator to place a computer account into an OU from the client side. This is obviously very valuable to administrators because it eliminates the backend hassle of deployments. After the usual Sysprep startup process completed, a screen would list all of the OUs for the company. The tech would select the appropriate OU and then the computer account would be added to that OU. I am looking for a script or application that would provide this feature. The company would not comment on how they accomplished the task. Assumingly, this script would be executed as a â??Runonceâ?? component of Sysprep and reside on a share rather then the image. Tag: script executed multiple times Tag: 175436
  - 7
    - check all servers for event 6005 i get no output when polling servers located in my text file ServerList.txt if i use objServerList = "server1" or objServerList = "." i get the date and time stamp in an excel spreadsheet. any help will be much appreciated. thnx DJ +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Dim colEvents, objEvent, strEventID, objServerList, objServerEventLog, objXL Const conForReading=1, conForWriting=2, conForAppending=3 'Setup Excel spreadsheet row = 1 set objXL = WScript.createObject("Excel.Application") objXL.workbooks.add objXL.cells(row,1).value = "ComputerName" objXL.cells(row,2).value = "EventCode" objXL.cells(row,3).value = "TimeGenerated" objXL.cells(row,4).value = "message" 'Search System Event Logs for an specific Event ID strEventID = InputBox("Enter the Event ID to search for: ", "System Event Logs", "6005") 'Input and Output File Locations Set objFSO = CreateObject("Scripting.FileSystemObject") 'Read Server Names from a text file Set objServerList = objFSO.OpenTextFile("C:\temp\ServerList.txt",conForReading) 'objServerList = "server1" 'objServerList = "." 'Collect Event ID's from ServerList Set colEvents = GetObject("WinMgmts://" & objServerList & "/root/cimv2").execQuery("select * from win32_ntlogevent where logfile='system' and eventcode="& strEventID) For Each objEvent In colEvents ' Write the values into the Excel spreadhseet row=row+1 objXL.cells(row,1).value = objEvent.ComputerName objXL.cells(row,2).value = objEvent.EventCode objXL.cells(row,3).value = objEvent.TimeGenerated objXL.cells(row,4).value = objEvent.message objXL.cells(row,5).RowHeight = 12.75 Next 'Make Excel Visible objXL.Visible = True MsgBox ("Search is complete!") Tag: script executed multiple times Tag: 175428
  - 8
    - Hellp with temp file I have a Function to create a temp file to then, pipe to, to collect the response. It seems broke, under XP for some reason. I get the error when the file is created, so I am thinking that the error is in the code below; Dim fso, fldTemp, sTempName, filTemp Const TemporaryFolder = 2 Set fso = CreateObject("Scripting.FileSystemObject") Set fldTemp = fso.GetSpecialFolder(TemporaryFolder) filTemp = fso.GetTempName sTempName = fldTemp.Path & "\" & filTemp This script will run on WIN2K, when it is done :-) Tag: script executed multiple times Tag: 175423
  - 9
    - How to cancel an event (in the event) Hi I have an ActiveX component which generates an event when e.g. the user dbl. clicks on a row (similar to a ListView), in this ActiveX that means "acknowlede alarm". I would like to evaluate this action before it's actually executed and cancel it if some conditions is not meet. Do you have any "cancel" function which could be appropriate to cancel the event? regards Henry Tag: script executed multiple times Tag: 175420
  - 10
    - Whether a file is opened using notepad or not Hi! Say I have a file called c:\foobar.txt in my harddisk. I want to check using vbscript whether that particular file is currently opened using notepad or not. How will I acheive it? TIA, Karthick R Tag: script executed multiple times Tag: 175419
  - 11
    - Where to find a COMPLETE VBScript reference? I was looking for the SHELLEXECUTE command and it is not mentioned in any of the books I have. I have MS' "Windows 2000 Scripting Guide", O'Reilly's "VB.NET Language" Pocket reference book and other books, one which is called "The ULTIMATE VB.Net" (the emphasis on "ultimate" is mine...). None is mentioning that command. So who knows what else I am missing. Does anybody knows about a good, COMPLETE and well organized (alphabetically and categorized, etc. - which by definition excludes MSDN) reference source for both, VB and VBScript? Thanks, David Tag: script executed multiple times Tag: 175409
  - 12
    - include file asp i'm using the code like that: <% t= "../images/1/html/"&objRec("proHTMLabout") %>  but it give me : Error Type: Active Server Pages, ASP 0126 (0x80004005) The include file '<%=t%>' was not found. and the file is the and if i write what is in the t parameter it load the file. how do i include file dynamiclly? Tag: script executed multiple times Tag: 175408
  - 13
    - Newby question : How do I Search registery folder for a string ? Hi! I Need to find a Key (folder) of the registery holding a String which contains a substring. For example : under HKEY_LOCAL_MACHINE\SOFTWARE\MyCompany\MySW there is a Keys named VER_A and VER_B. VER_B has a string named "Description" The value of "Description" is "Better". I want to go over all Keys in Under HKEY_LOCAL_MACHINE\SOFTWARE\MyCompany\MySW, in each key I want to Look for a string named "description" and then if I found such a string see if it contains a substring named "better" (I do not care for capital letters). At the end of the process I need to get the key name (folder name). In this example my aim is to get the string "VER_B". Sorry if the description is complicated :-)) Thanks Maurice Tag: script executed multiple times Tag: 175403
  - 14
    - How can I uninstall a program (via VB Script of course) ? Hi! Currently I go to Control panel and remove the program via "Add remove programs". 1) How do I know if the program is installed ? 2) How do I uninstall it ? Thanks Maurice Tag: script executed multiple times Tag: 175400
  - 15
    - Help with vbs and html I have written a script to generate an HTML page, then useing a div object generate ping response to the html file. I have two problems, the first is that I cant figure out how to stop the command windows from popping up (which my fixes should have stopped), and second that the I cant figure out how to make the OK button on the generated HTML to kill the loop of the vbscript. My thought on the second would be to somehow get the generated HTML to call the script in a do while loop. My thanks to this great group Tag: script executed multiple times Tag: 175398
  - 16
    - send text to printer How do you simply send text to a printer?. Thanks. Tag: script executed multiple times Tag: 175396
  - 17
    - Using Task Scheduler via VBscript Programming the Task Scheduler at http://www.15seconds.com/issue/980513.htm shows how to control the windows task scheduler via vbscript. This sample relies on TaskScheduler.dll (a download from microsoft). The download says its compatable with win2000 only. Does anyone know if this is also compatible with XP? -- JL Tag: script executed multiple times Tag: 175392
  - 18
    - Using CDO to get mailbox sizes To all: I am using CDO to programatically obtain mailbox sizes for Exchange 5.5 mailboxes, following the "Extended MAPI" method described in Microsoft KB article http://support.microsoft.com/?id=320071. There is a subset of these mailboxes that do not have an oInfoStore.Name beginning with "Mailbox - " but instead have one named "Private Folders". The script fails when trying to use the technique to obtain its size. The code fails at the iSize = ... line. The code I'm using is: For Each oInfoStore In oInfoStores 'WScript.Echo oInfoStore.Name If ((InStr(1, oInfoStore.Name, "Mailbox - ", 1) <> 0) Or _ (InStr(1, oInfoStore.Name, "Private Folders", 1) <> 0)) Then On Error Resume Next iSize = oInfoStore.Fields(&HE080003) / 1024 If (Err.Number <> 0) Then WScript.Echo "Error " & CStr(Err.Number) WScript.Echo Err.Description iSize = -1 ElseIf (iSize >= 0) Then iSize = CLng(iSize) 'Convert to KB. Else 'If size is less than zero, then it's probably over 2GB, so add 4GB to it. 'This assumes that the size isn't over 4GB, in which case the result will be wrong. iSize = CLng(iSize) + 4194304 End If Err.Clear iNumMessages = oInfoStore.Fields(&H36020003) If (Err.Number <> 0) Then iNumMessages = -1 End If Err.Clear On Error GoTo 0 Exit For End If Next Have any of you seen this problem and, if so, can you explain it to me and offer a workaround? Tag: script executed multiple times Tag: 175384
  - 19
    - how to access cgi environment variables can't seem to find how accesss the standard cgi environment variables in vbscipt remote_addr, server_port, etc they are accessible right? Tag: script executed multiple times Tag: 175380
  - 20
    - How do I copy a folder to my CD drive? This is a multi-part message in MIME format. ------=_NextPart_000_001C_01C56353.F96728D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to write my first windows script to copy a folder to my CD = drive. I have managed to cobble together the following script but it gives me = an "Error: Incorrect function", "Code: 80070001" on the = "objFSO.CopyFolder" method. Any ideas would be appreciated, many thanks. Steve T Const CAT1 =3D "C:\Documents and Settings\All Users\Documents\Shared = Data" Const CD_Drive =3D "E:" Const OverWriteFiles =3D True Folders =3D Array(CAT1) =20 For Each Folder in Folders Set objFSO =3D CreateObject("Scripting.FileSystemObject") If objFSO.FolderExists(Folder) Then objFSO.CopyFolder Folder, CD_Drive, OverWriteFiles Else Wscript.Echo "Folder """ & Folder & """ does not exist!" End If Next ------=_NextPart_000_001C_01C56353.F96728D0 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.2627" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV>I am trying to write my first windows script to copy a folder = to my CD=20 drive.</DIV> <DIV> </DIV> <DIV>I have managed to cobble together the following script but it gives = me an=20 "Error: Incorrect function", "Code: 80070001" on the "objFSO.CopyFolder" = method.</DIV> <DIV> </DIV> <DIV>Any ideas would be appreciated, many thanks.</DIV> <DIV> </DIV> <DIV>Steve T</DIV> <DIV> </DIV> <DIV><EM>Const CAT1 =3D "C:\Documents and Settings\All = Users\Documents\Shared=20 Data"<BR>Const CD_Drive =3D "E:"<BR>Const OverWriteFiles =3D = True</EM></DIV> <DIV><EM></EM> </DIV> <DIV><EM>Folders =3D=20 Array(CAT1)<BR>         &nbs= p;     <BR></EM><EM>For=20 Each Folder in Folders<BR>    Set objFSO =3D=20 CreateObject("Scripting.FileSystemObject")<BR>    If=20 objFSO.FolderExists(Folder)=20 Then<BR><STRONG>        = objFSO.CopyFolder=20 Folder, CD_Drive, OverWriteFiles<BR></STRONG>   =20 Else<BR>        Wscript.Echo "Folder = """=20 & Folder & """ does not exist!"<BR>    End=20 If<BR>Next<BR></EM></DIV></BODY></HTML> ------=_NextPart_000_001C_01C56353.F96728D0-- Tag: script executed multiple times Tag: 175370
  - 21
    - Parsing Irregualar delimitted Strings Hey guys, I was wondering what the best possible way it would be to parse a string that is delimitted irregularly. Basically, I'm going to parse a log file that will contain a nodename, but the naming convention for the server varies...ie: CLIN - DATACOM1 FOCUS - TESTSVR1 FCGSVR2 As you can see, some of the nodes are delimitted by a "-" and some are not... The purpose of parsing this string will be to extract the client name from the server. I'm needing to parse the client name from the server and see if it matches in an array and have it output to a specific queue. As an example, FCGSVR2 ** FCG would be the client in this instance CLIN - DATACOM1 ** CLIN would be the client here Is this possible at all? Fast replies would greatly be appreciated... project deadline is near..and i'm stumped! This is what I have so far: myarray = Split("BRMC - RME-A ") Dim ClientArray (5) ClientArray(0) = "AHA" ClientArray(1) = "AVH" ClientArray(2) = "BRMC" ClientArray(3) = "CCS" ClientArray(4) = "FCG" ClientArray(5) = "FCGCORP" i=2 myfilterarray = Filter(myarray, ClientArray(i), True) msgbox Join(myfilterarray) --- How would I make it loop through the Array until myfilterarray returns a value that is true? Tag: script executed multiple times Tag: 175361
  - 22
    - Parsing Irregualar delimitted Strings Hey guys, I was wondering what the best possible way it would be to parse a string that is delimitted irregularly. Basically, I'm going to parse a log file that will contain a nodename, but the naming convention for the server varies...ie: CLIN - DATACOM1 FOCUS - TESTSVR1 FCGSVR2 As you can see, some of the nodes are delimitted by a "-" and some are not... The purpose of parsing this string will be to extract the client name from the server. I'm needing to parse the client name from the server and see if it matches in an array and have it output to a specific queue. As an example, FCGSVR2 ** FCG would be the client in this instance CLIN - DATACOM1 ** CLIN would be the client here Is this possible at all? Fast replies would greatly be appreciated... project deadline is near..and i'm stumped! This is what I have so far: myarray = Split("BRMC - RME-A ") Dim ClientArray (5) ClientArray(0) = "AHA" ClientArray(1) = "AVH" ClientArray(2) = "BRMC" ClientArray(3) = "CCS" ClientArray(4) = "FCG" ClientArray(5) = "FCGCORP" clientString = join(ClientArray) ' not sure if this is even correct... I probally have to set up some kind of loop... but I'm totally lost... myfilterarray = Filter(myarray, clientString, True) msgbox Join(myfilterarray) I know this is a newbie question, but how do I convert the ClientArray Array into a string that the filter can use (clientString) ? Tag: script executed multiple times Tag: 175359
  - 23
    - active x control I wrote vbscript to open word doc and print some text and close the word. Can I do that using active x control so that I can hide the vbscript codes I wrote? Thanks Daniel Tag: script executed multiple times Tag: 175353
  - 24
    - executing vbscript codes twice The vbscript code is executed twice when I click the print button to print some text after invoking ms word. I assume that I need to write some code so that the code that invoke ms word, etc, would not be executed at the load time, but execute only when the button is clicked. I am having onclick routine in the header script tag. What could be the condition and codes I need to put it so that vbscript would be executed only once? Thanks Daniel Tag: script executed multiple times Tag: 175352
  - 25
    - Enumerate Servers I would like to build a list of servers from our current domain and feed into scripts. How do I enumerate servers from the domain? Thanks Tag: script executed multiple times Tag: 175350
- Next
  - 1
    - wscript.shell -> RegDelete () Hi everybody, How would I delete a registry value with a name "abc\def\ghi" using RegDelete(). Having a back slash in the names makes the RegDelete() think that it is a registry key hierarchy an not a value name. Regards, Sajan Tag: script executed multiple times Tag: 175344
  - 2
    - Copy file from one computer to hall the computers in my Lan Hy First sorry for my bad ingles (Iâ??m Portuguese) Y have a big problem and y need so solve son y cant 1Âº Y have a file (xxxxx.ini) in my server, and y need copy the file to the computers in my LAN 2Âº This file need copy to the (System Root) of the computers 3Âº I have a file calls computers.txt where y put all de computers in my land 4Âº If the file donâ??t enter in the computer, I need to receive an e-mail So, itâ??s possible to have a script to calls the computers.txt and copy de file to the computers, and receive a e-mail end a error occurs. Thanks for your help, Tag: script executed multiple times Tag: 175337
  - 3
    - Reading *.msg files stored in a directory without using outlook ob How to read *.msg files stored in a directory without using outlook object? The script should be able to read the message header, content and download attachment, if any. Tag: script executed multiple times Tag: 175329
  - 4
    - Enumerate AD Computer Description Hello, I'm modifying a web page to display all active directory computer names along with their descriptions, os versions and service packs. All of the values return correctly except "description". That value returns a "type mismatch" error on the page. If I comment out this line: response.write "<br>Desc : "&description Then it works fine. It seems that "description" is multi-value and must be handled differently then "name" and "operatingSystemVersion". How would I modify the code accordingly? Thanks ----- <%Option Explicit%> <HTML> <BODY> <% Const ADS_SCOPE_SUBTREE = 2 dim objconnection dim objcommand dim objRecordSet dim name dim description dim operatingSystemVersion dim operatingSystemServicePack Set objConnection = CreateObject("ADODB.Connection") Set objCommand = CreateObject("ADODB.Command") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" Set objCommand.ActiveConnection = objConnection objCommand.CommandText = _ "SELECT Name, description, operatingSystemVersion, operatingSystemServicePack FROM 'LDAP://DC=domain,DC=com'" _ & " where objectClass='computer'" objCommand.Properties("Page Size") = 1000 objCommand.Properties("Timeout") = 30 objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE objCommand.Properties("Cache Results") = False Set objRecordSet = objCommand.Execute objRecordSet.MoveFirst Do While not objRecordSet.EOF name=objRecordSet.Fields("Name").value description=objRecordSet.Fields("description").value operatingSystemVersion=objRecordSet.Fields("operatingSystemVersion").value operatingSystemServicePack=objRecordSet.Fields("operatingSystemServicePack").value response.write "<br>Name : "&name response.write "<br>Desc : "&description response.write "<br>OS : "&operatingSystemVersion response.write "<br>SP : "&operatingSystemServicePack response.write "<br>" objRecordSet.MoveNext Loop 'response.write objRecordSet.EOF %> </BODY> </HTML> Tag: script executed multiple times Tag: 175325
  - 5
    - Help with Right function nnanna wrote: > *SAMPLE FILE IS:* > > 13301794560@133SH.COM > 13301794560@133SH.COM > 2205171@MCIMAIL.COM > 35988869625@SMS.MTEL.NET > > *DESIRED RESULT: > > 133sh.com > MCIMAIL.COM > sms.mtel.net > > When I use the [B]Right* function to get the strings right of "@" it > doesn't give me the desired result, the *Left* function does > give strings right of "@". Any ideas? > > CODE > > '############################################################################################## > '############################################## > > 'Textfile to read > sInpFile = "C:\WindowsScripts\vbscript\ExcelList\ListItems.txt" > > 'Result file > sResultFile = "C:\WindowsScripts\vbscript\ExcelList\clean.txt" > > 'Character to search > strInput = "@" > > ' FileSystemObject.CreateTextFile > Const OverwriteIfExist = -1 > Const FailIfExist = 0 > > ' FileSystemObject.OpenTextFile > > Const FailIfNotExist = 0 > Const ForReading = 1 > Const ForAppending = 8 > > > > Set oFSO = CreateObject("Scripting.FileSystemObject") > > ' Get list item names into an array: > Set f = oFSO.OpenTextFile (sInpFile,ForReading, FailIfNotExist, > OpenAsASCII) > > > > > Dim aListitem() > i = 0 > Do Until f.AtEndOfStream > sLine = Trim(f.ReadLine) > If Not sLine = "" Then > ReDim Preserve aListitem(i) > aListitem(i) = sLine > i = i + 1 > End If > Loop > f.Close > > ' Loop through the listitem array > > > ' Create result file > Set fOutputFile = oFSO.CreateTextFile(sResultFile,OverwriteIfExist, > OpenAsASCII) > > > > For Each sItem In aListitem > > kline = instr(sItem,strInput) > pline = left(sItem,kline) > fOutputFile.WriteLine pline > kline = 0 > > Next > 'fOutputFile.close > > wscript.echo "Process Complete" [/B] Never mind guys....I figured it out -- nnanna ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: script executed multiple times Tag: 175324
  - 6
    - How to write Binary data using VBScript? Hi, I need to dump some birary blogs into a biary file. How do I perform R/W operations on binary files using VB Script. - I checked FileSystemObject but it not supporting binary mode. (I may be wrong!) Thanks in advance. -- Srinivas Koppisetti Tag: script executed multiple times Tag: 175323
  - 7
    - WSH no longer works from ASP I migrated a web server from IIS 4 to IIS 6. The Windows Scripting Object, which I was using to copy a file, no longer seems to work. The script is as follows. It is embedded in an ASP page, which now returns "The page cannot be displayed" when it hits the WshShell.Run line. The code in question is as follows: 'Create a file handling object: Set FileSys = Server.CreateObject("Scripting.FileSystemObject") FileName = FileSys.GetTempName 'Create a Windows Scripting Host Object - Set WshShell = Server.CreateObject("WScript.Shell") 'Run this batch file with the WSH object - ret=WshShell.Run("F:\phonedbapps\NewPic.bat " & strPictureID & " " & FileName, 1, true) The batch routine NewPic.bat is run from an IIS directory with execute permissions: copy D:\tempwork\tempwork.jpg D:\pictures\%1.jpg ------------------------------------------------------------ I also experimented with using the File System Object from ASP, but it also returns "The page cannot be displayed" when it hits the line containing ScriptObject.MoveFile. The code is as follows: 'Create a file handling object: Const OverwriteExisting = True Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject") ScriptObject.MoveFile "//SRV1/tempwork/tempwork.jpq", "//SRV1/testwork/testwork.jpg" I'm now stumped and out of ideas. *** Sent via Developersdex http://www.developersdex.com *** Tag: script executed multiple times Tag: 175320
  - 8
    - Save Web Page with vb script Hi, Below is the code I created that reads from a text file, a hyperlink, for example http://yahoo.com. Then creates a URL shortcut. Is there any way in VBscript to save a web page automatically just like clicking on "file" and then "save as". I would like to read a url from a file and save the web page to my local drive just like clicking "file" and "save as" Const ForReading = 1 Set oFSO = CreateObject("Scripting.FileSystemObject") Set oShell = WScript.CreateObject ("WScript.shell") Set oInputFile = oFSO.OpenTextFile("links.txt", ForReading) arrInputData = Split(oInputFile.ReadAll, vbNewline) For each strData In arrInputData if strData = "" then strNull = strData else call createLink(strData) end if Next ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' sub createLink(Data) strLinkName = Data strfileName = SetFileName(strLinkName) set oUrlLink = oShell.CreateShortcut(strFileName & ".url" ) 'set oUrlLink = oShell.SaveAS(strFileName & ".htm" ) oUrlLink.TargetPath = strLinkName oUrlLink.Save end sub ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Function SetFileName(Name) temp = mid(Name,8) newString = "$" oldString = "/" setFileName = Replace(temp,oldstring,newString,1,-1,1) end function Tag: script executed multiple times Tag: 175315
  - 9
    - Help with Right function SAMPLE FILE IS:[/B] 13301794560@133SH.COM 13301794560@133SH.COM 2205171@MCIMAIL.COM 35988869625@SMS.MTEL.NET *DESIRED RESULT: 133sh.com MCIMAIL.COM sms.mtel.net When I use the [B]Right* function to get the strings right of "@" it doesn't give me the desired result, the *Left* function does give strings right of "@". Any ideas? CODE '############################################################################################## '############################################## 'Textfile to read sInpFile = "C:\WindowsScripts\vbscript\ExcelList\ListItems.txt" 'Result file sResultFile = "C:\WindowsScripts\vbscript\ExcelList\clean.txt" 'Character to search strInput = "@" ' FileSystemObject.CreateTextFile Const OverwriteIfExist = -1 Const FailIfExist = 0 ' FileSystemObject.OpenTextFile Const FailIfNotExist = 0 Const ForReading = 1 Const ForAppending = 8 Set oFSO = CreateObject("Scripting.FileSystemObject") ' Get list item names into an array: Set f = oFSO.OpenTextFile (sInpFile,ForReading, FailIfNotExist, OpenAsASCII) Dim aListitem() i = 0 Do Until f.AtEndOfStream sLine = Trim(f.ReadLine) If Not sLine = "" Then ReDim Preserve aListitem(i) aListitem(i) = sLine i = i + 1 End If Loop f.Close ' Loop through the listitem array ' Create result file Set fOutputFile = oFSO.CreateTextFile(sResultFile,OverwriteIfExist, OpenAsASCII) For Each sItem In aListitem kline = instr(sItem,strInput) pline = left(sItem,kline) fOutputFile.WriteLine pline kline = 0 Next 'fOutputFile.close wscript.echo "Process Complete" -- nnanna ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: script executed multiple times Tag: 175309
  - 10
    - OU security roles Can someone help me here...... trying to figure out how to do this.... It would be nice if I could get a report that gives for each OU, al defined security roles and for each security role, a list of th trustees assigned to it - twindud ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: script executed multiple times Tag: 175308
  - 11
    - sql query error The code is below. The issue I am having is if I query the database for a specific table and if it's not created I throw the following error: Microsoft OLE DB Provider for SQL Server: Invalid object name 'IB_Flags' I tried catching error using err object but it does not appear to catch the description or error number. How can either check for this error or check to see if the table even exists? Const Source = "BackOfficeMenu" CONST MSIF_LOGS_DIR = "C:\MSIF\LOGS\" CONST INSTALL_DEBUG_LOG = "IBDADS.log" ' File system CONSTants CONST ForReading = 1, ForWriting = 2, ForAppending = 8 'Alert categories CONST C = "Critical" CONST I = "Information" CONST W = "Warning" Set objFSO = CreateObject("Scripting.FileSystemObject") ' CREATE LOG If objFSO.FileExists(MSIF_LOGS_DIR & INSTALL_DEBUG_LOG) Then Set objFile = objFSO.OpenTextFile(MSIF_LOGS_DIR & INSTALL_DEBUG_LOG, ForAppending) Else Set objFile = objFSO.CreateTextFile(MSIF_LOGS_DIR & INSTALL_DEBUG_LOG, true) End If 'SQL connection string strCon = "Provider=sqloledb;Data Source=.;Initial Catalog=backoffice;User Id=sa;Password=password" ' Create the required ADO objects. Set conn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.recordset") ' Open the connection. conn.Open strCon SqlStatment() LogIt I, Source, "SQL query " & SqlStatment Set rs=conn.Execute(SqlStatment,1) strReturn=rs.eof LogIt I, Source, "ACES is " & strReturn 'Logic to copy menu over for a ACES enabled/disabled store If strReturn = 0 Then NewMenu("Enabled") Else NewMenu("Disabled") End If 'Cleanup conn.Close Set conn = Nothing Set rs = Nothing Set f1 = Nothing Set f2 = Nothing Function SqlStatment () '********************************************************* ' Name: SqlStatement ' Purpose: build SQL statement ' Returns: strSQL '********************************************************* strSQL = "Select Brand, Name, enabledate, disabledate from IB_Flags " 'strSQL = strSQL & "where Brand = 'BBW'" strSQL = strSQL & "where Name = 'ACES'" strSQL = strSQL & "and (enabledate <= getDate()) " strSQL = strSQL & "and ((disabledate is null) or (disabledate >= getDate())or (enabledate <> disabledate))" SqlStatment=strSql ' return SQL string to main End Function Function NewMenu (blnValue) '********************************************************* ' Name: NewMenu ' Purpose: copy menu.xml to c:\webapps\menu if a newer nenu exists ' Returns: '********************************************************* Const OverwriteExisting = True Const MENU_HOLDING_DIR = "C:\Webapps\menu\Holding\" Const MENU_DESTINATION_DIR = "C:\Webapps\menu\" Const MENU_HOLDING_ACESENABLED = "menu-ACES.xml" Const MENU_HOLDING_ACESDISABLED = "menu-nonACES.xml" Const MENU_NAME = "menu.xml" Set objFSO = CreateObject("Scripting.FileSystemObject") 'Set f2 = objFSO.GetFile(MENU_HOLDING_DIR & "menu-NonAces.xml") If blnValue = "Enabled" Then If objFSO.FileExists(MENU_HOLDING_DIR & MENU_HOLDING_ACESENABLED) Then Set f1 = objFSO.GetFile(MENU_HOLDING_DIR & MENU_HOLDING_ACESENABLED) Else LogIt W, Source, "Exiting script, " & MENU_HOLDING_DIR & MENU_HOLDING_ACESENABLED & " does not exist" WScript.Quit End If If objFSO.FileExists(MENU_DESTINATION_DIR & MENU_NAME) Then Set f2 = objFSO.GetFile(MENU_DESTINATION_DIR & MENU_NAME) Else LogIt W, Source, "Exiting script, " & MENU_DESTINATION_DIR & MENU_NAME & " does not exist" WScript.Quit End If If f1.size <> f2.size OR f1.DateLastModified <> f1.DateLastModified Then LogIt I, Source, "ACES enabled, files are different" objFSO.CopyFile MENU_HOLDING_DIR & MENU_HOLDING_ACESENABLED , MENU_DESTINATION_DIR & MENU_NAME, OverwriteExisting End If Else If objFSO.FileExists(MENU_HOLDING_DIR & MENU_HOLDING_ACESDISABLED) Then Set f1 = objFSO.GetFile(MENU_HOLDING_DIR & MENU_HOLDING_ACESDISABLED) Else LogIt W, Source, "Exiting script, " & MENU_HOLDING_DIR & MENU_HOLDING_ACESDISABLED & " does not exist" WScript.Quit End If If objFSO.FileExists(MENU_DESTINATION_DIR & MENU_NAME) Then Set f2 = objFSO.GetFile(MENU_DESTINATION_DIR & MENU_NAME) Else LogIt I, Source, "Exiting script, " & MENU_DESTINATION_DIR & MENU_NAME & " does not exist" WScript.Quit End If If f1.size <> f2.size OR f1.DateLastModified <> f1.DateLastModified Then LogIt I, Source, "ACES disabled, files are different" objFSO.CopyFile MENU_HOLDING_DIR & MENU_HOLDING_ACESDISABLED , MENU_DESTINATION_DIR & MENU_NAME, OverwriteExisting End If End If End Function '============================================================ sub LogIt(byVal strSeverity, strSource, strMessage) dim tempMsg tempMsg = Now & "|" & strSeverity & "|" & strSource & "|" & strMessage Wscript.echo tempMsg objFile.writeline tempMsg end sub '============================================================ Tag: script executed multiple times Tag: 175301
  - 12
    - Check if file is in use Is there a way to check if a file is in use with vbscript? Tag: script executed multiple times Tag: 175299
  - 13
    - VBS network install Script I want to do an install onto another computer over the network - this script is throwing up an eror saying I don't have permissions to access the IP specified in the script. I am therefore wanting to connect as the network admin, or local admin of that PC - how do I do this?? So far it is bumming out here Set oSvcRemote = GetObject("winmgmts:\\" & ip & "\root\cimv2", _ admin_user, admin_user_password) don't know if this is the correct way to do it?? Cheers ears ___________________________________ admin_user = "domain\someone" admin_user_password = "something" 'ipFile = path to list of hosts ipFile = "C:\scripts\installmsas\list.txt" 'execPath = path to executable file execPath = "C:\scripts\installmsas\msantispy.msi" 'execCommand = command to execute, including path, switches, etc execCommand = "msiexec.exe /i c:\msantispy.msi /qn INSTALLDIR=c:\MSAS\" execCommand2 = "C:\msas\gcasDtServ.exe /regserver" 'fileName = filename of executable fileName = "msantispy.msi" 'pathToLog = path to the logfile pathToLog = "C:\scripts\installmsas\install_log.txt" On Error Resume Next Set oNet = CreateObject("WScript.Network") Set oFS = CreateObject("Scripting.FileSystemObject") Set oSvcLocal = GetObject("winmgmts:root\cimv2") Set oIPFile = oFS.OpenTextFile(ipFile, 1, false) Set oOutputFile = oFS.CreateTextFile(pathToLog, TRUE) If (Err.Number <> 0) Then WScript.Echo "Cannot open " & ipFile WScript.Quit End If While Not oIPFile.atEndOfStream ip = oipFile.ReadLine() oOutputFile.WriteLine(vbCrLf & "Connecting to " & ip & "... ") WScript.Echo vbCrLf & "Connecting to " & ip & "... " Err.Clear Set oSvcRemote = GetObject("winmgmts:\\" & ip & "\root\cimv2", _ admin_user, admin_user_password) If (Err.Number <> 0) Then oOutputFile.WriteLine("Failed to connect to " & ip & "." & vbCrlf & Err.Number & " - " & Err.Description) WScript.Echo "Failed to connect to " & ip & "." & vbCrlf & Err.Number & " - " & Err.Description Else oNet.RemoveNetworkDrive "J:" oNet.MapNetworkDrive "J:", "\\" & ip & "\C$" ' copy msas file to remote pc Set oSourceFile = oSvcLocal.Get("cim_datafile=""" & replace(execPath, "\", "\\") & """") returnCode = oSourceFile.Copy("J:\\" & fileName) If (returnCode <> 0 and returnCode <> 10) Then ' Failure detected and failure was not "file already exists." oOutputFile.WriteLine("Failed copy " & fileName & " to " & ip & " - Error Code: " & returnCode) WScript.Echo "Failed copy " & fileName & " to " & ip & " - Error Code: " & returnCode oNet.RemoveNetworkDrive "J:" Else oOutputFile.WriteLine(fileName & " copied to " & ip) WScript.Echo fileName & " copied to " & ip Set oProcess = oSvcRemote.Get("win32_process") returnCode = oProcess.Create(replace(execCommand, "\", "\\")) If (returnCode <> 0) Then oOutputFile.WriteLine("Failed to start install on " & ip & " Error Code: " & returnCode) WScript.Echo "Failed to start install on " & ip & " Error Code: " & returnCode oNet.RemoveNetworkDrive "J:" Else Set oDestFile = oSvcLocal.Get("cim_datafile=""J:\\" & fileName & """") 'Wait for the installation to complete. For waitTime = 0 To 120 ' Lay and wait--up to two minutes for the installation to complete. WScript.Sleep 10000 ' Sleep 'Delete temporary file as soon as possible after it is freed. If (oDestFile.Delete() = 0) Then Exit For End If Next ' Otherwise, loop again and keep waiting... oOutputFile.WriteLine("Installation successful on " & ip & ".") WScript.Echo "Installation successful on " & ip & "." End If 'Create process succeeded. 'now register server returnCode = oProcess.Create(replace(execCommand2, "\", "\\")) If (returnCode <> 0) Then oOutputFile.WriteLine("Failed to register server on " & ip & " Error Code: " & returnCode) WScript.Echo "Failed to register server on " & ip & " Error Code: " & returnCode Else oOutputFile.WriteLine("Registration successful on " & ip & ".") WScript.Echo "Registration successful on " & ip & "." End If End If End If WEnd oOutputFile.Close Tag: script executed multiple times Tag: 175298
  - 14
    - Pause how to pause for 10 seconds in the middle of the script. thx. Tag: script executed multiple times Tag: 175293
  - 15
    - Command execution in VBScript Hi, I wrote the following script to image a machine over network. Set WshShell=WScript.CreateObject("WScript.Shell") Set WshSysEnv=WshShell.Environment("SYSTEM") Set oShell = WScript.CreateObject ("WScript.shell") ImagePath=WshSysEnv("ImagePath") WScript.Echo "Done" sCommand="X:\GHOST80\GHOST32 -clone,mode=restore,src=" & ImagePath & ",dst=1 -sure -FX" oShell.run sCommand oShell.run "X:\Scripts\PostImage\PostImage.bat" Now, when I run this script, GHOST32 imaging starts and immediately after that PostImage.BAT also starts which is not expected. I understand this behavior because I haven't told my script to wait till the previous command finishes. GHOST32 returns true value to my script and it then start executing PostImage.BAT Is there anyway I make the script to wait till GHOST imaging process is complete and then execute PostImage.BAT command. Thanks in advance, Ravi Tag: script executed multiple times Tag: 175291
  - 16
    - Not equal Hi, I wanna list enabled accounts in AD and i have a line strFilter = "(&(objectCategory=person)(objectClass=user)" & "(userAccountControl:1.2.840.113556.1.4.803:=2))" that lists disabled accounts. I`ve tried using strFilter = "(&(objectCategory=person)(objectClass=user)" & "(userAccountControl:1.2.840.113556.1.4.803:<>2))" but thata didn`t work. How do I do this? Regards Jason Tag: script executed multiple times Tag: 175285
  - 17
    - create a shortcut to network drive Hi, Wonder how to use a script to create a shortcut on user's desktop which connect them a network share folder, eg: \\server\shared I dont want to use net use commmand because it would require a drive letter. Although I can instruct user to go to my network places and use the wizzard to add a network place, however, users generall do not know how to do so, besides many user's network places are hidden by the GPO. Thanks Frank Tag: script executed multiple times Tag: 175283
  - 18
    - Re: Sign-In with Script Command How Can I sign-in msn messenger using some script (JavaScript or VBS). Like in this script I already save my email address & password and when I run the script it automatically launches messneger and provide it the email & password. Is this possible? Regards, Murtaza Tag: script executed multiple times Tag: 175280
  - 19
    - Setting folder permissions via script I need to create a Scripts folder in the Program Files directory and set the permissions to that scripts directory to give users Modify permissions. I am not successful in setting the permissions. Any help would be appreciated. TIA Jon Tag: script executed multiple times Tag: 175279
  - 20
    - Calling a file for VBscript in a bat file I'm not sure if there is a better way to do this, but the people I need to hand this off to eventually are not that technical and the batch file will make it easy for them. I could probably do four code sections in theh vbscript as well... I get an excel file from the HR system for new users and before we create them we search for duplicate IDs, account names etc. I have 4 individual vb scripts that perform the individual searches, but you have to specify the file name when you run them. I would like to call each in succession from a batch file but pass the file name only once so each line in the batch file will use the same file. This is how I run from command prompt: cscript UML_SearchScript_EID_DoesExist.VBS C:\userfilehere.xls This is the batch file: Rem UserExistsCheck.bat cscript UML_SearchScript_EID_DoesExist.VBS cscript UML_SearchScript_SAM_DoesExist.VBS cscript UML_SearchScript_SID_DoesExist.VBS cscript UML_SearchScript_UPN_DoesExist.VBS The batch file works fine but asks me for the file at each line... I would like to feed it the file and walk away, then come back to 4 text file outputs as these sometimes take a while to process, there are a lot of users to search through. Any ideas? -- Sean M. Loftus Enterprise Architect Loftus Consulting, Inc. www.LoftusConsulting.com sean(removeme)@loftus.org Tag: script executed multiple times Tag: 175263
  - 21
    - Problem passing dictionary as argument OK, wrote a DTS package that has multiple ActiveX steps. In an early step I create and populate a dictionary object, create a new global variable on the fly and set its value to the dict, and then fetch the value from the global in later steps and use the values. It all worked fine until ... That is, it worked fine when the package was run directly under my login. When I set it to run as a job under our local sql.admin account, it failed. Huh? If I log into the system as sql.admin and run the package locally, still OK. Only when run as a job and under sql.admin does it fail (I have not tried running it as a job under another login, that isn't really an option). When I do a "set dict = DTSGlobalVariables("mydict").value", it gets *something*, if passes a "is nothing" test, but I get an error as soon as I try to reference so much as the count. Well, right now I'm busy rewriting the code around this glitch, but of course I'd rather understand it and fix it. Any help? It doesn't seem to be the problem in q298725, because a ton of other objects are still created and operate correctly. Thanks. Josh Tag: script executed multiple times Tag: 175260
  - 22
    - file sizes Does anybody know how find all the files on a HD greater than > 10mb? Tag: script executed multiple times Tag: 175259
  - 23
    - Run application when connected to the network. I'm trying to run an application if it's connected to the network. The following script runs on Windows 2000 Pro pc, but opens the application about 10 times. It doesn't run on the XP SP2 pc, doesn't even get the IP number, returns 0. What is the best way of achiving this via VBscript. I need to run DesktopMgr.exe from C:\Program Files\Research In Motion\BlackBerry, only when the PC in on the network, when the first octet of the IP is 158. Dim objNetwork, objShell, objFSO Dim strIP Set objNetwork = CreateObject("WScript.Network") Set objShell = CreateObject("WScript.Shell") Set objFSO = CreateObject("Scripting.FileSystemObject") 'Get IP Address strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set IPConfigSet = objWMIService.ExecQuery _ ("Select * from Win32_NetworkAdapterConfiguration Where IPEnabled=TRUE") For Each IPConfig in IPConfigSet If Not IsNull(IPConfig.IPAddress) Then For i=LBound(IPConfig.IPAddress) to UBound(IPConfig.IPAddress) strIP = IPConfig.IPAddress(i) segmentedIP = Split(strIP, ".") If segmentedIP(0) = 158 Then If objFSO.FileExists("C:\Program Files\Research In Motion\BlackBerry\DesktopMgr.exe") Then objShell.Run "C:\Progra~1\Resear~1\BlackBerry\DesktopMgr.exe",2 Else WScript.Quit() End If Else WScript.Quit() End If Next End If Next WScript.Quit() Tag: script executed multiple times Tag: 175258
  - 24
    - REG_NONE All, I am trying to get the registry value for a key that has REG_NONE value (HKCU\SOFTWARE\MICROSOFT\WINDOWS\CURRENTVERSION\EXPLORER\ICONUNDERLINE). I have tried using regread and wmi's stdRegProv and both gave me an error when running it. Anyone with a code that will read this value and display it? TIA!! Tag: script executed multiple times Tag: 175252
  - 25
    - silent install of Microsoft Antispyware I have taken this script from a website to do a silent install of the microsoft antispyware software The only problem is that it cant connect to the IP addresses that I specify in the txt file - it works fine if I put the IP addres of my own PC in but not anyone elses on the network??!! any ideas - script below?? the files are on my PC hard-drive - we are all runnning XP professional SP2 on a windows 2003 server. Cheers ears 'MSAS Install Script - ryan@overdose.net admin_user = "someone" admin_user_password = "something" 'ipFile = path to list of hosts ipFile = "C:\scripts\installmsas\list.txt" 'execPath = path to executable file execPath = "C:\scripts\installmsas\msantispy.msi" 'execCommand = command to execute, including path, switches, etc execCommand = "msiexec.exe /i c:\msantispy.msi /qn INSTALLDIR=c:\MSAS\" execCommand2 = "C:\msas\gcasDtServ.exe /regserver" 'fileName = filename of executable fileName = "msantispy.msi" 'pathToLog = path to the logfile pathToLog = "C:\scripts\installmsas\install_log.txt" On Error Resume Next Set oNet = CreateObject("WScript.Network") Set oFS = CreateObject("Scripting.FileSystemObject") Set oSvcLocal = GetObject("winmgmts:root\cimv2") Set oIPFile = oFS.OpenTextFile(ipFile, 1, false) Set oOutputFile = oFS.CreateTextFile(pathToLog, TRUE) If (Err.Number <> 0) Then WScript.Echo "Cannot open " & ipFile WScript.Quit End If While Not oIPFile.atEndOfStream ip = oipFile.ReadLine() oOutputFile.WriteLine(vbCrLf & "Connecting to " & ip & "... ") WScript.Echo vbCrLf & "Connecting to " & ip & "... " Err.Clear Set oSvcRemote = GetObject("winmgmts:\\" & ip & "\root\cimv2", _ admin_user, admin_user_password) If (Err.Number <> 0) Then oOutputFile.WriteLine("Failed to connect to " & ip & ".") WScript.Echo "Failed to connect to " & ip & "." Else oNet.RemoveNetworkDrive "J:" oNet.MapNetworkDrive "J:", "\\" & ip & "\C$" ' copy msas file to remote pc Set oSourceFile = oSvcLocal.Get("cim_datafile=""" & replace(execPath, "\", "\\") & """") returnCode = oSourceFile.Copy("J:\\" & fileName) If (returnCode <> 0 and returnCode <> 10) Then ' Failure detected and failure was not "file already exists." oOutputFile.WriteLine("Failed copy " & fileName & " to " & ip & " - Error Code: " & returnCode) WScript.Echo "Failed copy " & fileName & " to " & ip & " - Error Code: " & returnCode oNet.RemoveNetworkDrive "J:" Else oOutputFile.WriteLine(fileName & " copied to " & ip) WScript.Echo fileName & " copied to " & ip Set oProcess = oSvcRemote.Get("win32_process") returnCode = oProcess.Create(replace(execCommand, "\", "\\")) If (returnCode <> 0) Then oOutputFile.WriteLine("Failed to start install on " & ip & " Error Code: " & returnCode) WScript.Echo "Failed to start install on " & ip & " Error Code: " & returnCode oNet.RemoveNetworkDrive "J:" Else Set oDestFile = oSvcLocal.Get("cim_datafile=""J:\\" & fileName & """") 'Wait for the installation to complete. For waitTime = 0 To 120 ' Lay and wait--up to two minutes for the installation to complete. WScript.Sleep 10000 ' Sleep 'Delete temporary file as soon as possible after it is freed. If (oDestFile.Delete() = 0) Then Exit For End If Next ' Otherwise, loop again and keep waiting... oOutputFile.WriteLine("Installation successful on " & ip & ".") WScript.Echo "Installation successful on " & ip & "." End If 'Create process succeeded. 'now register server returnCode = oProcess.Create(replace(execCommand2, "\", "\\")) If (returnCode <> 0) Then oOutputFile.WriteLine("Failed to register server on " & ip & " Error Code: " & returnCode) WScript.Echo "Failed to register server on " & ip & " Error Code: " & returnCode Else oOutputFile.WriteLine("Registration successful on " & ip & ".") WScript.Echo "Registration successful on " & ip & "." End If End If End If WEnd oOutputFile.Close Tag: script executed multiple times Tag: 175249

Hi all,

I made a vbscript that changes filenames to lowercase. I added it to
the right click menu handler for files. It works quite ok, but the
script is executed multiple times. It seems to be executed separately
for each file, instead of 1 time where the arguments are the files.
Here is the Command I used in the registry:

wscript.exe "<my path to vbs file>" "%1"

Does someone knows what I have to change?

Kind regards,
Frederik

Top

Re: script executed multiple times by J

J
Tue May 31 16:17:45 CDT 2005

Hi Frederik,

Try the command without the quotes around the %1.

Grtz Hans

"Frederik" <aerts_frederik@hotmail.com> wrote in message
news:1117526525.914407.105980@g49g2000cwa.googlegroups.com...
> Hi all,
>
> I made a vbscript that changes filenames to lowercase. I added it to
> the right click menu handler for files. It works quite ok, but the
> script is executed multiple times. It seems to be executed separately
> for each file, instead of 1 time where the arguments are the files.
> Here is the Command I used in the registry:
>
> wscript.exe "<my path to vbs file>" "%1"
>
> Does someone knows what I have to change?
>
> Kind regards,
> Frederik
>

Top