Format Date Syntax Problem

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
    - InternetExplorer.Application / objShell.Windows + obj.document.parentWindow Hey, I finally found out how to access the window properties of an InternetExplorer.Application / objShell.Windows objects. First I thought this wasn't even possible, since the InternetExplorer.Application / objShell.Windows objects basically represent the window themselves, so the next DOM level is the document: set objShell = CreateObject("Shell.Application") set objShellWindows = objShell.Windows set FirstWindow = objShellWindows.Item(0) WScript.Echo FirstWindow.document.nodeName ---------------------------------------------------- Set objIE = WScript.CreateObject("InternetExplorer.Application","objIE_") WScript.Echo objIE.document.nodeName But on this page: http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/parentwindow.asp Microsoft tells us about the parentWindow Property of the document. This way you can move again upwards the DOM to the window object and access all of its properties: Set objIE = WScript.CreateObject("InternetExplorer.Application","objIE_") WScript.Echo objIE.document.parentWindow.name will return the name of the current Internet explorer window, whereas WScript.Echo objIE.name will return the name of the objShell.Windows (="Internet Explorer") Also, it would be interesting to convert the entire VB/VBA syntax for the WebBrowser control to VBScript, since there is no reference on MSDN for the VB Scripting edition: http://msdn.microsoft.com/workshop/browser/webbrowser/reflist_vb.asp For example, the MSDN VB reference for the NavigateError event of the IE/WebBrowser objects reads as follows: Private Sub object_NavigateError( _ ByVal pDisp As Object, _ ByVal URL As Variant, _ ByVal TargetFrameName As Variant, _ ByVal StatusCode As Variant, _ ByRef Cancel As Boolean) In order to use this event in VBScript, it has to look like this: Sub objIE_NavigateError(pDisp,URL,TargetFrameName,StatusCode,Cancel) wscript.echo "objIE_NavigateError" End Sub Here's a script that will change the name property of the InternetExplorer.Application object every time you open a new document or download a file: ON ERROR RESUME NEXT Set objIE = WScript.CreateObject("InternetExplorer.Application","objIE_") objIE.Visible = True objIE.Navigate2 "http://www.google.com" Do While objIE.Visible WScript.Sleep 1000 Loop Sub objIE_NavigateComplete2(pDisp, URL) objIE.document.parentWindow.name = "_new" End Sub Sub objIE_FileDownload(ActiveDocument,Cancel) if (objIE.Document.all.length > 0) then objIE.document.parentWindow.name = "_new" end if End Sub Sub objIE_OnQuit() WScript.Quit End Sub I am still trying to get the NewWindow3 Event to fire through VBScript: http://msdn.microsoft.com/workshop/browser/webbrowser/reference/events/newwindow3.asp I wonder what the VBScript syntax for this event is Tag: Format Date Syntax Problem Tag: 201802
  - 2
    - If Then Exit Do I have created a user creation script. It reads user attributes from a text file and creates one user at a time. It basically runs like While there are rows in the text file Do read value1 read value2 read value3 read value4 do a whole bunch of stuff (set attirbutes, add users to groups, etc) Loop Let's say though that value2 must be exactly 6 digits in length. If not, the script should fail creating this user account and move on to the next. I thought of using Exit Do, but won't that end the script rather then moving to the next user? Is there a way to do this. I just figure it would be faster and make the most sense to stop the creation of the specific account and move on to the next one. Tag: Format Date Syntax Problem Tag: 201791
  - 3
    - Modifying the Registry Hi, Here's my problem: I want to shedule on legacy Windows Servers (Windows 2000 Servers) to run the Sysinternals contig.exe application, which is very useful and powerful to defragment drives and folders. But before running the contig.exe, you have to accept the EULA by clicking on the "I accept" button of a pop-up window. Once accepted, several keys and a dword are added to the registry. I want to schedule this task by using a "special user" allowed to connect as a batch job only. It doesn't have any profile, and, very important, doesn't have any keys in the registry under the HKEY_USERS. Once running this script for the first time by the scheduler, the EULA pop-up is not displayed, so no new keys can be added to the registry, and then the script cannot run and waits for the click on the "I accept the EULA" button. My goal is to create automatically the keys and the dword value before the schedule task runs this script, and then the EULA will be already accepted without clicking on this button. Can someone explain me why in the following script, the creation of the keys and the value is not working. Thanks a lot. The steps are: 1 - getting the SID of my special user 2 - creating the key with the SID under HKEY_Users 3 - creating all the key and subkeys for the Sysinternals contig application 4 - creating the new dword named "EulaAccepted" with a value of '1' ---------------------------------------------------- ' Get the Account SID of the user used by the scheduler strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set objAccount = objWMIService.Get("Win32_UserAccount.Name='user',Domain='domain'") accountSID = objAccount.SID ' Add the reg entry so it accepts the Sysinternals EULA Const HKEY_USERS = &H80000003 Set StdOut = WScript.StdOut Set objReg = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\default:StdRegProv") strKeyPath = accountSID Wscript.Echo "Creating the key with the SID: " & strKeyPath objReg.CreateKey HKEY_USERS,strKeyPath strKeyPath = strKeyPath & "\Software" Wscript.Echo "Creating the key with Software: " & strKeyPath objReg.CreateKey HKEY_USERS,strKeyPath strKeyPath = strKeyPath & "\Sysinternals" Wscript.Echo "Creating the key with Sysinternals: " & strKeyPath objReg.CreateKey HKEY_USERS,strKeyPath strKeyPath = strKeyPath & "\C" Wscript.Echo "Creating the key with C: " & strKeyPath objReg.CreateKey HKEY_USERS,strKeyPath strEntryName = "EulaAccepted" dwValue = 1 Wscript.Echo "Setting the value of " & strEntryName & " to " & dwValue objReg.SetDWORDValue HKEY_USERS,strKeyPath,strEntryName,dwValue objReg.GetDWORDValue HKEY_USERS,strKeyPath,strEntryName,dwValue Wscript.Echo strEntryName & " = " & dwValue ------------------------------------------------------ And here's the output: ============================== accountSID = S-1-5-21-2304659736-2020637620-97400744-1039 Creating the key with the SID: S-1-5-21-2304659736-2020637620-97400744-1039 Creating the key with Software: S-1-5-21-2304659736-2020637620-97400744-1039/Software Creating the key with Sysinternals: S-1-5-21-2304659736-2020637620-97400744-1039\Software\Sysinternals Creating the key with C: S-1-5-21-2304659736-2020637620-97400744-1039\Software\Sysinternals\C Setting the value of EulaAccepted to 1 EulaAccepted = =================================== Nothing is created in the registry. I am a local administrator of my server (not attached to any domain). Thanks again for your help. Yann Tag: Format Date Syntax Problem Tag: 201788
  - 4
    - running a vbs script in scheduled task I believe I saw this topic before but I cannot see any suggested solution. My question is: I got a vbs script that runs perfectly if I execute in a cmd shell cscript sample.vbs > outfile All output is captured in the outfile. If I put the same line in a schedule task, the task will be executed but no output is captured in the outfile. How can I overcome this? Thanks for any suggestion. PS. Please do not suggest amending the vbs script itself to capture the output. This is not a solution. Tag: Format Date Syntax Problem Tag: 201778
  - 5
    - call a batch file within VB script??? I am newbie with scripting and programming. I have a VB script that run a ping.exe command to see if the other server is up. The ping.exe VB scripts works fine but I would like to include a statement where if the ping command return request time out (the other server is down) instead of a reply (meaning the other server is up) then it will call the batch file call service.bat. here is my code for the ping VB script and the batch file. How could I do this? Ping VB Script: Set objShell = CreateObject("WScript.Shell") Set objWshScriptExec = objShell.Exec("ping 10.0.0.1 -t") Set objStdOut = objWshScriptExec.StdOut Do Until objStdOut.AtEndOfStream strLine = objStdOut.ReadLine If Len(strLine) > 2 Then WScript.Echo Now & " -- " & strLine Else Wscript.Echo strLine End If Loop Batch File to start Windows Service sc start WZCSVC Tag: Format Date Syntax Problem Tag: 201772
  - 6
    - VBScript calling a function with onclick I'm trying to call a vb function in an asp page. I'm using the following code: <table> <tr> <td valign="top" width="200" align="left"> <% Response.Write "<input type='image' src='images/header_collapsed.jpg' onClick='ShowAspLog'>" %> <font size=2 color="0000FF">ASP Log </font> </td> </tr> </table> The Function is: <% Function ShowAspLog Response.Write "<table>" Response.Write "<tr>" Response.Write "<td>" Response.Write "<td valign=top>" & getSQLTable("SELECT date as Date, action as Action, comment as Comment FROM RPSSAspLog WHERE client = " & Request.QueryString("client") & " and (date > GETDATE() - 180) ORDER BY date DESC") & "</td>" Response.Write "<td width=20></td>" Response.Write "</td>" Response.Write "</tr>" Response.Write "</table>" End Function %> The image is displayed but when I click it I get an error on the page. Any ideas? Tag: Format Date Syntax Problem Tag: 201758
  - 7
    - ping and start a service on remote server Hi! I am a newbie with programming. I have two Windows 2003 servers. Both servers have the same service that only one can run at one time. I would like to create a script that would check the network status of Server A using ping.exe. If the ping fail on Server A, Server B will start the service. I figure out how to write teh ping but not sure how to incorporate the other step. Set objShell = CreateObject("WScript.Shell") Set objWshScriptExec = objShell.Exec("ping 10.0.0.1 -t") Set objStdOut = objWshScriptExec.StdOut Do Until objStdOut.AtEndOfStream strLine = objStdOut.ReadLine If Len(strLine) > 2 Then WScript.Echo Now & " -- " & strLine Else Wscript.Echo strLine End If Loop Tag: Format Date Syntax Problem Tag: 201754
  - 8
    - VBScript to enumerate all members of groups Just some background: My organization is an OU within a larger OU. Within my organizational unit I have OU's for Users, Computers and Servers. Within my Users OU, I want to dump the membership of all the groups into a text file. Which I can then import into excel. Anyone have any pointers or example scripts I can look at? Thanks Chris Tag: Format Date Syntax Problem Tag: 201752
  - 9
    - Change local Admin Pwd - [WP] How can I change local admin pwd w/o going to the machines? I don't wont my pwd to be visible if I am pushing via GPO, BAT or Script? How would Microsoft do this, do they rely on third party, my guess No???? Advise Please. Tag: Format Date Syntax Problem Tag: 201751
  - 10
    - Logoff Backup script doing nothing Not sure if this is the right news group, if not i apologise I have written a simple vbs script to backup our users outlook express files on a certain day that i am trying to get running at logoff by group policy the script is below: Dim MyDate, MyWeekDay MyDate = Date MyWeekDay = Weekday(MyDate) If MyWeekDay = 6 Then Dim oShell Set oShell = WScript.CreateObject ("WSCript.shell") oShell.run "cmd /K C:\WINDOWS\system32\ntbackup backup ""c:\documents and settings\%username%\local settings\application data\identities"" /j ""Mail Backup"" /F ""\\Mailserver\Mail Backup\admin\%username%\%username%.bkf"" /V:yes" Set oShell = Nothing Else End If Now when the script is run form my documents folder (or anywhere else for that matter) it runs fine, it will check the day and proceed if it is correct. However when it is deployed by group policy the script does not appear to run (i.e. backup does not start) even though it claims to be running logoff scripts, is there something in the code that might prevent this? Cheers in advance Tag: Format Date Syntax Problem Tag: 201749
  - 11
    - Script that uses an array of file names to copy and overwrite file I need to copy and overwrite a number of files programmatically and I'd like to know how to modify the following code from technet to use an array of "copy from" names. 'starting point Const OverwriteExisting = TRUE Set objFSO = CreateObject("Scripting.FileSystemObject") objFSO.CopyFile "C:\FSO\ScriptLog.txt" , "D:\Archive\", OverwriteExisting 'end starting point 'start pseudo code dim ary(3) ary(1) = "C:\FSO\ScriptLog1.txt" ary(2) = "C:\FSO\ScriptLog2.txt" ary(3) = "C:\FSO\ScriptLog3.txt" Set objFSO = CreateObject("Scripting.FileSystemObject") For i = 1 to 3 ' something on the lines of: objFSO.CopyFile "" & ary(3) &"" , "D:\Archive\", OverwriteExisting Next 'end pseudo code Any help will be greatly appreciated. Thanks, Raul Tag: Format Date Syntax Problem Tag: 201735
  - 12
    - script that uses an array copy an array of file names I need to copy and overwrite a number of files programmatically and I'd like to know how to modify the following code from technet to use an array of "copy from" names. 'starting point Const OverwriteExisting = TRUE Set objFSO = CreateObject("Scripting.FileSystemObject") objFSO.CopyFile "C:\FSO\ScriptLog.txt" , "D:\Archive\", OverwriteExisting 'end starting point 'start pseudo code dim ary(3) ary(1) = "C:\FSO\ScriptLog1.txt" ary(2) = "C:\FSO\ScriptLog2.txt" ary(3) = "C:\FSO\ScriptLog3.txt" Set objFSO = CreateObject("Scripting.FileSystemObject") For i = 1 to 3 ' something on the lines of: objFSO.CopyFile "" & ary(3) &"" , "D:\Archive\", OverwriteExisting Next 'end pseudo code Any help will be greatly appreciated. Thanks, Raul Tag: Format Date Syntax Problem Tag: 201733
  - 13
    - Mapping Problem I administer a hospital network using a Win2003 domain. I have a requirement to also provide service for some applications to medical offices that are not part of my domain. Most of these offices connect to my domain using either a client or a site-to-site VPN. To connect to a recent deployed application I wrote a VB script that maps a drive then calls the application. Problem is that sometimes the application starts before the drive is mapped. Some of the VPN connections are slow and it may take 30 secs or more to get the drive mapped. When this happens the application fails to run. How can I change my script so that the application is not called until the mapping is successful? My script follows. '*********************************************************************** 'Script: HealthPort_Map 'This script maps a drive for healthport then calls the application '************************************************************************ On Error Resume Next Dim objNetwork, objShell Set objNetwork = CreateObject("WScript.Network")objNetwork.MapNetworkDrive "Z:", "\\Nazgul\Healthimages",,"NVh1\password" Set objShell = WScript.CreateObject("WScript.Shell") ObjShell.Run "C:\HP.lnk", 1, True -- Tag: Format Date Syntax Problem Tag: 201731
  - 14
    - RegEx Part 2 I'm reposting this because I had said that I was finished with the previous thread, but then this came up... I have another problem (I'm really bad at RegEx)... and I spent the last few hours looking for a resolution... I want to remove all the double double (""a"") quotes, and replace them with single double ("a") quotes... but In my file I have the following: =""2"" (not valid) But also, ="" (valid) Sometimes there is a space at the end followed by another tag: =""3"" FrameId=""BR1"" and sometime not, =""8wR4""> And sometimes the value is correct: ="1" Ayush or anyone following this thread - if you can help that would be great - I will continue with the 'trial and error', but so far no luck. Tag: Format Date Syntax Problem Tag: 201721
  - 15
    - MI5 Persecution: A doubting Thomas is heard 9/5/95 (1189) From: pao1@ukc.ac.uk (P.A.Orrock) Newsgroups: uk.misc Subject: Re: BBC's Hidden Shame Reply-To: pao1@ukc.ac.uk (P.A.Orrock) Date: Tue May 9 05:54:20 1995 >have laws that protect the individual from harassement - >you can't just threaten people willy nilly. There are laws >against that. And if someone lies about you in the press >or tv then you have recourse to libel/slander etc. laws. Yup, agreed >True, Britain has no 'privacy' laws as such, but isn't that >a good thing? As of this moment, the govt. are considering >a privacy law, but it is unlikely to succeed. Why? Because any >such law would benefit the priviledged and those in power. >Privacy laws, while supposedly protecting the individual, help >those in power hide their mistakes/scandals. They stop the press >etc. investigating. Privacy laws are undemocratic - they prevent >the people from keeping an eye on govt. Agreed again. >Douglas. I am slightly confused here as to who is writing what. this just seems to be an amalgam of posts and replies posted to here to keep the thread going. >Confession time - the victim is/was me (except my name isn't >Corley, but that's irrelevant). What happened was not threats; >just invasion of privacy, in a partiicularly flagrant and >shocking way, in a way which most people would consider to >constitute harassment. >You know there's a particular category of person with mental >illness to whom TV and radio "talk", ie they feel the broadcast >is directed at them in particular? This happpened to me, You mean the category where they think that everyone is after them ? that one ? So lets get this straight you know you are paranoid and you think that they are out to get you ? Uh huh, try putting the two together and see what you come up with. >quite some time ago in the UK (I'm originally from London >so I've seen plenty of British media print and other). >They invaded my home with their bugs, they repeated what I >was saying in the privacy of my home, and they laughed that it >was "so funny", that I was impotent and could not even communicate >what was going on. Who did this? Our friends on BBC television, >our friends in ITN, last but not least our friends in Capital >Radio in London and on Radio 1. Oh yeah, I can see it now. All of them banding together, in a united effort against one man. So ITN, the BBC, and Capital all decide to sit round the table and they come up with idea of breaking into someones house, putting bugs everywhere, listening in to his conversation, and shoving it out on the news everyday. This someone has nothing to do with politics, or business, or entertainment, just an ordinary Joe Bloggs who seems to be extremely paranoid. Have some sense, grow up and smell reality. What you are talking about would take loads of planning, tens of thousands of pounds and lots of people involved in the planning, execution and maintenance of it. You must have a very high opinion of yourself to think you are worth it. >How did they do this? I'll give you an example. About a year ago, >I was listening to Chris Tarrant (Capital Radio DJ among other >pursuits) on his radio morning show, when he said, talking about >someone he didn't identify, "you know this bloke? he says we're >trying to kill him. We should be done for attempted manslaughter" >which mirrored something I had said a day or two before >(I'm not paranoid, honest!). Now that got broadcast to the whole >of London - if any recordings are kept of the shows then it'll be >there. Of course you are not paranoid, just slightly mad. Did you ever look for the bugs in your house ? If not, why not ? I mean if I thought that was happening to me, I'd search the place from top to bottom, I mean I live there I would know if anything was out of place. If I was really paranoid, whoops I mean suspicious, I would call in one of those bug detection teams which have those machines that pick up the transmitted radio waves. This reminds me of BUGS, that new programme on BBC1 on saturdays which is all about this kind of stuff, but, shown as a drama / thriller. I suppose thats based on you as well is it ? >is that there is a conspiracy in Britain, that it encompasses the >broadcast media, and there is no way of breaking the conspiracy. >The people who are involved in it will not open up. What a load of jolly hollyhocks, I would say something else but, apparently students are not allowed to swear on newsgroups in case it damages the reputation of the university or some such jolly hollyhocks. This guy is extremely paranoid to suggest that the entire British media is after him in such a big way. He gives no real reason as to why they are after him, just that he suffers/suffered from a slight mental disorder, could it be paranoia perhaps ?? No surely not. I put it to the house that he has never recovered from this mental disorder, lets come out with it and call it paranoia, and thinks everyone is after him. Remember just because you aren't paranoid, doesn't mean they aren't after you. This guy has a serious problem to suggest that the media would go to such lengths just to single out and ridicule one person. I mean apart from anything else, we ( the listening masses) wouldn't be interested unless it concerned the royal family, politicians or showbiz personalities. e.g. the camillagate tapes. I would think that almost everyone, no matter how much they went on about infringements of privacy read the transcripts with interest. I really don't think that Joe Bloggs ordinary guy or paranoid nutter would have the same appeal. Well actually I dunno. :) Regards, Paul. -- Paul Orrock, Websurfer wannabe, http://www.idiscover.co.uk/paul/home.html PC Consultant and HTML freelance Writer, http://www.idiscover.co.uk/paul/ =========================================================================== Diplomacy is the art of saying "nice doggy" until you can find a rock. 1189 -- Posted via a free Usenet account from http://www.teranews.com Tag: Format Date Syntax Problem Tag: 201714
  - 16
    - Outlook Public Calenders Any ideas ... I'm trying to write a script that will sync any data in a public calendar to a personal calendar. Exchange 2003 / Outlook 2003 -- Kevin Callanan MSCA 2003, A+, Network+ www.weblabtechs.com Please let us know if this response was helpful... Tag: Format Date Syntax Problem Tag: 201708
  - 17
    - MI5 Persecution: Intelligence agency sources on the Web (1189) Intelligence agency sources on the Web http://intelweb.janes.com/ Intelligence Watch Report covers public and private intelligence agencies around the world. kim-spy http://www.kimsoft.com/kim-spy.htm The Korea WebWeekly kim-spy Intelligence and Counter-Intelligence link page. http://www.lobster-magazine.co.uk/ Lobster Journal publishes research on the intelligence community. http://cryptome.org/ Cryptome is an online source of intelligence related material. http://www.mi5.gov.uk/ MI5 has a website, too, but you should prepare yourself for some serious "alternative reality" if you plan to visit it. 1189 -- Posted via a free Usenet account from http://www.teranews.com Tag: Format Date Syntax Problem Tag: 201707
  - 18
    - number of logon users per domain controller per day Hi , I am trying to find the number of users logging on to either each domain controller or per domain. I am not sure how domain controller keeps track of logon users. I would need to generate a report that shows how many users are logging on to domain per day OR how many users logging on to each DC per day. I will appreciate if you can help me in finding. If anything available in MOM 2005 then it would be very helpful Thanks Saeed A Tag: Format Date Syntax Problem Tag: 201705
  - 19
    - Reset AD property to null How can I reset an AD property to null, like the comment on a Computer in AD? Tag: Format Date Syntax Problem Tag: 201700
  - 20
    - Return all users except built-in How can I return a list of AD users, omitting the built-in users? Tag: Format Date Syntax Problem Tag: 201699
  - 21
    - RegExp I have what seems to be a simple Expression but for the life of me I can't get it to work: What I want to do is replace the information between tags with vbCrLf: This: ... Rule>" jhsadkjsk asjlksd lkjlsadj "<Rule Id ... With This: ... Rule> <Rule Id ... Here is the code: Set objRegExp = New RegExp objRegExp.IgnoreCase = True objRegExp.Global = True objRegExp.Pattern = "[Rule>.<Rule Id]" strNewText = objRegExp.Replace(strNewText, "Rule>" & vbCrLf &"<Rule Id") Set objRegExp = Nothing Thank you in advance for your help! Tag: Format Date Syntax Problem Tag: 201686
  - 22
    - Win32_NTEventlogFile Hi All Not sure if anyone can help. I am running the query "select * from Win32_NTEventlogFile" on several servers and desktops with varying results. In addition to the standard logs SYSTEM, APPLICATION and SECURITY I have another log "MYLOG" that is created and appended to by several in house applications. Unusually, if I run the above query on an Server 2003 without a SP1 I do not get the instance of my own log file "MYLOG" returned. If I run the query on a Server 2003 with SP1 then I do. I also seem to be unable to find the instance on any XP SP2 machines. Furthermore, to add to the confusion the Win32_NTLogEvent table does contain events for all 4 logs including my inhouse eventlog "MYLOG". Does anyone have any ideas on what may be going wrong? I would like to be able to use the ClearEventlog method on my Win32_NTEventlogFile instance. Tag: Format Date Syntax Problem Tag: 201685
  - 23
    - Delete Rows In Excel, I need a macro that will delete an entire row based on a name entered into an input box that would match a worksheet with that name in column "A". Thanks, Bernie Tag: Format Date Syntax Problem Tag: 201682
  - 24
    - Copy random files from one folder to another Hi everyone, I'm trying to create a script that gives the user the option to select a source folder and a destination folder. What I want to do is: - delete all files in destination folder - randomly, copy files from the source folder to the destination folder, until destination folder is full But I'm having trouble with the second part, since I don't know how to use the Rnd function to randomly select files in the source folder. Any ideas? Thanks, from Spain Tag: Format Date Syntax Problem Tag: 201680
  - 25
    - VBScript or VB.Net? Hi All, I need to write a program/script that gathers some data from Windows systems, compare it with SQL Database and update if it's changed. My question is what should i use? VBScript or VB.Net? Here is my background.. I am a systems administrator. I have experience with: C, C++, Visual C++, VBScript I know little bit about: VB 6.0, Java I don't know anything about: dotNet (but would like to learn :) ) I am sure that i can do my task with VBScript. But since this is not going to be a small script/program, should i go with more powerful language like VB.Net even though i don't know much about it? Based on my experience, do you think i should go with VB.Net? or just stick to VBScript? Thank you all for your help. Tag: Format Date Syntax Problem Tag: 201678
