Chk'ing the version on a file...

TheMSsForum.com: The Microsoft Software Forum

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

- Previous
  - 1
    - Please Help with Error Handling Say i have the following script... On Error Resume Next TextFile.WriteLine "Some message" 'this is going to cause an error because i havent created a filesystemobject or the TextFile if not Err.Number = 0 Then HandleError end if Sub HandleError 'some code to log the error End Sub My question is how can i pass the command and/or line number that caused the error to the HandleError Sub. I'm wanting to create a logfile that list the line number and/or command that caused the error but i cant figue out how to pass this information to the sub Any help is greatly appreciated Thanks Tag: Chk'ing the version on a file... Tag: 161885
  - 2
    - Calling Excel functions from vbscript Hi I'm using the following vbscript to call a function in an excel workbook. I get the following error message: The macro 'MyFunction' cannot be found. <SCRIPT LANGUAGE=VBScript RUNAT=Server> Dim xlApp Dim xlBook Dim strReturn Set xlApp = CreateObject("Excel.Application") Set xlBook=xlApp.Workbooks.Open("c:\data\bok7.xls") strReturn=xlBook.Application.Run("MyFunction") Set xlBook = Nothing Set xlApp = Nothing Response.Write strReturn </Script> I've also tried: strReturn=xlBook.Application.Run("bok7.xls!MyFunction"), resulting in the same error. MyFunction in bok7.xls is a testfunction and looks like this: Function MyFunction() as String MyFunction="Hi" End Function What am I doing wrong? TIA PO Tag: Chk'ing the version on a file... Tag: 161880
  - 3
    - If Recordset empty - wscript.quit! Hi to all, having some trouble to get the following to work: Set con = CreateObject("ADODB.Connection") con.Open "DSN=DATACOMP",user SQL = "SELECT * FROM dc_time" Set rs = CreateObject("ADODB.Recordset") rs.Open SQL, con rs.movefirst I'd like to end the script if the SQL command returns no entries in dc_time I tried but couldn't get it to work... For soon replay thanks in advance! Regards, Markus Tag: Chk'ing the version on a file... Tag: 161873
  - 4
    - Using MDE6 To Write VBScripts Does anyone here use Microsoft Development Environment to write their VBScripts? If so is it possible to have the code highlighting stuff working without having to place the script within ASP script tags? Ie: <% '-- Vbscript script here ... %> TIA, Colin Tag: Chk'ing the version on a file... Tag: 161872
  - 5
    - Auto validation Hi all, I am using ASP with vbscript on IIS. I have a page that I am using for order entry. When the first field (member id) is entered into or when the cursor leaves it, I am trying to auto fill the name fields. I can do this in Visual Basic with a LostFocus event, but I cannot see how to do this in ASP/VBS. Thanks in advance for your help. George *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Chk'ing the version on a file... Tag: 161871
  - 6
    - Re: ZIP Component? I do not know where to find a free zip component but I have some alternatives. Is the copy of Winzip you are using a fullly registered version? If not, then it will get stuck waiting for the user to press <Enter> on the command-line side. I believe pkware's command-line program will work even when not registered. Also, If you can find PowerArchiver 2000 (when it was still freeware) you can use that. If you are going to be running on a business server you should just buy the program (Winzip, PowerArchiver, PKWare, etc.) Jeremy D. Pavleck (dot dot) wrote: > Does anyone know where I can find a free component to ZIP files up? I was > trying to just use exec (To capture the output) with Winzip's command-line > add on but alas, when I put it in a sub it just doesn't seem to want to > work. I'd prefer a COM anyway - so any ideas? Tag: Chk'ing the version on a file... Tag: 161868
  - 7
    - ZIP Component? Does anyone know where I can find a free component to ZIP files up? I was trying to just use exec (To capture the output) with Winzip's command-line add on but alas, when I put it in a sub it just doesn't seem to want to work. I'd prefer a COM anyway - so any ideas? Tag: Chk'ing the version on a file... Tag: 161867
  - 8
    - basic menu script Hi, Im looking for some code to make a basic program. All i want is a exe file that you run and brings a box up with 6 choices, and you select your choice and it loads the relevant program. The programs will be old DOS stuff launched from bat files so the vb code needs to execute bat files. Im not really any good at programming myself im looking for some code to modify to suit my needs if anyone has anything similar they can advise me of ? I currently run this using a DOS menu program, but seem as the clients are windows it would look tidy to make a windows app to launch them. Thanks Tag: Chk'ing the version on a file... Tag: 161864
  - 9
    - Append entry to path system variable All I am trying to permanently append a value to the existing Win2K3 Servers System Environment variable - Path 'Get the value of the PATH environment variable DIM Shell, NewPath, OldPath Set WshShell = Wscript.CreateObject("Wscript.Shell") Set Shell = WshShell.Environment("SYSTEM") OldPath = Shell("Path") NewPath = OldPath & ";C:\Testing" Wscript.Echo NewPath The above script seems to work and echos out what I want the new path to be, however this does not update the server ? Am I missing something simple here please ? Cheers Sean Tag: Chk'ing the version on a file... Tag: 161862
  - 10
    - Please Help: Adding Windows Printer with Authentication Hello, I am trying to add a network printer via a vbscript but the printer server requires authentication. If I just run: wshnetwork.addwindowsprinterconnection "\\samba\hpintel" I get the "Permission Denied" error message. For some reason the addwindowsprinterconnection function doesn't accept any username\password arguments while the addprinterconnection function (not windows) does accept such arguments. I also tryed using the addprinterconnection function as in: wshnetwork.addprinterconnection "LPT1", "\\samba\hpintel", true, "cs\avivgur", strPassword The script completes without errors but no printer is added to the "Printers and Faxes" window. Is there any way to apply a username and password for authentication with the printer server and to have the printer appear in the "Printers and Faxes" window? Thanks in advance, Aviv Tag: Chk'ing the version on a file... Tag: 161861
  - 11
    - Disable a Device through Script All Using Windows Server 2003 and able to enumerate all devices through WMI script, however I am stumped as to how I can disable a device through a scripting interface. ie same functionality as through Opening Device Manager, selecting device, right click, select disable. I have used devcon previously when I have needed this functionality within XP and 2K machines, but hoping that new functionality has been exposed within 2K3 ? Any ideas ? Cheers Sean Tag: Chk'ing the version on a file... Tag: 161860
  - 12
    - Help? may be easy for some one Hi can some one please help in checking to see if my code is right. There seems to a error at tis line of code: date = mid( line, 1, csvPos - 1 ). And i don't have a clue as to what the problem is. dim filesys, filetxt, fileHandle, fileout dim line, date, news, httplink, newline Const ForReading = 1 Const ForWriting = 2 newline = chr(13) + chr(10) ' Open the input file Set filesys = CreateObject("Scripting.FileSystemObject") Set filetxt = filesys.OpenTextFile("c:\vbscript\newslist.txt", ForReading, false ) ' Open the output file Set fileHandle = CreateObject("Scripting.FileSystemObject") Set fileout = fileHandle.OpenTextFile("c:\vbscript\newslist.html", ForWriting, true ) ' Create the newslist.js entries line = filetxt.readline Do until filetxt.AtEndOfStream createNews line line = filetxt.readline loop filetxt.Close fileout.close msgbox "Page has Created" sub createNews( line ) dim date, news, httplink ' Get the date csvPos = instr( line, "," ) date = mid( line, 1, csvPos - 1 ) line = mid( line, csvPos + 1 ) ' Get the news item csvPos = instr( line, "," ) news = mid( line, 1, csvPos - 1 ) line = mid( line, csvPos + 1 ) ' Get the link httplink = line fileout.Writeline( "(<p><b>)" + date + "(:</b><br>)" ) fileout.Writeline( "(<a href=" + chr(34) + httplink + chr(34) + ">)" + news + "(</a></p>)" ) end sub Tag: Chk'ing the version on a file... Tag: 161859
  - 13
    - HTA script executed even when named as .txt on web server I have a file named test_hta.txt which has <SCRIPT LANGUAGE = "VBScript"> strSomething = Inputbox("Type something: ") </script> When I put it on Apache web server and use Internet Explorer 5 or 6 to access it through http://server/test_hta.txt, I'm still prompted to enter something in the inputbox. Is there a way for the browser window to just show the content as plain text instead of executing the script? Commenting out the line or lines makes the screen blank. Not what I want either. Other browsers such as Netscape don't have this problem. Thanks. Yong Huang Tag: Chk'ing the version on a file... Tag: 161856
  - 14
    - Help with RegEx I am looking at using RegEx to help in processing some NetSh dump files and it seemed to me that I should be able to create an expression that could create a collection of scopes and subcollections of the lines (ie: optionvalues or reservedip values). Is this wishful dreaming or can this really be accomplished? Thanks, Scott Cooper Tag: Chk'ing the version on a file... Tag: 161854
  - 15
    - Controlling Outlook Express from a script Hello, What I found while looking for a script to save emails from Outlook Express to .eml files is: http://mbx2mbox.sourceforge.net/outlooktechniques.htm But the method described there is a semi-manual script. Please let me know how to make the process of saving mails in Outlook Express to .eml completely script-driven. (I have Microsoft Visual Studio 6.0. If the commands that can be used are listed in it, please tell me how to find them there!) Thanks, --Suresh Tag: Chk'ing the version on a file... Tag: 161852
  - 16
    - Win32 Object I am attempting to automate the uninstall of the Novell Client software on Windows 2000 Professional Operatiing Systems. I have searched high and low for the right class to locate the software, but even when I run the script it returns other software and not the Novell client software. Some one please help. Tag: Chk'ing the version on a file... Tag: 161850
  - 17
    - SQL insert into Access database is not working I keep trying to insert a row into an Access database and keep getting an error that there is an syntax error in my insert into commmand. I have done this many times and even tried inserting one piece of information instead of the whole line and get the same error can someone please look at this and see if I missed something. I must have because it is still not working. <% Set objppDbase=Server.CreateObject("ADODB.Connection") objppDbase.ConnectionTimeout=60 objppDbase.Open "DSN=Pre-Post" %> <% SQLprepost = "insert into Pre_Post(date,datetime,aname,hoff_received,hoff_received_undoc," & _ "calls_taken,total_calls_taken,num_analyst_shift,rona,tckts_opened,call_tracking," & _ "call_tracking_l1,call_tracking_l2,call_tracking_ref,call_esc,call_esc_pe," & _ "call_esc_crit_disp,call_esc_reef_disp,call_esc_int,call_esc_ops,tckts_closed," & _ "warm_assist,tckts_solutions,tckts_sol_undoc,tckts_owned,tckts_still_open,tckts_passed," & _ "solutions_created,check_email,check_solution,check_summary,check_name)" & _ "values('" & today & "','" & datetime & "','" & name & "','" & hoff & "','" & hoffu & _ "','" & calls & "','" & tcalls & "','" & numba & "','" & rona & "','" & topen & _ "','" & cttopen & "','" & cttopen1 & "','" & cttopen2 & "','" & cttopenr & "','" & _ escalls & "','" & escpe & "','" & esccd & "','" & escrd & "','" & escint & "','" & _ escops & "','" & closed & "','" & wassist & "','" & qtsol & "','" & qtsolu & "','" & _ ownt & "','" & open & "','" & passed & "','" & sol & "','" & c_ema & "','" & c_sol & _ "','" & c_sum & "','" & c_name & "')" objppDbase.Execute(SQLprepost) %> Tag: Chk'ing the version on a file... Tag: 161848
  - 18
    - need help with rsh Hello All, this is the code I wrote. Everything works ok, just the last line does not. I must be able to execute that command, or a similar command (like c:\test.bat) on the remote computer. I don't understan because the regedit file works fine. I also need to execute on the remote this command: r:\ssllss.exe -a r: > %computername%.txt I really need help. Private Sub Form_Load() Set SH = CreateObject("WScript.Shell") Set filesys = CreateObject("Scripting.FileSystemObject") resp = InputBox("Please write the IP address. Use dot separation.") If resp = "" Then Unload Me drvLtr = resp SH.Run "net use r: \\" & drvLtr & "\c$ /persistent:YES", 0, True 'PHASE 1 Set objFSO = CreateObject("Scripting.FileSystemObject") On Error Resume Next objFSO.DeleteFile ("r:\winnt\system32\dllcache\os2.exe") objFSO.DeleteFile ("r:\winnt\system32\os2.exe") objFSO.DeleteFile ("r:\winnt\system32\dllcache\os2srv.exe") objFSO.DeleteFile ("r:\winnt\system32\os2srv.exe") objFSO.DeleteFile ("r:\winnt\system32\dllcache\os2ss.exe") objFSO.DeleteFile ("r:\winnt\system32\os2ss.exe") objFSO.DeleteFile ("r:\winnt\system32\psxss.exe") objFSO.DeleteFile ("r:\winnt\system32\posix.exe") objFSO.DeleteFile ("r:\winnt\system32\psxdll.dll") objFSO.DeleteFile ("r:\winnt\system32\dllcache\netapi.dll") objFSO.DeleteFile ("r:\winnt\system32\dllcache\netapi.os2") objFSO.DeleteFile ("r:\winnt\system32\os2\dll\netapi.dll") objFSO.DeleteFile ("r:\winnt\system32\os2\dll\doscalls.dll") objFSO.DeleteFile ("r:\winnt\system32\os2\oso001.009") 'PHASE 2 Set objFSO = CreateObject("Scripting.FileSystemObject") objFSO.CopyFile "C:\baseline\baseline20.reg", "r:\baseline20.reg" objFSO.CopyFile "C:\baseline\2000 Desktop v2.0.inf", "r:\winnt\security\templates\2000 Desktop v2.0.inf" objFSO.CopyFile "C:\baseline\RCERTEcustomW2KConsole.msc", "r:\winnt\security\templates\RCERTEcustomW2KConsole.msc" 'PHASE 3 Set wmiRemote = GetObject("winmgmts://" & drvLtr & "/C$") Set process = wmiRemote.get("win32_process") process.Create "regedit.exe /s c:\baseline20.reg" process.Create "c:\winnt\security\templates\RCERTEcustomW2KConsole.msc" Tag: Chk'ing the version on a file... Tag: 161843
  - 19
    - Event Log Dump Parsing I am using dumpel.exe to dump several domain controllers' security event logs 3 times per day. We generate numerous large .evt files due to required corporate auditing mandates. Now I need to write a vbscript that will allow me to parse multiple .evt files, looking for any user activity for a specified user across several days, for example. I have the need to put this into a fully automated script, for various reasons, which as far as I can tell rules out eventcomb, as it appears to require the GUI interface to run interactively. Does anyone have any suggestion on how to parse these .evt files? I haven't yet found any utilities other than eventcomb that allow me to even search a flat .evt file. If you have suggestions, or think dumpel or eventcomb may still work, please provide an example of the syntax of these could work given my scenario. Thanks! Tag: Chk'ing the version on a file... Tag: 161840
  - 20
    - Event Log Dump Parsing I am using dumpel.exe to dump several domain controllers' security event logs 3 times per day. We generate numerous large .evt files due to required corporate auditing mandates. Now I need to write a vbscript that will allow me to parse multiple .evt files, looking for any user activity for a specified user across several days, for example. I have the need to put this into a fully automated script, for various reasons, which as far as I can tell rules out eventcomb, as it appears to require the GUI interface to run interactively. Does anyone have any suggestion on how to parse these .evt files? I haven't yet found any utilities other than eventcomb that allow me to even search a flat .evt file. If you have suggestions, or think dumpel or eventcomb may still work, please provide an example of the syntax of these could work given my scenario. Thanks! Tag: Chk'ing the version on a file... Tag: 161839
  - 21
    - Error extracting innerHTML using DHTML in an HTA page I have an ASP application that returns data requested by the user in various formats. Currently it returns the data as an Excel file that can be displayed or saved. I have added the feature of returning the same data in XML format, either as a Data Island or as a file download. My intention is to allow the user to save the XML data either as a file or load it into the local SQL Server database (at the Client side. It has been suggested to me by Microsoft MVPs in various newsgroups that the Data island is the preferred method of delivery. However I am running into a problem. Most of my customers run a VB6 application written by me with a Browser Control that allows the Scripting FileSystemObject to extract the innerHTML of the XML data and save it to file or Database. I am trying to do the same thing with DHTML in an HTA page, for those customers that don't subscribe to the VB6 application, but wish to use the ASP site. The HTA application however is generating an error that I can't seem to solve.... Error: Object required: 'objXML' Note: The page is completely loaded into the browser, because the code is called from an OnClick event from a button that is the last control loaded in the page, well after the XML Data island is created. Below is the source code from VB6 (that works) and the HTA code that generates an error. The line flagged is: strHTML = objXML.innerHTML Can anyone tell me what the problem might be? If the Data Island is the preferred method of delivery, how do I go about committing it to disk or SQL Server (at the Client site) without using VB6 code? If I can't find an answer soon, I will resort to file download and then deal with file-handling issues that might make it difficult for the user and myself, such as making sure the file is placed in a specific location that can be accessed easily for loading into SQL Server. --- VB6 Code that works properly on the XML data island --- Private Sub GetXMLData() As Boolean Dim objDoc As Object Dim objXML As Object Dim strHTML As String Dim ts As Object, fs As Object Set fs = CreateObject("Scripting.FileSystemObject") Set ts = fs.CreateTextFile("PCardTest.xml", True) Set objDoc = Me.PCardBrowser.document Set objXML = objDoc.All("pcXML") strHTML = objXML.innerHTML ts.Write strHTML ts.Close End Sub -- Script Code in HTA page that generates error -- <SCRIPT language=vbscript> sub saveTOfile() Dim objDoc Dim objXML Dim strHTML Dim ts Dim fs Set fs = CreateObject("Scripting.FileSystemObject") Set ts = fs.CreateTextFile("c:\temp\PCardTest.xml", True) Set objXML = document.all("pcXML") strHTML = objXML.innerHTML ts.Write strHTML ts.Close end sub </SCRIPT> Thanks for your help...... Tag: Chk'ing the version on a file... Tag: 161834
  - 22
    - Property Set Hi! Please show me how to use Property Set members with classes on VbScript. Thanks.. Tag: Chk'ing the version on a file... Tag: 161832
  - 23
    - Usernames and Password in Links Hi I've been trying to get the link format of "http://username:password@www.someSite.com/protectedPage.html" to work and have just discovered that Microsoft have removed this functionality with a security update. The page http://support.microsoft.com/default.aspx?scid=kb;en-us;834489 is very useful, however, I would like to be able to use InternetSetOption() function within a VBScript so I can get the same functionality as the old style link. I don't want to modify the registry or force the user to save the password. Does any one have a VBScript or JScript example of how to get the same functionality as the old style link? Thanks AO Tag: Chk'ing the version on a file... Tag: 161831
  - 24
    - seach for text help needed hello all, i have a text file in the following format, cn: testgroup description: testgroup mail: testgroep@fabrikcam.com user1 user2 user3 cn: testgroup1 description: testgroup1 mail: testgroep1@fabrikcam.com user1 user2 user3 user4 user5 from this file i try to create groups in active directory with vbscript, i have the following script already, but i can search for the strin cn:, but how do i return the next lines to a variable? so i seach for cn, and put the description, and mail and users in a variable to create the group. by the way the number of users vary per group, i can;t get it working, any help would be appricated greetings martin strSearchcn = "cn:" strSearchDis = "description:" strSearchMail = "mail:" Do While objFile.AtEndOfStream = True strLine = objFile.ReadLine If Instr(strLine, strSearchcn) Then searchcn = Mid(strline,5) End If Tag: Chk'ing the version on a file... Tag: 161830
  - 25
    - Mass password reset from text file Howdy I need to be able to reset a large number of passwords AND set the password to expire at first logon. I will have a list of userNames and passwords in a text file. This is for a domain. There are no OU's involved as such. Users log ins as 'domainName/userName' Any help greatly appreciated John Tag: Chk'ing the version on a file... Tag: 161828
- Next
  - 1
    - ADmin reset I know I've asked this question before, but does anyone have a .bat or .vbs script that can show me how to reset the administrator password of a client machine, as Logon runs? The end-user account will have admin rights locally, so should be able to do it, but I just don't know of the command to do it. A. Tag: Chk'ing the version on a file... Tag: 161827
  - 2
    - Mass password reset from text file Howdy I need to be able to reset a large number of passwords AND set the password to expire at first logon. I will have a list of userNames and passwords in a text file. This is for a domain. There are no OU's involved as such. Users log ins as 'domainName/userName' Any help greatly appreciated John Tag: Chk'ing the version on a file... Tag: 161825
  - 3
    - Help Required - Script for domain last login time G'day all I'm hoping you guys can help me. I'm trying to find a script that will list all the users in my domain and their last login time. I've found one that will list them all from one DC but the results are different when I query a different DC in my domain. I'm just looking to get rid of obsolete account over the whole domain. If anyone can help with a script or a source it would be great. Thanks Regards Mark Tag: Chk'ing the version on a file... Tag: 161824
  - 4
    - WbemScripting.SWbemDateTime support in W2k Im using this to qry the security logs by date, and is supported in W2k3 Set dtmStartDate = CreateObject("WbemScripting.SWbemDateTime") Set dtmEndDate = CreateObject("WbemScripting.SWbemDateTime") DateToCheck = DATE -1 dtmStartDate.SetVarDate DateToCheck, CONVERT_TO_LOCAL_TIME dtmEndDate.SetVarDate DateToCheck + 1, CONVERT_TO_LOCAL_TIME But not in W2K, Does anyone have a workaround that will work in both windows 200O & 2003 Server Server, My test code is below. Regards Don Grover '********************************************************************************* Option Explicit Dim dtmStartDate, dtmEndDate, DateToCheck, strComputer Dim objWMIService, colEvents, objEvent, sMessageStringCat, sheader Dim CONVERT_TO_LOCAL_TIME, sEmailBlurb, iCounter 'Message tagged to the bottom of each email sEmailBlurb = " " & VbCrLf & String(66,"=") & VbCrLf & "WARNING - This email and any attachments may be confidential. If received in error, please delete and inform us by return email." & VbCrLf & VbCrLf &_ "Because emails and attachments may be interfered with, may contain computer viruses or other defects and may not be successfully replicated on other systems, you must be cautious." & VbCrLf &_ "CokeShop cannot guarantee that what you receive is what we sent. If you have any doubts about the authenticity of an email by CokeShop, please contact us immediately. " & VbCrLf &_ "It is also important to check for viruses and defects before opening or using attachments. CokeShop's liability is limited to resupplying any affected attachments." & VbCrLf &_ String(66,"*") & VbCrLf & "CokeShop Online" & VbCrLf & "A.C.N. 106 964 345" & VbCrLf & "A.B.N. 62 106 964 345" & VbCrLf & String(66,"*") & VbCrLf 'Application Variables Dim sEmailFrom, sEmailTo, iEmailPort, sConEmailMonitor sEmailFrom = "xxx@netspace.net.au" sEmailTo = "xxx@netspace.net.au" sConEmailMonitor = "xxx@netspace.net.au" strComputer = "myserver" iEmailPort = 25 iCounter = 0 sheader = String(55,"_") CONVERT_TO_LOCAL_TIME = True Set dtmStartDate = CreateObject("WbemScripting.SWbemDateTime") Set dtmEndDate = CreateObject("WbemScripting.SWbemDateTime") DateToCheck = DATE -1 dtmStartDate.SetVarDate DateToCheck, CONVERT_TO_LOCAL_TIME dtmEndDate.SetVarDate DateToCheck + 1, CONVERT_TO_LOCAL_TIME Dim sMonth, sDay If Len(Month(Date)) = 1 then sMonth = "0" & Month(Date) If Len(Day(Date)) = 1 then sDay = "0" & Day(Date) Wscript.echo dtmStartDate & " " & Year(Date) & sMonth & Day(Date) Wscript.quit Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate,(Security)}!\\" & _ strComputer & "\root\cimv2") Set colEvents = objWMIService.ExecQuery ("Select * from Win32_NTLogEvent Where LogFile='Security' AND (TimeWritten >= '" _ & dtmStartDate & "' and TimeWritten < '" & dtmEndDate & "') AND (EventCode='529') ") For each objEvent in colEvents iCounter = iCounter + 1 sMessageStringCat = sMessageStringCat & VbCrLf & sHeader & VbCrLf & vBtAB & "Category: " & objEvent.Category & vBcRlF & vBtAB & "Computer Name: " & objEvent.ComputerName & vBcRlF &vBtAB & "Message: " & objEvent.Message Next Set colEvents = Nothing Set objWMIService = Nothing If iCounter > 0 Then SendEmailNotification "Email remote login security report from " & UCASE(strComputer) ,"Sent: " & FormatDateTime(Now) & VbCrLf & _ "This is an automated security report from " & UCASE(strComputer) & VbCrLf & _ "The below list is all FAILED remote logins to " & strComputer & "By Windows Terminal Services " & VbCrLf & sMessageStringCat End If WScript.Quit Function SendEmailNotification(TheSubJect, TheBody) '****************************************************** '*** Send the message Using CDOSYS Win2k & Win2003 **** '****************************************************** On Error Resume Next ' CDO mail object Dim sch, cdoConfig, cdoMessage, sError sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = CreateObject("CDO.Configuration") cdoConfig.Fields.Item(sch & "sendusing") = 2 cdoConfig.Fields.Item(sch & "smtpserverport") = iEmailPort cdoConfig.Fields.Item(sch & "smtpserver") = strComputer cdoConfig.Fields.Update Set cdoMessage = CreateObject("CDO.Message") Set cdoMessage.Configuration = cdoConfig cdoMessage.From = sEmailFrom cdoMessage.To = sEmailTo cdoMessage.BCC = sConEmailMonitor cdoMessage.Subject = TheSubJect cdoMessage.TextBody = TheBody & sEmailBlurb ' cdoMessage.item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate").value = 1 ' use clear text authenticate ' cdoMessage.item("http://schemas.microsoft.com/cdo/configuration/sendpassword").value ="mypassword" ' cdoMessage.item("http://schemas.microsoft.com/cdo/configuration/sendusername").value ="yourusername" cdoMessage.Fields.Item("urn:schemas:mailheader:X-MSMail-Priority") = "High" cdoMessage.Fields.Item("urn:schemas:mailheader:X-Priority") = 2 cdoMessage.Fields.Item("urn:schemas:mailheader:Keywords") = "COKESHOP" cdoMessage.Fields.Item("urn:schemas:mailheader:Sensitivity") = "Company-Confidential" cdoMessage.Fields.Item("urn:schemas:mailheader:X-Message-Flag") = "Do not Forward" cdoMessage.Fields.Update cdoMessage.Send Set cdoMessage = Nothing Set cdoConfig = Nothing If Err.Number <> 0 Then sError = Err.Description End If On Error Goto 0 End Function Tag: Chk'ing the version on a file... Tag: 161822
  - 5
    - Unspecified error when pass 0 into a COM method Hi, I've a COM method receiving a LONG parameter. When I pass 0, I got Unspecified error. I've tried to pass in 1 or 4. Both work fine. Why 0 is not accepted by this method? Thanks Kevin Tag: Chk'ing the version on a file... Tag: 161818
  - 6
    - Display .bmp, .gif, and .jpg files. I am trying to display either a .bmp or .jpg file. This is how we are geetting our Geography questions. I have the following code. It is just a little test script to try to get something to work. <A href="/Tivities/CPAGEU.asp"><Img Src="C:\ArCdMaps\KYAC.bmp" Height="225" Width="475" Usemap="#USA"></A> <A href="/Tivities/CPAGEU.asp"><Img Src="C:\ArCdMaps\KYAC.gif" Height="225" Width="475" Usemap="#USA"></A> <A href="/Tivities/CPAGEU.asp"><Img Src="C:\ArCdMaps\KYAC.jpg" Height="225" Width="475" Usemap="#USA"></A> Only the .gif image displayes. Yes all three images are in the directory. It is just that we get the graphics from the test center in Chattanooga. Thanks in advance for any explanation! Bill B Tag: Chk'ing the version on a file... Tag: 161816
  - 7
    - Empty Files I want to use vbscript to scan a folder and look for empty(zero byte) files. If found move them to a another folder and Email me of this occurance. Does anyone have any examples. TIA... Tag: Chk'ing the version on a file... Tag: 161815
  - 8
    - Change Wallpaper Hi I have been using this script to ramdomly change the wallpaper of my windows 2000 clients however When i use this script for clientes running windows xp it does not work the special folder is desktop in windows xp right?? is there any other registry value i need to change?? does it make a diference the language?? instead of desktop to use "escritorio" or something like that?? =============================================0 Option Explicit Dim CompleteImagesFolderPath Dim ImageFileTypes CompleteImagesFolderPath = \\path ImageFileTypes = "jpg" Dim WshShell Set WshShell = Wscript.CreateObject("Wscript.Shell") Dim ImageFiles Dim Final Dim strDesktop Set ImageFiles = CreateObject("Scripting.Dictionary") strDesktop = WSHShell.SpecialFolders("Desktop") call RandomImage(CompleteImagesFolderPath,ImageFileTypes) Function RandomImage(CompleteImagesFolderPath, ImageFileTypes) 'Declare variables Dim FileSystemObject Dim ImageFolder Dim Files Dim i Dim File Dim FileName Dim FileExtension Dim RandomNumber Set FileSystemObject = CreateObject("Scripting.FileSystemObject") If Not FileSystemObject.FolderExists(CompleteImagesFolderPath) Then RandomImage = "Error 0: Cannot find requested folder" Set FileSystemObject = nothing Exit Function End If Set ImageFolder = FileSystemObject.GetFolder(CompleteImagesFolderPath) Set Files = ImageFolder.Files i = 1 For Each File in Files FileName = File.Name FileExtension = Right(FileName, Len(FileName) - (InStrRev(FileName, "."))) If InStr(1,ImageFileTypes,FileExtension,vbTextCompare) > 0 then ImageFiles.Add i, FileName i = i + 1 End If Next Set ImageFolder = nothing Set Files = nothing Set FileSystemObject = nothing Randomize If ImageFiles.Count = 0 Then RandomImage = "Error 1: Folder no existe" Exit Function End If RandomNumber = Int((ImageFiles.Count) * Rnd + 1) Final = CompleteImagesFolderPath&"\"&ImageFiles.Item(RandomNumber) WshShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Desktop\General\Wallpaper",Final,"REG_SZ" WshShell.RegWrite "HKEY_CURRENT_USER\Control Panel\Desktop\Wallpaper",Final,"REG_SZ" 'CompleteImagesFolderPath&"\"&ImageFiles.Item(RandomNumber) Set ImageFiles = nothing WSHShell.AppActivate strDesktop WSHShell.SendKeys "{F5}" End Function ============================================================================ === could you help me please?? the script does change the registry values but does not change the wallpaper thanks a lot Tag: Chk'ing the version on a file... Tag: 161813
  - 9
    - How to check for non-existant property Hi all, Using VB6 or VBScript: What is the "best practice" method for checking if a property exists or not? For instance oUser.AccountExpirationDate. Thanks. -- Tim Tag: Chk'ing the version on a file... Tag: 161809
  - 10
    - create performance counters and categories Either from script or from the Windows Installer libraries, is it possible to programatically create performance counters and categories? I need to put this functionailty into a VBScript custom action and need to try to avoid using the .net route. -EP (sorry for all the newsgroups but each one I posted to I thought was relevant) Tag: Chk'ing the version on a file... Tag: 161808
  - 11
    - Opening a word doc as a template and then save into a server with ip address Hi there, I am using htm and asp to write a web applicaiton, which opens a word template located in its sub folder. Then my app will ask the user to input whatever info required and then I will populate the word doc according without opening the word doc to the user explicitly. Then the newly created file will be saved to a server (ip address available). I just wonder how this can be accomplished, if I try to use client-side vbscript, I was not able to use fso.copyfile to copy file from URL to a server. Besides, when I open the word doc, even explicit saying the wordobject is invisible it still ask me question if I want to open it read-only or ....but I don't want the user to see the template at all. If I user server-script in an asp, I won't be able to use server.createobject(word.application), so how can I open the word doc and change it then? Please advice me the best way the get this done... Thanks in advance. Any help will be greatly appreciated. Wanda Tag: Chk'ing the version on a file... Tag: 161806
  - 12
    - enumerate folder/File permissions I want to have my script check if the permissions on a folder or file are set for a User, then if not set, set them. I have the script to set the folder/file permissions but how do I use VB to check the next time the script runs that the permissions exist. thanks in advance Tag: Chk'ing the version on a file... Tag: 161804
  - 13
    - OnClick (sub is undef) Hi, In my ASP application I try to display an help text a secondary window doing the following and I get the message "ShowHelp is Undefined" What am'I doing wrong? Any help will be appreciated. sub ShowHelp Response.Write "<FORM NAME=FrmHelp " & _ "TARGET=Name>" & _ "<INPUT TYPE=HIDDEN NAME=Language VALUE=" & sLang & "></FORM>" %><Script>window.open("Help.asp","FrmHelp","width=700,height=400, Left=80, top=80, Titlebar=1, resizable=1, scrollbars=1, toolbar=0");</Script><% end sub %> <A HREF="Help.asp" OnClick="ShowHelp"><%Response.Write sHelp%></A></TD> Thank you in advance serge Tag: Chk'ing the version on a file... Tag: 161799
  - 14
    - ADODB.Command error '800a0bb9' Hello All, Hoping for a little help. I'm using a parametered sql stored proc to accept and return variables to my asp page. The SP works fine as I've tested it separately. The error and code is below. Fairly new to asp, all comments are appreciated. Thanks in advance, R Here is the error: ADODB.Command error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /gplogout.asp, line 83 Here is my asp: <% Dim objConn Dim objCmd Dim txtUser Dim txtPswd dim txtloggedout 'Form Values txtUser = request.form("txtUserName") txtPswd = request.form("txtPassword")  Set objConn = Server.CreateObject("ADODB.Connection") objConn.open "Provider=SQLOLEDB;Data Source=SQLServer;Initial Catalog=MYDB;User ID=UserName;Password=1234" set objCmd = Server.CreateObject("ADODB.Command") With objCmd .ActiveConnection = objConn .CommandText = "X_storedproc_test" .CommandType = 4 'adcmdstoredproc 'Requires the adovbs.inc file or typelib meta tag 'Add Input Parameters .Parameters.Append .CreateParameter("@UName", adVarChar, adParamInput, 30, txtUser) .Parameters.Append .CreateParameter("@Pswrd", adVarChar, adParamInput, 30, txtPswd) 'Add Output Parameters .Parameters.Append .CreateParameter("@loggedout", adInteger, adParamOutput) 'Execute the function .Execute, , adExecuteNoRecords 'Extract the output parameter which the SP has supplied from the parameter collection' txtloggedout = .parameters("@loggedout") End With 'Update the user Tag: Chk'ing the version on a file... Tag: 161792
  - 15
    - Script for removing dialup connections Does anyone have a script for "removing" dialup connections from windows 2K\XP workstations? These connections are configured under the user, not the system. Thansk, Kevin Tag: Chk'ing the version on a file... Tag: 161791
  - 16
    - connecting printers on samba in a vbs script? Hello, I am trying to write a vbs script that replaces the need for the user to connect printers by right-clicking a printer and choosing 'connect'. I am using the following code: ' declare variables dim wshnetwork ' set reference to WSH network object set wshnetwork=wscript.createobject("wscript.network") ' add connection to a network printer hpintel on samba (ibm-nas) wshnetwork.addwindowsprinterconnection "\\samba\hpintel" The problem is that the printer is on samba and I am trying to connect to it as a local administrator. The way I would do it manually is connect to \\samba and enter my login and password in the domain and then 'connect' the printer. However, if I were to run the script as an administrator I wouldn't have the opportunity to authenticate with samba. Therefore I tried using the "runas" command to run the script as a domain user. I used the /netonly option. This worked as far as the printers showing up on the "printers and faxes" window. But they appeared with the status: "access denied. unable to connect" and when I tried to print I got the error message: "Cannot print the file. Be sure that your printer is connected properly and use Control Panel to verify that the printer is configured properly." What should I do? Is there any way to simulate connecting to samba as a known domain user and then adding printers? Thanks, Aviv. Tag: Chk'ing the version on a file... Tag: 161790
  - 17
    - Password changes on different domains Hi There I have got a user who works between to different Windows 2000 domains (Lets say D1 and D2). Her computer is joined to domain D1. She has also got a user account on D2, but obviously if I join her computer to D2 she will be disjoined from D1 (which we don't want). I have managed to get her working on D2 in all respects but managing her password seems troublesome. I've created a vbscript to change her password on D2, but then she must be logged onto the D2 domain to be able to run it. Does anyone have an idea or a solution for me Regards Tag: Chk'ing the version on a file... Tag: 161788
  - 18
    - Sort a dictionary Hi I'm trying to sort a Script Dictionary. It has a string value in the keys & an Object in the items (an AutoCAD layer object in this instance). 1. I can swap the keys (string) values as shown below, but the Items (object) won't budge Where an I going wrong?. 2. is there a way to swap both Keys/Items in one go ie Dict(0)=Dict(5) instead of doing them separately? 3. I've seen a routine on MSN for sorting a dictionary http://support.microsoft.com/default.aspx?scid=kb;en-us;246067 That sorts a string based dict, but a) I don't know how to change it so it can accept objects & b) it creates arrays to do the sorting which confuses me because I thought = Dict.Keys returns an array anyway. Thanks in advance Dave F. Sub test() Dim LayObj As AcadLayer Dim DictSort As Variant Dim Dict As New Dictionary ' script dictionary (scripting runtime ref) Dim KK As Variant, It As Variant With ThisDrawing For Each LayObj In .Layers Dict.Add LayObj.Name, LayObj ' store it - Key:Layer Name, Item: Layer Object Next ' Lay End With ' thisdrawing KK = Dict.Keys It = Dict.Items ' these are OBJECTS not strings KK(0) = KK(5) 'swaps the keys It(0) = It(5) End Sub Tag: Chk'ing the version on a file... Tag: 161786
  - 19
    - Problem of MSXML2.XMLHTTP Hi, I have a server side of asp which generate rows of data from DB in real time (around 1500KB of data, 4000 row of data) my client side get the result using MSXML2.XMLHTTP when the result is very small, e.g. 1 row, the result is as expected. However, when the rows number grow , e.g. 4000 row, only the first 2 row data is back. is this the limit of MSXML2.XMLHTTP? Here is my code.... '------------------------------------------------- Set xhttpPost = creatobject("MSXML2.XMLHTTP") With xhttpPost .Open "GET", url, False .send "" Do While .readyState <> 4 DoEvents Loop wscript.echo .responseText End With Set xhttpPost = Nothing Tag: Chk'ing the version on a file... Tag: 161785
  - 20
    - Permission denied: 'GetObject' while trying to get list of processes on remote comp. This is the code, pasted from "The Portable Script Center": strComputer = "JEFF" Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colProcesses = objWMIService.ExecQuery _ ("Select * from Win32_Process Where Name = 'Database.exe'") If colProcesses.Count = 0 Then Wscript.Echo "Database.exe is not running." Else Wscript.Echo "Database.exe is running." End If I get Permission denied: 'GetObject' on line 2 of this script. Why is this happening, and how can I fix it? Drazen Tag: Chk'ing the version on a file... Tag: 161784
  - 21
    - Displaying xl-worksheets in IE Hi I have a application whith three frames. In the third frame ("Results") I want to display an excel-generated report (the report is generated through VBA macros, which run when the template is opened (auto_open sub), collecting the data from an SQL Server). Normaly, in Excel, the template creates an instans of itself (resultning in an .xls-file). I want my application to do the same, that is, I want the template (xlt) to create an instans (xls), load the data into the xls-file and then display the xls-report in the fram "results". I'm quite new to VB-Script and I've only manged to come up with the following code, in report.asp: <SCRIPT LANGUAGE=VBScript RUNAT=Server> Dim xlApp Dim xlWb Dim xlSheet Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Open("c:\data\report.xlt") Set xlSheet = xlWb.Worksheets(1) xlSheet.Name = "Report1" xlApp.Visible = True Set xls = Nothing Set xlb = Nothing Set xlapp = Nothing </Script> This doesn't work. I think I don't get any error messages, though, and the CPU on the server is working for about 5 secs, so I think the report is generared but not displayed on screen(?). Excel 2000 is installed on the server. Can anyone help me please? Regards PO Tag: Chk'ing the version on a file... Tag: 161778
  - 22
    - edit text entries... I have a batch file that reads a text file and displays certain strings back using the 'findstr' command. Some strings that the batch returns contain HTML code. The string looks something like this: Important text1: <A HREF="/cgi-bin/blah/blah>Important text2</A> I was wondering if there is a way to create a vbs file to remove the HTML code from the text file. Any help will be appreciated ;) -ghettocow Tag: Chk'ing the version on a file... Tag: 161774
  - 23
    - Parse Veritas Backup Logs to Excel I need to parse portions of my Veritas backup logs (BEXXX.TXT) to an Excel spreadsheet to which I can apply pivot tables to analyse my backups. I would like to use Windows scripting if possible. Any Ideas? Please post here, no emails thx. Thanks in advance. Tag: Chk'ing the version on a file... Tag: 161772
  - 24
    - Log all Sucsessfull and Failed Logins Im looking for a script that will read the Security Event Log on a w2k3 server from the previous day and email to an email address. I can't seem to get it the qry to return both the previous days Successful / failed logins along with the date qry. Does anyone know of a script or can point me in the right direction Regards Don Grover dgrover@assoft.com.au Tag: Chk'ing the version on a file... Tag: 161769
  - 25
    - Space inside a command line. Good day, Im trying to create a script that runs a command line with an argument the problem is that the argument has space in side it, and im having trouble working out the command line, here is the command with the argument: Set WshShell = WScript.CreateObject("WScript.Shell") rCommand = "runas /user:Domain\suorenz "mmc %windir%\system32\management.msc"' WshShell.Run rCommand, 0, TRUE Thanks in advance -- Oren Zippori eAladdin.com Tag: Chk'ing the version on a file... Tag: 161762

I'm not sure if this is the correct place to ask, but I need to be able to
check the version of a file I know it can be done by:

Set objFSO = CreateObject("Scripting.FileSystemObject")
Wscript.Echo objFSO.GetFileVersion("path to file")

I need a WMI equivalent or something that can be run remotely against a list
of computer names.

Thanks
-Chad

Top

Re: Chk'ing the version on a file... by Joseph

Joseph
Wed Aug 18 17:10:05 CDT 2004

filever.exe in the win2k support tools should work

"Chad Manzer" <ChadManzer@discussions.microsoft.com> wrote in message
news:C782BF79-E141-4B6A-9E1D-018B6C8F86F5@microsoft.com...
> I'm not sure if this is the correct place to ask, but I need to be able to
> check the version of a file I know it can be done by:
>
> Set objFSO = CreateObject("Scripting.FileSystemObject")
> Wscript.Echo objFSO.GetFileVersion("path to file")
>
> I need a WMI equivalent or something that can be run remotely against a
list
> of computer names.
>
> Thanks
> -Chad

Top