Microsoft VBScript compilation error '800a03f6'

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

I need help with this error:

Microsoft VBScript compilation error '800a03f6'

Expected 'End'

/Includes/MediatorFooter.asp, line 66

SCRIPT:
</body>
<%function getLastUpdatedDate

set fso = CreateObject("Scripting.FileSystemObject")
set fil =
fso.GetFile(Server.MapPath(Request.ServerVariables("SCRIPT_NAME")))
getLastUpdatedDate = DateValue(fil.DateLastModified)

End Function%></html>

Thanks,

Charles

Top

Re: Microsoft VBScript compilation error '800a03f6' by Steven

Steven
Mon May 30 16:19:17 CDT 2005

<%
Function getLastUpdatedDate()
Dim sPath, objFSO, objFl
Set objFSO =3D CreateObject("Scripting.FileSystemObject")
sPath =3D Request.ServerVariables("SCRIPT_NAME")
set objFl =3D objFSO.GetFile(Server.MapPath(sPath))
getLastUpdatedDate =3D DateValue(objFl.DateLastModified)
Set objFSO =3D Nothing
End Function
%>

--=20
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"chug" <chg@rbuy.com> wrote in message =
news:1117486889.873913.307140@g47g2000cwa.googlegroups.com...
> I need help with this error:
>=20
> Microsoft VBScript compilation error '800a03f6'
>=20
> Expected 'End'
>=20
> /Includes/MediatorFooter.asp, line 66
>=20
> SCRIPT:
> </body>
> <%function getLastUpdatedDate
>=20
> set fso =3D CreateObject("Scripting.FileSystemObject")
> set fil =3D
> fso.GetFile(Server.MapPath(Request.ServerVariables("SCRIPT_NAME")))
> getLastUpdatedDate =3D DateValue(fil.DateLastModified)
>=20
> End Function%></html>
>=20
> Thanks,
>=20
> Charles
>=20

Top