- Next
  - 1
    - Question about looping a script Hi, I'm using the below script to map a drive: ====== Dim objNetwork Set objNetwork = CreateObject("Wscript.Network") On Error Resume Next objNetwork.RemoveNetworkDrive "G:" objNetwork.MapNetworkDrive "G:", "\\domain1dc1\test" ====== What I'd like to do is put in a loop command so it if it fails to map the G drive (ie, the share isn't available at that time) it keeps trying until it is successful. I'd also like to set this loop to time out after 5mins if that's possible? Could someone show me how this is done? Thanks, Curtis. -- Please reply to news group only. Thank you. Tag: Format Date Syntax Problem Tag: 201661
  - 2
    - word.applicaton, Object required: '[undefined]' Hello I'm trying to make some kind of a news administration, so the administrators should be able to upload or create new articels. Therefore i wanted to open a blank word document where they can write there article. At the moment my code looks like that: Set Word = CreateObject("word.application") word.visible = true Set Doc = Word.Documents.Add Not that much i know, but i alsways get the error Object required: '[undefined]' at the line of set doc = word.document.add Does everyone know what the problem could be. Thanks for any help Tag: Format Date Syntax Problem Tag: 201657
  - 3
    - getting error access denied on startup computer script through GPO hi, I've got some trouble getting my startup script running... i always get USERINIT error (ID 1000) : access denied. I've put everyone, anonymous logon, domain computers full access and same thing. do you know why ? here is my script : Dim strExePath, bolUpdateNeeded, objAgentInfo Dim intMajorVersion, objShell ' prefix with an UNC path if necessary strExePath = "c:\WindowsUpdateAgent20-x86.exe" bolUpdateNeeded = True ' init value, do not touch On Error Resume Next Set objAgentInfo = CreateObject("Microsoft.Update.AgentInfo") If Err.Number = 0 Then ' object exists, now check if ApiMajorVersion is 3 or higher intMajorVersion = 0 ' init value intMajorVersion = objAgentInfo.GetInfo("ApiMajorVersion") If intMajorVersion >= 3 Then bolUpdateNeeded = False End If End If On Error Goto 0 If bolUpdateNeeded Then ret = copy() if Err.Number = 0 then Set objShell = CreateObject("WScript.Shell") ' install the AU client objShell.Run strExePath & " /quiet /norestart", 1, True delete() End If function copy() dim FSys Set FSys = CreateObject("Scripting.FileSystemObject") Set MonFic = FSys.GetFile("\\10.x.x.x\WSUS\WindowsUpdateAgent20-x86.exe") ret = MonFic.Copy("C:\WindowsUpdateAgent20-x86.exe", True ) copy = ret set FSys = nothing end function sub delete() Set FSys = CreateObject("Scripting.FileSystemObject") Set MonFic = FSys.GetFile("C:\WindowsUpdateAgent20-x86.exe") MonFic.delete set FSys=nothing end sub the goal is to check windows update agent before the user login, and eventually to update it. thanks for your help, cause i'm really stuck. Tag: Format Date Syntax Problem Tag: 201656
  - 4
    - return users LDAP path I need help for some LDAP scripting. I need to know a specific LDAP path for a user... but how. input: Username output: cn=USERNAME,ou=HQ,ou=HADERSLEV,dc=DOMAIN,dc=NET" Is that possible... Best regards Henrik holm Tag: Format Date Syntax Problem Tag: 201653
  - 5
    - VBScript runtime error '800a0006' I have started getting this error on our production web server (Windows 2003 running IIS6). I don't get the error on my Notebook (XP SP2). The official error is "Overflow" but I have tried every variation I can think of to ensure there is no actual overflow. The code is as follows: <%@ LANGUAGE="VBSCRIPT" %>  <script language="VBScript" RUNAT=SERVER> Function CalcPremium(pState, pValue) Select Case pState Case "ACT", "NSW", "VIC", "TAS" currRate = CDbl(0.0028) currMin = 220 Case "QLD", "SA" currRate = CDbl(0.0024) currMin = 220 End Select currPremium = CDbl(pValue * currRate) If currPremium < currMin Then currPremium = currMin End If CalcPremium = CLng(currPremium) End Function </Script> <% Dim currContractValue Dim currPremium LogVisit Session("MemberID"), "InsuranceCalc" strMsg = "" If Request("SubmitBack") = "Return to Insurance Page" then Response.Redirect "construction.asp" End If If Not IsEmpty(Request("ContractValue")) Then If Not IsNumeric(Request("ContractValue")) Then currContractValue = Null strMsg = "Please enter a number as the Contract Value" else currContractValue = CLng(Request("ContractValue")) End If else currContractValue = Null strMsg = "Please enter a Contract Value" End If If IsEmpty(Session("CalcState")) or IsNull(Session("CalcState")) Then strState = Session("MemberState") else strState = Request("State") End If Session("CalcState") = strState If strMsg = "" then currPremium = CalcPremium(strState, currContractValue) strMsg = "ContractValue = $" & currContractValue & "; State = " & strState & "; Premium = " & FormatCurrency(currPremium,2) End If %> In this version the error occures on line 15 which is: currPremium = CDbl(pValue * currRate) I have explicitly converted pValue to a Long and currRate to a Double. What is also strange (apart from it working fine on my development machine), is that it actually calculates OK every second refresh. i.e. 1. Refresh - error 2. Refresh - OK 3. Enter new value or just Submit again - error 4. Refresh - OK Does anyone have any clues? I suspect it is a bug or setting in IIS. -- Kevin Seerup GoalMaker Pty Ltd http://www.goalmaker.com Tag: Format Date Syntax Problem Tag: 201651
  - 6
    - Need assistance with file delete script (date function) I am attempting to use a date function in the following script to delete any files (no folders or sub folders) within a certain directory, it can only delete anything from the previous year based on current date, for example if I run it now it should delete all files with a date stamp of 2006 or earlier, nothing in 2007. I just cannot get my head around Line 8 and the DateAdd syntax, please help, thx in advance... set Shell = CreateObject( "WScript.Shell") set fso = CreateObject( "Scripting.FileSystemObject") set SystemEnv = Shell.Environment( "SYSTEM") set ProcessEnv = Shell.Environment( "PROCESS") 'Anything from the previous year (based on today's date) will be deleted dtCutoff = DateAdd( "y", -1, Year()) 'Files will be deleted from this folder and all sub folders (no physical folders will be deleted) DeleteOldFiles fso.GetFolder( "S:\TEMP\Test"), dtCutoff function DeleteOldFiles( Folder, dtCutoff) 'Determine location and name of log file (log file appends itself) set logf = fso.OpenTextFile( "S:\TEMP\Deletelog.txt", 8, true) logf.WriteLine( Now & " " & Folder.Path) logf.Close on error resume next ' Delete old files from this directory for each File in Folder.Files if File.DateCreated < dtCutoff then WScript.Echo File.Path File.Delete end if next ' Delete old files from all sub directories for each SubFolder in Folder.SubFolders DeleteOldFiles SubFolder, dtCutoff next end function Tag: Format Date Syntax Problem Tag: 201648
  - 7
    - want to create script to auto delete folders Need to create an auto delete script to delete folders on a network computer 20 days old or more (creation date). Can someone help me please? I have no Idea how to write script... Tag: Format Date Syntax Problem Tag: 201647
  - 8
    - Printer spool loading detection This is a multi-part message in MIME format. ------=_NextPart_000_009C_01C73FF8.5D3A0030 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can I set up a listener to know when something is printed and have = it automatically sent to a second printer? TIA... Mark Ivey ------=_NextPart_000_009C_01C73FF8.5D3A0030 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.5730.11" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>How can I set up a listener to know = when something=20 is printed and have it automatically sent to a second = printer?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>TIA...</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Mark Ivey</FONT></DIV></BODY></HTML> ------=_NextPart_000_009C_01C73FF8.5D3A0030-- Tag: Format Date Syntax Problem Tag: 201643
  - 9
    - ADO recordset RecordCount property question Hi, Is there some reason why the ADODB.RecordSet.RecordCount property wouldn't function in VBScript? In both cases the RecordSet is being populated as I can retrieve the values, but in the case of the script it simply won't tell me the number of records. This code works fine in VB6, but returns -1 when run in VB script strSQL = "select * from ado_test" strConn = ' valid connect string oConnection.ConnectionString = strConn oConnection.CursorLocation = adUseClient oConnection.Open oRecset.Open strSQL, strConn, adOpenStatic, _ adLockBatchOptimistic, adCmdText MsgBox oRecset.RecordCount Tag: Format Date Syntax Problem Tag: 201638
  - 10
    - Classes in Session Variables - What's my problem? Ok, I must be doing something very simply wrong. global.asa: --------------------------------------------------------------------- <script language="vbscript" runat="server"> Sub Session_OnStart Dim oProduct, sTemp Set oProduct = New SampleProduct sTemp = "ABC123" oProduct.SKU = "ABC123" oProduct.Name = "My Killer Product" Set Session(sTemp) = oProduct End Sub Class SampleProduct Public SKU Public Name End Class </script> --------------------------------------------------------------------- My asp code looks like this: --------------------------------------------------------------------- Dim oMyProduct Set oMyProduct = Session("ABC123") Response.Write(oMyProduct.Name) --------------------------------------------------------------------- All I get is: --------------------------------------------------------------------- Microsoft VBScript runtime error '800a01b6' Object doesn't support this property or method: 'Name' /Testing.asp, line 14 --------------------------------------------------------------------- Am I retarded? What am I missing? Thanks for any help. Tag: Format Date Syntax Problem Tag: 201628
  - 11
    - script to clean orphaned Registry entries I need safely and precisely clean some orphaned Registry entries and keys, from HKLM. How to make this with VBScript? M. Tag: Format Date Syntax Problem Tag: 201626
  - 12
    - Detecting startup as the result of a drop action If you drag any Explorer selection over a .vbs file, the .vbs file will attempt to run. Is there any way to detect that it is starting to run as a result of a drop operation (as opposed to an accelerator key operation, or a command line invocation, or perhaps someone has even set up other file types to be operated on by that script (by means of ...\otherFileType\Shell\Open\Command in the registry))? An insufficient test is that such a drag operation ensures that the script gets at least one argument (whereas an accelerator key start ensures none). However, this won't discriminate between the other two methods above. A WinAPI solution is also acceptable. Thanks for any tips, Csaba Gabor from Vienna PS. JW, Thanks for your response a few months ago to my cookie question - I am still chewing on that one. Tag: Format Date Syntax Problem Tag: 201625
  - 13
    - populating multidimensional arrays Hi, I'm having some difficulty getting data into arrays greater than one dimension. I can do it if I specify every single element individually but there has to be a faster way. I thought something like this would work: Dim arrVal (3,3) arrVal(0) = Array(1, "ONE", "A") also tried this: arrVal(0,) = Array(1, "ONE", "A") and of course: arrVal(0) = (1, "ONE", "A") The only thing that seems to work is this: arrVal(0,0) = 1 arrVal (0,1) = "One" arrVal (0,2) = "A" Is there an easier way? Thank You Tag: Format Date Syntax Problem Tag: 201624
  - 14
    - Detect when a file has been "GET" by a remote FTP Server Hello everybody. I need to detect when files in a folder has been successfully copied to a remote machine via an FTP GET originated in that remote machine. I have no access or control over the server initiating the transfer so I have to monitor events in the server that stores the files. Maybe a WMI Management Class bound to FTP will do, but I have no found info yet. Thanks, edelvillar Tag: Format Date Syntax Problem Tag: 201623
  - 15
    - Creating an XML Document in VBScript I am creating a XML file in VBScript. However, my XML file is in the wrong format. Any help is appreciated. This is the format currently: <catalog><disc></disc><title>AVI 2</title></catalog> Here is the desired format: <catalog><disc><title>AVI 2</title></disc></catalog> Here is my code: Set objXMLDoc = CreateObject("Microsoft.XMLDOM") objXMLDoc.async = False objXMLDoc.load("C:\videocatalog\vid.xml") Dim objCurrNode, objNewNode, objNewText makeDisc() makeFiles() objXMLDoc.save("C:\videocatalog\vid.xml") '******************************* '* makeDisc * '******************************* Sub makeDisc() Set objNewNode = objXMLDoc.createElement("disc") Set objNewText = objXMLDoc.createTextNode("") objNewNode.appendChild(objNewText) Set objCurrNode = objXMLDoc.documentElement objCurrNode.appendChild(objNewNode) Set objCurrNode = objCurrNode.lastChild End Sub 'makeDisc subroutine '****************************** '* makeFiles * '****************************** Sub makeFiles() Set Root = objXMLDoc.documentElement Set NodeList = Root.getElementsByTagName("disc") For Each Elem In NodeList Set objNewNode = objXMLDoc.createElement("title") Set objNewText = objXMLDoc.createTextNode("AVI 2") objNewNode.appendChild(objNewText) Set objCurrNode = objXMLDoc.documentElement objCurrNode.appendChild(objNewNode) Set objCurrNode = objCurrNode.lastChild objNewNode.appendChild(objNewText) Next End Sub 'makeDisc subroutine Tag: Format Date Syntax Problem Tag: 201622
  - 16
    - Automatically Logging Into Websites I am really new in scripting and I was curious if it is possible to run Internet Explorer, go to a specific URL, automatically send username and password in the appropriate fields to log in. Tag: Format Date Syntax Problem Tag: 201620
  - 17
    - Problem with IE7, this script worked on IE6 Here are the first few (or more) lines of code to a script that monitors servers in real time, using IE to show a graphical/not page and indicating status. This worked on IE6 (I did have to tweak the security settings for intranet as I recall). Now it is broke, I don't really use IE7 (Firfox), but I do want my scripts to work in a browser that I expect to be standard. Any help would be greatly appreciated. Check it out; <--------Script Starts----------< Set WSHShell = WScript.CreateObject("WScript.Shell") Set IE = CreateObject("InternetExplorer.Application") Set fso = CreateObject("Scripting.FileSystemObject") 'Create a path and filename to a file in My Documents strMyDocPath = WshShell.SpecialFolders("MyDocuments") strTempFile = strMyDocPath & "\DIVExample.html" 'Create a file fso.CreateTextFile (strTempFile) Set f1 = fso.GetFile(strTempFile) Set ts = f1.OpenAsTextStream(2, True) 'Write a blank HTML page to the file with an empty DIV element, and then close the file ts.WriteLine("<HTML><HEAD><TITLE>Server Status</TITLE></HEAD>") ts.WriteLine("<BODY SCROLL='NO'><CENTER><FONT FACE='arial black'> <HR COLOR='BLACK'>") ts.WriteLine("<DIV id='MakeMeAnObject'></DIV>") ts.WriteLine("<HR COLOR='BLACK'></FONT></CENTER></BODY></HTML>") ts.Close 'Run IE and load the file we just created SetupIE(strTempFile) 'Set the DIV element as an object Set objDIV = IE.Document.All("MakeMeAnObject") objDiv.InnerHTML = "<font color=blue size=+11>Populating list ...</font>" <--------Script Ends----------< This part works. When IE7 comes up, it states populating list as it should, as well as that stupid drop down to enable scripting (can't seem to turn that off for intranet), but when I allow the script, it ends up blank with two HR (lines). Even though I am updating the oobjDIV object with HTML. Any ideas? Tag: Format Date Syntax Problem Tag: 201617
  - 18
    - Can't seem to find a solution for this one... We need to be able to do the following: After sysprep runs on a server, a script needs to run that will - execute a command at a command prompt (this will add VLANs to our server's NIC, which we are already able to do, but only for one set of VLANs. we have mulitple pools of servers that each use different VLANs), then - retrieve the numbers from the servers name, no matter the name length (we have different pools of servers that have different lengths for their names, but all have 1-3 digits at the end of their name) - apply the numbers to a script (that will assign IPs to the newly create VLANs) using the number as the last octet of, then finally - run an already bat file that will copy all necessary data... any help would be greatly appreciated...i keep trying different things, but as i am in no way a vbs master, i keep hitting dead ends.. thanks!! Tag: Format Date Syntax Problem Tag: 201611
  - 19
    - Word Wrap in html Creating a log file that I'm outputing to .html and some of the text has spaces that are wrapping to a new line within a table cell. Is there a way I can prevent the wrapping from occuring? -- Paul Tag: Format Date Syntax Problem Tag: 201610
  - 20
    - Can anyone script this?? Hi all, In order to implement a workaround to VPN users who have offline files set up but also need to access all folders when connected remotely, we're having to ask them to do the following (as per KB290523): 1. Double-click My Computer on the desktop. 2. On the Tools menu, click Folder Options. 3. On the Offline Files tab, click View Files. 4. On the Tools menu, click Synchronize. 5. Click OK when you are prompted to synchronize. Are there any vbs guru's out there who could post a script to do the above? I wouldn't have a clue where to start as my vbs knowledge is very basic. Thank you, Curtis. -- Please reply to news group only. Thank you. Tag: Format Date Syntax Problem Tag: 201608
  - 21
    - Formula I need to have a formula that can add a row of cells with a variable number of colmns. Columns will be added and deleted everyday, so the formula needs to have a variable range. I hope this is clear. Thanks, Bernie Tag: Format Date Syntax Problem Tag: 201605
  - 22
    - script for count some char in a file hi, i've created a script for count some type of characters into text file: ----------------------- Const ForReading =3D 1 filename =3D "c:\test.txt" Set objFSo =3D CreateObject("Scripting.FileSystemObject") Set objFile =3D objFSO.OpenTextFile(filename, ForReading) strFindText =3D "=EC" Do While objFile.AtEndOfStream =3D False strLine =3D objFile.ReadLine If inStr(strLine, strFindText) Then i =3D i + 1 End If Loop Wscript.Echo vbCrLf & "Number of records =EC found: " & i objFile.Close ------------------------- But this script search all the first char on each line, but i want to count all chars in all line not only the first. Someone can help me? thanks very much andrew Tag: Format Date Syntax Problem Tag: 201588
  - 23
    - monitoring systems in vbscript I once saw a script that monitoring disk event logs etc. Anyone know of one? Tag: Format Date Syntax Problem Tag: 201587
  - 24
    - Save values in a text boxes from a form I have a asp file in which I create about 10 text and10 input boxes. Basicially I created dynamically, so number of boxes are varies. I also have a button "Save". I have attached a javascirpt function SubmitForm(). What I try to do is the text indicates the employee number, the input box indicates the age. So how do save the age of each employee into database. The missing link how to loop through the existing input boxes and the text labels? Tag: Format Date Syntax Problem Tag: 201586
  - 25
    - 3 labels - 3 inputs Hi, I'm working on a vbs script. It's not a script that works in a web page. I'd like to prompt the user with three lables and three inputs for the user to type text. Might someone point me to a good example? A web page solution would be OK. So long as I can fetch the data and close the window. Thanks. Tag: Format Date Syntax Problem Tag: 201583

I need to display the last time a school hosted the SAT exam as mm/dd/yy.

I have been fighting for two days to try to get the correct syntax

My code is:

<TD><%Response.Write Format(rsSchools("LastTestDate"), "mm/dd/yy")%></TD>

I get the message:

Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'Format'
/USExams/SatPageAct.ASP, line 169

What am I doing wrong?

Thanks in advance

Granny

Top

Re: Format Date Syntax Problem by Michael

Michael
Sat Jan 27 17:41:23 CST 2007

> <TD><%Response.Write Format(rsSchools("LastTestDate"),
> "mm/dd/yy")%></TD>
>
> I get the message:
>
> Microsoft VBScript runtime (0x800A000D)
> Type mismatch: 'Format'
> /USExams/SatPageAct.ASP, line 169
>
> What am I doing wrong?

Using a Format() function that does not exist in VBScript...

Download details: Windows Script Documentation
http://www.microsoft.com/downloads/details.aspx?FamilyID=01592c48-207d-4be1-8a76-1c4099d7bbb9&DisplayLang=en

For server side ASP you are better off writing your own explicit date
formatting function. The FormatDateTime function in VBScript is sensitive
to regional settings, something generally out of the control of an ASP
author.

Can I make VBScript format dates for me?
http://classicasp.aspfaq.com/date-time-routines-manipulation/can-i-make-vbscript-format-dates-for-me.html

--
Michael Harris
Microsoft.MVP.Scripting

Top