What do I need to install to use vbscripting

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
    - UserAccounts.CommonDialog on Windows 2000 CreateObject("UserAccounts.CommonDialog") is working fine on XP, but on Windows Server, it doesn't. Have another way of calling browse a file on that platform? Thanks, -Andrew Tag: What do I need to install to use vbscripting Tag: 213082
  - 2
    - Error while trying to access excel file using HTML Code Hi All, I have developed a web site and I am trying to show some contents on one of the Web Pages from a Excel file. I have created a small script but I am getting the error as mentioned below. Can somebody please help me on this ? VB Script : <HTML> <HEAD></HEAD> <BODY> <SCRIPT LANGUAGE="VBScript">  </SCRIPT> </BODY> </HTML> When I am opening this page I am getting following error Line: 28 Char: 5 Error: Safety settings on this computer prohibit accessing a data source on another domain. Code: 0 URL: http://littlemastersachin.com/temp.aspx Tag: What do I need to install to use vbscripting Tag: 213081
  - 3
    - Help with VBscript to delete files Hello Everyone, I use the following vbscript code to delete files in a particular directory on my FTP server. I delete all files in the starting folder and it's subfolders after 14 days. Today however I had a request to keep files in one folder and it's subfolders (say folder xyz and it's sub-folders) for 5 months. I thought I could just put an If statement in the selectfiles Subroutine like so ( I also left it in the code where I thought it should go) if folder = "xyz" then vKillDate = date() - 150 but that did not work. Can anyone help? Thanks I appreciate it. Here is the Script I use. It was something I had downloaded several years ago '************************************************************** 'VBSCRIPT to delete files ' folder to start search in... path = "c:\proddev" ' delete files older than 14 days from proddev folder and subfolders... killdate = date() - 14 arFiles = Array() set fso = createobject("scripting.filesystemobject") ' Don't do the delete while you still are looping through a ' file collection returned from the File System Object (FSO). ' The collection may get mixed up. ' Create an array of the file objects to avoid this. ' SelectFiles path, killdate, arFiles, true nDeleted = 0 for n = 0 to ubound(arFiles) '================================================= ' Files deleted via FSO methods do *NOT* go to the recycle bin!!! '================================================= on error resume next 'in case of 'in use' files... arFiles(n).delete true if err.number <> 0 then wscript.echo "Unable to delete: " & arFiles(n).path else nDeleted = nDeleted + 1 end if on error goto 0 next 'msgbox nDeleted & " of " & ubound(arFiles)+1 _ ' & " eligible files were deleted" sub SelectFiles(sPath,vKillDate,arFilesToKill,bIncludeSubFolders) on error resume next 'select files to delete and add to array... ' set folder = fso.getfolder(sPath) set files = folder.files '******************************************* '****** this is where I thought I could put an if condition if folder = "xyz" then vKillDate = date() - 150 end if '******************************************** for each file in files ' uses error trapping around access to the ' Date property just to be safe ' dtlastmodified = null on error resume Next dtlastmodified = file.datelastmodified on error goto 0 if not isnull(dtlastmodified) Then if dtlastmodified < vKillDate then count = ubound(arFilesToKill) + 1 redim preserve arFilesToKill(count) set arFilesToKill(count) = file end if end if next if bIncludeSubFolders then for each fldr in folder.subfolders SelectFiles fldr.path,vKillDate,arFilesToKill,true next end if end sub Tag: What do I need to install to use vbscripting Tag: 213079
  - 4
    - Can i use vbscript to create a windows form? Can i use vbscript to create a windows form which includes some checkboxes,textboxes and buttones? Tag: What do I need to install to use vbscripting Tag: 213072
  - 5
    - WMI StopService Anyone know about the error codes for Win32_Service StopService? I'm getting error 4 when trying to stop some services. The description of that error is "Invalid Service Control", which tells me nothing. I'm trying to figure out what actually causes error 4. (I asked in the WMI group but it seems to be rather sleepy over there, with little activity.) Running as only user, with full control, on XP. I think, if I remember correctly, it was trying to stop WebClient that raised the error. Tag: What do I need to install to use vbscripting Tag: 213059
  - 6
    - HKEY_CLASSES_ROOT\CLSID How to get all list in HKEY_CLASSES_ROOT\CLSID? Thanks, -Andrew Tag: What do I need to install to use vbscripting Tag: 213055
  - 7
    - Reference for InternetExplorer.Application Where's the reference about InternetExplorer.Application? Set objIE=CreateObject("InternetExplorer.Application") Have some properties of objIE or objIE.Document to let the IE window to be on the top (Active) and cann't be closed? Thanks, -Andrew Tag: What do I need to install to use vbscripting Tag: 213053
  - 8
    - Reading input file I have what seems to be a very simple issue in a script that I am writing. The first line in an input file that I'm reading is an arbitrary number, and every line after that is the meat of the input file. An example of the log file would look like this: 12345 cf,http://dev.sheeltest.org/sys2/objFolder How would I read the first line and put it into a variable, and then take the next line and any subsequent lines in the input line and splits it into an array? Any help is greatly appreciated. Thanks, Sheel Tag: What do I need to install to use vbscripting Tag: 213043
  - 9
    - Listing a domains exchange servers? Hi! :) I'm using CDO.Message to send e-mails in my scripts. I'd like my function doing this to be able to work without requiring an explicit smtp server as input. I want my scripts to function undependant of the domain they are run in and all others do... Is there a way to get a list of the smtp servers in a domain? If so, could I just use any one of these for the smtpserver setting? I don't know much about mail servers... Thanks a million! :) /Sofia Tag: What do I need to install to use vbscripting Tag: 213042
  - 10
    - echo, newline escaping, and more My question is how to pipe newlines directly from echo into more. Detailed explanation: It is possible to escape newlines in cmd.exe by ending a line with the caret (^) and then pressing the enter key twice. Thus, the following 3 lines will display foo, and on the next line it will display bar: echo foo^ bar Very nifty. What I would now like, however, is for the result of an echo, piped into more, to display foo on one line, followed by bar on the next. The following 3 lines do not work: echo foo^ bar | more more will only shows the first line, foo. What is going on is that when echo is piped into more, for reasons I have not fathomed, the command line parser runs over the command line twice (for example, there are two levels of environment variable expansion as will be seen shortly). Therefore, it would seem that I have to escape the above 3 lines once to the following 5 lines (using double caret below (^^) to escape a single caret (^) above and ^ followed by two newlines below to escape a single newline above): echo foo^^^ ^ bar | more Unfortunately, this does not work, and as before, I only get the first line showing: foo Furthermore, if the last line is only bar instead of bar | more, then the 3 line output from echo's single pass is as expected: foo^ bar Now you will be thinking, Csaba, really, you were overly optimistic thinking that the command parser would be willing to accommodate that screwy newline escaping. You should be lucky that it worked at all with echo, never mind the pipe. Well, perhaps so, but then I would expect the following 5 lines to similarly fail, but it does quite nicely, thank you very much. set nl=^ set nlm=^^^^%^nl%%^nl% echo foo%nlm%bar | more The 'echo ... | more' demonstrates the double substitution mentioned earlier. The last two lines would also work as: set nlm=^^^%nl%%nl%^%nl%%nl% echo foo%^nlm%bar | more which 2nd variant causes a single expansion on the 2nd pass. But I wonder if it is possible to avoid the expansion on the second pass, which happens in both examples. In other words, could I have an environment variable just expand on the first pass? And this should be the same as my original question: How can I pipe newlines directly from echo into more? Csaba Gabor from Vienna PS. The above may be tested by copying the specified number of lines and then at the cmd.exe prompt doing (Alt+space)ep (enter may need to be pressed depending on whether the copied section has a final newline in it) PPS. Environment variable expansion happens first, and then escaped characters are unescaped. Thus, an isolated ^ in an environment variable will seemingly disappear. PPPS. VBScript group copied as a possilble interest topic when using Run/Exec Tag: What do I need to install to use vbscripting Tag: 213041
  - 11
    - Newbie - Error in script Hi The following script works OK when run interactively from the command line, but when run as a scheduled task - via SQL Enterprise Manager in preperation for another SQL task - returns the error:- The process could not be created for step 2 of job 0x0882C8212587254BB055CCD056C84FD0 (reason: %1 is not a valid Win32 application). The step failed. The VB script is as follows, and it fails before the copy operation:- dim yr dim mth dim day dim objFile dim objFso dim objFolder dim objFileLoop yr = cstr(4) mth =cstr(2) day = cstr(2) file = cstr(51) yr = datepart("yyyy",Now) mth = datepart("m",Now) day = datepart("d",now) if mth = "1" then mth = "01" end if if mth = "2" then mth = "02" end if if mth = "3" then mth = "03" end if if mth = "4" then mth = "04" end if if mth = "5" then mth = "05" end if if mth = "6" then mth = "06" end if if mth = "7" then mth = "07" end if if mth = "8" then mth = "08" end if if mth = "9" then mth = "09" end if if day = "1" then day = "01" end if if day = "2" then day = "02" end if if day = "3" then day = "03" end if if day = "4" then day = "04" end if if day = "5" then day = "05" end if if day = "6" then day = "06" end if if day = "7" then day = "07" end if if day = "8" then day = "08" end if if day = "9" then day = "09" end if set objFso = createobject("scripting.FileSystemObject") objFile = "AGRESSODB01_agresso_Full_" & yr & mth & day & "2200 (1 of 1).safe" if objFso.FileExists(objFile) then objFso.CopyFile objFile, "\\agressodr\e$\sqlsafe \AGRESSODB01_Live_Full.safe" end if set objFso = Nothing set objFso = createobject("scripting.FileSystemObject") set objFolder = objFso.GetFolder("J:\SqlSafe") for each objFileLoop in objFolder.Files if datediff("d",objFileLoop.DateCreated,Now) > 7 then objFile = objFileLoop.Name if objFileLoop.Name <> "CopyFile.vbs" then objFso.DeleteFile(objFile) end if end if next Any assistance appreciated Tag: What do I need to install to use vbscripting Tag: 213032
  - 12
    - vbs script to detect folder(to detect installed applications like Hi, i am an administrator with limited resources and would like to know how i can detect installed applications(like p2p applications) in client computers in network . We have a windows 2003 domain and all clients are joined to it. I wanted to use the gpinventory tool from microsoft and integrate the script into it but that is not important as long as someone guides me of an alternate technique to detect the folders. Thanks in advance and any help is appreciated. Regards, Scorp Tag: What do I need to install to use vbscripting Tag: 213031
  - 13
    - copyhere and preventing progress bars and dialogs hi, I am trying to prevent the progress bar and any windows from popping up when performing: set shl = createobject("Shell.Applicatioin") shl.namespace(dest).copyhere shl.namespace(src).items do until shl.namespace(dest).items.count = shl.namespace(src).items.count wscript.sleep 100 loop according to msdn I should be able to use options: http://msdn2.microsoft.com/en-us/library/bb787866.aspx I have tried changing above line to the below but it doesn't work. shl.namespace(dest).copyhere shl.namespace(src).items, &H4 any help appreciated. thanks. Tag: What do I need to install to use vbscripting Tag: 213028
  - 14
    - compress (zipped) folders issue hi, I am performing the following which works perfectly if there is not an empty subdirectory within the folder I am trying to zip. src = "c:\temp\" dest = "c:\test\test1.zip" 'write zip file header set fso = createobject("Scripting.FileSystemObject") set file = fso.opentextfile(dest,forwriting,true) file.write "PK" & chr(5) & chr(6) & string(18,chr(0)) file.close set shl = createobject("Shell.Applicatioin") shl.namespace(dest).copyhere shl.namespace(src).items do until shl.namespace(dest).items.count = shl.namespace(src).items.count wscript.sleep 100 loop However, if there is an empty subdirectory I receive the following error "The specified directory c:\temp\vbe is empty, so compressed (zipped) folders cannot add it to the archive. How do I prevent this from happening. If I do the same thing manually by right clicking on temp and choosing send to\compressed folder I do not receive the error. thanks. Tag: What do I need to install to use vbscripting Tag: 213027
  - 15
    - Date range problem I'm have a site that will display a banner image based on the time of year. My date ranges go from: 4/1 - 6/30 7/1 - 9/30 10/1-11/30 12/1 - 3/31 My script is below. The first three ranges work fine, but the last one spans two different years. If it's 2007, the range will be 12/1/2007 - 3/31/2007. Obviously, that won't work. And, when the year changes to 2008, none of the date ranges will be true because the 12/1-3/31 range will now be 12/1/2008 - 3/31/2008. I thought about incrementing the year for 3/31 based on the current year, but if the current year is correct, I can't increment it. Suggestions? Just not sure how to go about this. Thanks! Doug if Date >= CDate("4/1/" & Year(Date)) AND Date <= CDate("6/30/" & Year(Date)) then Response.Write "<img src=""/images/display/Banner.jpg"" >" elseif Date >= CDate("7/1/" & Year(Date)) AND Date <= CDate("9/30/" & Year(Date)) then Response.Write "<img src=""/images/display/Banner.jpg"" >" elseif Date >= CDate("10/1/" & Year(Date)) AND Date <= CDate("11/30/" & Year(Date)) then Response.Write "<img src=""/images/display/Banner.jpg"" >" elseif Date >= CDate("12/1/" & Year(Date)) AND Date <= CDate("3/31/" & Year(Date)) then Response.Write "<img src=""/images/display/Banner.jpg"" >" end if Tag: What do I need to install to use vbscripting Tag: 213022
  - 16
    - functions named the same if I have a script with two functions named the same.. such as msgbox testme(8,5) function testme (int1,int2) testme = int1 + int2 end function function testme (int1,int2) testme = int1 - int2 end function The output is the result of the last function in line in the script ie 3. However if you add the line executeglobal "function testme(int1,int2) : testme = int1 * int2 : end function" above the first function, then the result is 40.. ie it runs the first function in the script? adding a second executeglobal line after the first.. executeglobal "function testme(int1,int2) : testme = int1 / int2 : end function" and the second executeglobal function is run ie the output is 1.6. isnt that a little bit strange? how does the interpretation of the script change using executeglobal I wonder ? I assume that the executeglobal command is actually run after the rest of the code so the function is in fact the last version of the function? If that is the case why does this code executeglobal "msgbox testme (24,1)" msgbox testme(8,5) function testme (int1,int2) testme = int1 - int2 end function give the output 23 then 3 rather than the other way around? Tag: What do I need to install to use vbscripting Tag: 213021
  - 17
    - vbscripting for exchange 2007 I'm just curious if we are still going to be able to run and create vbscripts for exchange 2007, and windows server 2007. I know there is a new tool out there called Powershell that I'm trying to learn, but have more vbscripts out there available to do things with. Just curious if anyone has knowledge or experience with it please let me know. Thanks J0seg Tag: What do I need to install to use vbscripting Tag: 213016
  - 18
    - Question about ":" in vbscript syntax Hi, all, below uses ":" to put two statement in on line. Any one know where I can find explanation of this usage or this way just to put statment in one line. Thanks. Greg Dim sIP_Address : sIP_Address = GetIP() Tag: What do I need to install to use vbscripting Tag: 213013
  - 19
    - get value from combo box to add data to JList Hi all, I am currently trying to develop a java program which has two files loaded into it. One is for room rumbers which are listed in a combo box like RM01, RM02, RM03 etc, and the other files has the computer names which are loaded into the JList like RM01_01, RM01_02, RM02_01, RM02_02 etc. What I would like to do is when I click RM01 on the combo box the JList automatically repopulates with all the computers that start with RM01 so it would only show the computer names which are RM01_01, RM01_02 etc. I have tried this and it is not working properly. What I have got I am not sure if it is working properly as I can not anything to display inside the vector for the JList. This is what I have so far. I know that this is probably completely wrong as I am a newbie to java: public void lstComputerNamesInitiate() { try { // Open the file that is the first // command line parameter FileInputStream fstream = new FileInputStream("" + DataFile.txtNamePath.getText()); // Get the object of DataInputStream DataInputStream in = new DataInputStream(fstream); BufferedReader br = new BufferedReader(new InputStreamReader(in)); String strLine = ""; //Read File Line By Line String computerNaming = strLine; String startsWith = (String) cboRoomNumber.getSelectedItem(); System.err.println("startswith: " + startsWith); while ((strLine = br.readLine()) != null) { boolean computer = computerNaming.startsWith(startsWith); System.err.println("boolean: " + computer); System.out.println("selected room number is: " + cboRoomNumber.getSelectedItem()); // Print the content on the console System.out.println(strLine); String computerName = strLine; // data.add(computerName); data.add(computerNaming); System.out.println("inside the vector is: " + data); lstComputerNames.setListData(); } //Close the input stream in.close(); } catch (Exception e) { //Catch exception if any System.err.println("Error: " + e.getMessage()); } } Any help in this matter would be highly appreciated. Thank you Tag: What do I need to install to use vbscripting Tag: 213010
  - 20
    - stationery and Vista I use a lot of stationery complete with music and my friends all look forward to receiving my mail. However with the advent of Vista, my stationery does not work properly with those of my email pals who have Vista. Is there a fix for it? I use Windows XP, so don't know much about Vista. Any advice will be appreciated. Majocle Tag: What do I need to install to use vbscripting Tag: 213009
  - 21
    - Convert VB app to vbscript Is there anything out there that will convert a VB program into vbscript. Thanks. Tag: What do I need to install to use vbscripting Tag: 213005
  - 22
    - Retrieve ProcessID for the running script I am able to retrieve the ProcessID for processes using the Win32_Process Class, however I am not able to retrieve the ProcessID for the script that the code is running in. I can't use the Name of the process since I have multiple wscript.exe running so the only way I can think of getting the ProcessID is by finding properties for the current script process only. I have no idea how to do this since the closest I can get is a complete list of running processes while I just need the info for the currently running script. Any help with this issue would be greatly appreciated. Tag: What do I need to install to use vbscripting Tag: 212991
  - 23
    - COM+ application server Hi, All, How to know whether a server is COM+ application server or not? Thanks, -Andrew Tag: What do I need to install to use vbscripting Tag: 212987
  - 24
    - Sorting in VBscript I have a vbscript that retrieves pdf files and outputs them in a table with a link to the file plus the date modified. I'm trying with no luck to sort the links starting with newest file. The file path is newbusiness/2007. There is a folder for each year. A the top of the table is a list of links to each year folder. Below is the code: <%@ Language = "vbScript"%> <%option Explicit%> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <% ' **************************************************************************************************** ' FSO - Datasource - path to the icon Folder ' **************************************************************************************************** Dim ObjFSO Set ObjFSO = CreateObject("Scripting.FileSystemObject") '** Create FSO Function getCurrentYear() getCurrentYear = DatePart("yyyy", Date) if not ObjFSO.FolderExists(Server.MapPath("newbusiness\" & getCurrentYear)) then getCurrentYear = getCurrentYear - 1 end if Exit Function End Function Dim FolderRequest : FolderRequest = Request.QueryString("archive") & "\" '** grabs the query string passed by the argument "?folder=" If FolderRequest = "\" or Len(Request.QueryString) = 0 then If ObjFSO.FolderExists(Server.MapPath("newbusiness\" & getCurrentYear)) then FolderRequest = getCurrentYear & "\" else getCurrentYear = getCurrentYear - 1 FolderRequest = getCurrentYear & "\" end if end if Dim FolderPath FolderPath="newbusiness\" & FolderRequest '** newbusiness folder path/ Dim RootFolder, NavPath, s, n Dim f1 Dim sf MapMyDrive() '============================================================== ' Sets up the folder path where the pdf files will be read from '============================================================== Private Sub MapMyDrive() On Error Resume Next Set RootFolder = ObjFSO.GetFolder(Server.MapPath(FolderPath)) If Err.Number <> 0 then FolderPath = "newbusiness\" & getCurrentYear & "\" '** newbusiness folder path/ Err.Clear() else FolderPath= "newbusiness\" & FolderRequest end if Set RootFolder = ObjFSO.GetFolder(Server.MapPath("newbusiness/")) '** Root folder = New Business folder Set NavPath = ObjFSO.GetFolder(Server.MapPath(FolderPath)) '** set what files are shownview depending on what's defined in NavPath Set sf = RootFolder.SubFolders '** set subfolders to read information from the /newbusiness folder (top level directory) Exit Sub End Sub Function ShowFolderList(folderspec) '** grabs all the files within a specific folder and outputs them, with links, as a single string Dim n n = 0 For Each f1 in sf n = n + 1 if n = 1 then '=== Do Nothing === else s = s & "<font color='#ffffff'>|</font> " end if s = s & "<nobr><a href='newbusiness.asp?archive=" & f1.name & "'>" & UCase(replace(f1.name ,"_"," ")) & "</a></nobr> " Next ShowFolderList = s End Function ' **************************************************************************************************** ' Outer table ' **************************************************************************************************** %> <!doctype html public "-//w3c//dtd html 4.0 transitional//en" > <html> <head> <TITLE>New Business Archive for <%response.Write(replace(replace(FolderRequest, "\", "") ,"_"," ")) %> </TITLE> <link rel="stylesheet" href="/CityOfRichmondVirginia.css"> <link rel="stylesheet" href="newbusinessarchive.css" title="New Business Archive Style Sheet"> </head> <body bgcolor="#E2DED4" text="#000000" link="#000000" vlink="#000000" alink="#000000" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" name="top"> <form name="frmMain" method="post" action="index.aspx" id="frmMain"> <input type="hidden" name="__VIEWSTATE" value="dDwxMzE4OTY3MjM2Ozs +cEc8jXCd4QzwkdirzxyX1EgPR0c=" ID="Hidden1"/> <div align="center"> <table bgcolor="#333333" width="760" cellspacing="0" cellpadding="1" border="0" style="background:#333333;width:760px;" ID="Table1">  <tr> <td> <table background="" bgcolor="#E2DED4" width="100%" cellspacing="0" cellpadding="0" border="0" ID="Table3"> <tr> <td align="center"><script src="/macromediaflashdetect.js" type="text/javascript"></script> <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/ swflash.cab#version=6,0,0,0" width="758" height="98" id="Richmond.Main.Menu" align="middle" > <param name="movie" value="/PageTemplates/flash/ Richmond.Main.Menu.Smaller.swf? __ServerName=wwwdev&__PageTemplateName=Default&__PageTemplateType=SmallDeptHeader" / > <param name="menu" value="false" /> <param name="allowScriptAccess" value="sameDomain" /> <param name="quality" value="high" /> <param name="scale" value="noscale" /> <param name="wmode" value="transparent" /> <param name="loop" value="false" /> <param name="bgcolor" value="#E2DED4" /> <embed src="/PageTemplates/flash/ Richmond.Main.Menu.Smaller.swf? __ServerName=wwwdev&__PageTemplateName=Default&__PageTemplateType=SmallDeptHeader" loop="false" menu="false" quality="high" scale="noscale" wmode="transparent" bgcolor="#E2DED4" width="758" height="98" name="Richmond.Main.Menu" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" /> </object> </td> </tr> <tr height="15" bgcolor="FEF8E8"> <td></td> </tr> <tr> <td align="center" bgcolor="FEF8E8">  <table bgcolor="#333333" width="760" border="0" cellpadding="1" cellspacing="0" align="center" ID="Table4"> <tr> <td valign="top" bgcolor="#99cccc"> <table width="100%" border="0" cellspacing="0" cellpadding="1" ID="Table5"> <tr bgcolor=""> <td colspan="2" align="center"> <span class="pagetitleteal">New Business Archive</ span><br><br> </td> </tr> <tr bgcolor="#999999"> <td colspan="2" align="center"> <%Response.Write "<B>"&ShowFolderList(sf)&"</B>" %> </td> </tr> <tr> <td colspan="2"> <table width="100%" cellpadding="3" cellspacing="0" border="1"> <% ' *************************************************************************************************** ' Display pdf files and tables in specific folder ' *************************************************************************************************** Dim files, fileCountIndex Set files = NavPath.Files fileCountIndex = files.count ' **************************************************************************************************** ' Display Number of picture ' **************************************************************************************************** 'Determine how many files are in the directory, and create the table entries accordingly. if fileCountIndex = 0 then Response.Write "<tr><td colspan='2' valign='bottom'>There are <b>" & fileCountIndex & "</b> records available.<BR>Please choose a directory above to browse.<br>" _ & "The current list of new business licenses is: " & setCurrentLicense() & "</td></tr>" else if fileCountIndex = 1 then Response.Write "<tr><td colspan='2' valign='bottom'>There is <b>" & fileCountIndex & "</b> record available.<br>"_ & "The current list of new business licenses is: " & setCurrentLicense() & "</td></tr><tr><td align='center'><b>Week Ending</b></td><td align='center'><b>Posted Date</b></td></tr>" else if fileCountIndex >= 2 then Response.Write "<tr><td colspan='2' valign='bottom'>There are <b>" & fileCountIndex & "</b> records available.<br>" _ & "The current list of new business licenses is: " & setCurrentLicense() & "</td></tr><tr><td align='center'><b>Week Ending</b></td><td align='center'><b>Posted Date</b></td></tr>" end if end if end if 'Code goes here to set the menu navigation ' ============================================================================= ' === === ' === Daniel Dority === ' ============================================================================= getHerDone() ' ============================================================================= ' === Outputs the directory of PDFs onto the page === ' ============================================================================= Private Sub getHerDone() Dim i : i = 0 Dim Name, file, myExt, Link For Each file in Files Name = File.Name Link = Name myExt = LCase(ObjFSO.GetExtensionName(Name)) Select Case(myExt) Case "pdf": Response.Write("<tr>") Response.Write(" <td valign='middle' width='420'>") Response.Write(addLinkage(FolderPath, Link, formatString(Name))) Response.Write(" </td>") Response.Write(" <td width='220'>" & (File.DateLastModified) & "</td>") Response.Write("</tr>") Case Else: '=== Do Nothing === End Select Next Exit Sub End Sub ' ============================================================================= ' === Gets the latest file in the latest folder === ' ============================================================================= Private Function setCurrentLicense() Dim currentFolderPath, file, currentFiles, currentFileCountIndex, currentNavPath currentFolderPath = "newbusiness\" & getCurrentYear & "\" Set currentNavPath = ObjFSO.GetFolder(Server.MapPath(currentFolderPath)) '** set what files are shownview depending on what's defined in NavPath Set currentFiles = currentNavPath.Files currentFileCountIndex = currentFiles.count Dim i : i = 1 For Each file in currentfiles Select Case (i = currentFileCountIndex) Case True: setCurrentLicense = addLinkage(currentFolderPath, file.Name, formatString(file.Name)) Case Else: '=== Do Nothing === End Select i = i + 1 Next Set currentNavpath = Nothing Set currentFiles = Nothing Exit Function End Function ' ============================================================================= ' === Formats the filename from "newbusinessMMDDYYYY" to "MM/DD/ YYYY." === ' === ARGUMENTS: === ' === strLicense - file.Name === ' ============================================================================= Private Function formatString(strLicense) formatString = Left(Right(replace(strLicense ,"_"," "), 12), 2) _ & "/" & Left(Right(replace(strLicense ,"_"," "), 10), 2) _ & "/" & Left(Right(replace(strLicense ,"_"," "), 8), 4) Exit Function End Function ' ============================================================================= ' === Sets the Link Name and File Name into a Link === ' === ARGUMENTS: === ' === strFolderPath - FolderPath === ' === strLink - Link === ' === strName - Name === ' === One might use this like so: === ' === addLinkage(FolderPath, Link, Name) === ' ============================================================================= Private Function addLinkage(strFolderPath, strLink, strName) addLinkage = "<a href='" & replace(strFolderPath, "\", "/") & strLink & "' target='_blank'><span class='fontB'>" & strName & "</ span></a>" Exit Function End Function %> </td> </tr> </table> </td> </tr> <tr bgcolor="#999999"> <td> <table width="100%" ID="Table2"> <tr> <td valign="middle" align="right"></td> </tr> </table> </td> </tr> </table> <% Set Navpath = Nothing Set RootFolder = Nothing Set ObjFSO = Nothing Set sf = Nothing Set files = Nothing %>  </td> </tr> </table> </td> </tr> </table>  </td> </tr> <tr height="15" bgcolor="FEF8E8"> <td></td> </tr> <tr> <td align="center">  <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#000000" id="corFooter"> <tr valign="top"> <td> <table cellspacing="0" cellpadding="0" border="0" width="100%" id="LNDL"> <tr> <td><font class="font11pxVerdanaFFFFFF" color="#FFFFFF" title="900 East Broad Street, Richmond, Virginia 23219">  900 East Broad Street, Richmond, Virginia 23219 (804)646-7000 <a href="/ contact.aspx" class="footer" title="City of Richmond Contact Information Page.">Contact Us.</a> </font></td> <td align="right" width="110" rowspan="2"><a href="/"><img src="/ images/footer.image.onecityourcity.jpg" width="110" border="0" alt="The City of Richmond Virginia." title="The City of Richmond Virginia."></a></td> </tr> <tr> <td><font class="font11pxVerdanaFFFFFF" color="#FFFFFF" title="Copyright 2000 to 2005, City of Richmond, Virginia.">  ©2000-2006 City of Richmond, Virginia. All rights reserved. <a href="/disclaimer.aspx" class="footer" title="The Privacy Statement, Disclaimer and Terms of Use for this site.">Privacy, Disclaimer & Terms.</a> </font></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr>  </table> </div> </form> </body> </html> Tag: What do I need to install to use vbscripting Tag: 212985
  - 25
    - How to create an object for remote server? In my code: Set objCatlog = CreateObject("COMAdmin.COMAdminCatalog") objCatlog.Connect(strServerName) Set objApplications = objCatlog.GetCollection("Applications") objApplication.Populate For each objApplication in objApplications Set objComponents = objApplications.GetCollection("Components", objApplication.Key) objComponents.Populate For each objComponentItem in objComponents Set objComponent = CreateObject(objComponentItem.Value("ProgID")) 'it doesn't work Next Next My question: how to create an object for remote server? objComponentItem.Value("ProgID") is from server, but cannot create a object for the server, why? Thanks, -Andrew Tag: What do I need to install to use vbscripting Tag: 212984
- Next
  - 1
    - Error Invalid Syntax I am writing a script (and by the way not very good with scripts) to create new users in bulk. The spreadsheet refereenced in the code below is valid and in the right place. the error I am getting is: Line 6 Car 5 Invalid syntax Code 800401E4 Source (null) I have no Idea where the error is, this is the code: Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open _ ("C:\New_users.xls") intRow = 2 Do Until objExcel.Cells(intRow,1).Value = "" Set objOU = GetObject("ou=Phil, dc=fnfglobal, dc=local") Set objUser = objOU.Create _ ("User", "cn=" & objExcel.Cells(intRow, 15).Value) objUser.sAMAccountName = objExcel.Cells(intRow, 16).Value objUser.GivenName = objExcel.Cells(intRow, 10).Value objUser.SN = objExcel.Cells(intRow, 12).Value objUser.middleName = objExcel.Cells(intRow, 11).Value objUser.company = objExcel.Cells(intRow, 1).Value objUser.street = objExcel.Cells(intRow, 2).Value 'Enter City objUser.l = objExcel.Cells(intRow, 4).Value 'Enter State objUser.st = objExcel.Cells(intRow, 5).Value objUser.postalCode = objExcel.Cells(intRow, 6).Value objUser.department = objExcel.Cells(intRow, 14).Value objUser.title = objExcel.Cells(intRow, 13).Value objUser.AccountDisabled = FALSE objUser.SetInfo intRow = intRow + 1 Loop objExcel.Quit Any help would really be appreciated.... Phil Tag: What do I need to install to use vbscripting Tag: 212980
  - 2
    - Script to move folders from a list text file I need this script to move folders from a list, text file. I am new to VBS and can't get it to work. Any help would be greatly appreciated. set fso = CreateObject("Scripting.FileSystemObject") set oFile = fso.OpenTextFile("C:\listcommands.txt", 1, False) Do while (oFile.AtEndOfStream <> True ) strFolder = oFile.ReadLine() Set oFolder = fso.GetFolder(strFolder) oFolder.Copy("C:\TrashBin\" & http://oFolder.Name/) oFolder.Delete Loop oFile.Close Tag: What do I need to install to use vbscripting Tag: 212975
  - 3
    - Computer Updates and SP.vbs(8, 2) (null): 0x80041021 Hello, I am new to scripting. I've come up with a script that works only if i put the variable strComputer = "." However when I create an input text file and an output textfile it works partially. Here is the script: Set fso = CreateObject("Scripting.FileSystemObject") Set objInputFile = fso.OpenTextFile("d:\Computers.txt", 1, True) Set objOutputFile = fso.OpenTextFile("d:\Results.txt", 2, True) Do While objInputFile.AtEndOfLine <> True strComputer = objInputFile.ReadLine Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colQuickFixes = objWMIService.ExecQuery _ ("Select * from Win32_QuickFixEngineering") For Each objQuickFix in colQuickFixes objOutputFile.Writeline "Computer: " & objQuickFix.CSName objOutputFile.Writeline "Description: " & objQuickFix.Description objOutputFile.Writeline "Hot Fix ID: " & objQuickFix.HotFixID objOutputFile.Writeline "Installation Date: " & objQuickFix.InstallDate objOutputFile.Writeline "Installed By: " & objQuickFix.InstalledBy objOutputFile.Writeline Next Loop I am running the script locally on my machine and in the Computers.txt file is under the format "computer name" ex comp001, on line 2 it is comp002 etc.... Once i run the script it finds the 1st comp line and writes the results to the results.txt file and then it stops with the error: D:\_SCRIPTS\_VBSEDIT SCRIPTS\Computer Updates and SP.vbs(8, 2) (null): 0x80041021 How can i correct the above script? Tacobell2000 Tag: What do I need to install to use vbscripting Tag: 212974
  - 4
    - Parsing a textfile and writing file properties Windows Live Mail stores each e-mail message and newsgroup posting as a textfile with a .eml or .nws extension. The filename itself is a fairly random string of hex characters, so a typical file will be called 440D491C-00000077.eml. This is not helpful if you're looking for a specific message in the file system. I'm using XPSP2. I've played around with a VBA script to do the following with a specified folder: (a) Trawl through the folder and any subfolders looking for .eml or .nws files (b) For each file found, search for data on lines starting with From:, To:, Date: and Subject: (c) Clean up the data found - eg. From: will usually be followed by something like "Joe Bloggs" <joe.bloggs@hotmail.com>. This would result in two variables - name and address. (d) Write the data found to the file properties. I've got it working up to a point, but the problems I'm facing are: (1) encoded data. Some messages have more than one of the fields mentioned encoded, as Quoted-Printable or Base64, and then there is sometimes UTF-8 on top. I've managed to cope with most of this, but not reliably (2) I seem to be limited to Summary properties, since Custom properties won't show up as columns in Explorer. So, From: becomes Author,and Subject: becomes Subject. To: I can do without. Date: becomes one of the writeable Date fields (there aren't any), so I've put it in the Comments field. Any ideas? Would anyone like to have a shot at completing the script as VBS? -- Noel -- Noel Tag: What do I need to install to use vbscripting Tag: 212971
  - 5
    - WMI class for finding RSOP of Security options. Hi, Can any body help me in finding WMI class for retreving the RSOP security options like as Ex: RSOP_AuditPolicy which will give the RSOP values of the audit policy. we have "RSOP_Security settings" but this is giving account policy values. Please mail me your helpfull answers to "sheshu_142@hotmail.com" Thanks in advance. Tag: What do I need to install to use vbscripting Tag: 212969
  - 6
    - Reading file from certain point Hi chaps, I need a script to search a log file (whose name is DD-MM-YYYY.log) for an error (for example "AN ERROR!"). However, even though the script rolls over each day, the files can get very large, and errors occur often. This script will be run at regular intervals (every 15 mins I reckon at the mo) and needs to return something like a 1 if an error string was found and a 0 if not. This value in turn will be used by the alerting package to fire off alerts and poke things to get it working again. Now, i've got all that working more or less (getting the date bits to auto-fill the filename is being a pain) expect for one important bit. In my script, the log file is opened and then searched line by line, and if an error is found, 1 is returned. The problem is that it restarts from line 1 each time it's fired, so basically we are always getting alerts, even for alerts we have already been told about. What I need is some way to store the last line that was checked by the script, and to start from the following line on the next check. I guess this would in turn have to save the line number to a text file and read it back when the check starts next. Any ideas how I can do the latter bit? Finding the line number and then starting from that point again ? Olly Tag: What do I need to install to use vbscripting Tag: 212948
  - 7
    - If not ComputerName is ... then ... Hi, How would I do a vbs logon script which checked the workstation's ComputerName and if this name *starts* with anything else than the strings 'Class-A-' OR 'Class-B-' a messagebox should pop up with a custom message. How would I do that ...? Thanks ;-) best regards jake Tag: What do I need to install to use vbscripting Tag: 212947
  - 8
    - VBA macro for find the and replace with color Hi All, I need the VB script (VBA macro) that finds particular text and then replace the background color of the cell in the excel. Find should fbe in xlPart and not XlWhole (i.e it should find Banana even if cell contains "Banana Apple" and replace it background color) I have excel function that find the text and replace it with text only. Not with cell color. And one more thing , I want to find more than one word. ===================================================== Sub FindAndReplace() ' Copies Column E (Title Col) to Column I(Blank column) so that we have Tile in D as it is Sheets("Sheet1").Range("I:I").Value = Sheets("Sheet1").Range("E:E").Value ' Find And replce in Column I Sheets("Sheet1").Select Range("I:I").Replace What:="Marketing", Replacement:="ABCD", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False End Sub ===================================================== Thanks in advance... Tag: What do I need to install to use vbscripting Tag: 212946
  - 9
    - Using ASP to loop thru an XML file and generate HTML Hi All and thanks in advance for any help I can get with this! I'm very new at ASP/XML/HTML, but pretty comfortable with VB/VBScript. I've been tasked with some web content development tasks, and among them is a 'catalog' style page of images. Rather than hard-coding all the items, I wanted to use an XML file to store all the image paths and descriptive text, and just loop thru it to generate the HTML I need. Later on I'll be adding things like filters on category, etc., but for now I just want to get a simple protoype working. Below is what I've come up with but it just isn't working (keep getting HTTP 500 Internal Server Error with IE 6). The objects/methods worked pretty well in VB, so I'm wondering if it's in my handling of the quotation marks... Thanks again for the help! Hal [XML File] <?xml version="1.0" encoding="UTF-8"?> <items> <item> <imgpath>images/success_do.jpg</imgpath> <described>"Success Means Do.." Poster 24X16</described> </item> <item> <imgpath>images/Think_Twice.jpg</imgpath> <described>"Think Twice.. Act Once" Poster 18X36</described> </item> </items> [ASP Page Text] <html> <% dim strServer dim objXML, xNodeList, xNode dim i , s, sDesc, sPath strServer = Request.ServerVariables("SERVER_NAME") %> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta http-equiv="Content-Language" content="en-us"> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta name="Author" content="Publishing, Desktop" /> <meta name="Contact" content="Publishing, Desktop" /> <title>Order Framed Art</title> </head> <body> <% set objXML = Server.CreateObject("Microsoft.XMLDOM") sPath = "http://" & strServer & "/vendor_mgmt/docs/artlist.xml" objXML.async = False objXML.load(sPath) If objXML.parseError.errorcode <> 0 then Response.Write "Sorry, an error occurred retrieving information." else Set xNodeList = objXML.documentElement.getElementsByTagName("item") If xNodeList.length > 0 then For i=0 to xNodeList.length-1 '[imgpath] element/field sPath = "http://" & strServer & "/vendor_mgmt/" & xNodelist.Item(i).childNodes(0).text '[described] element/field sDesc = xNodelist.Item(i).childNodes(1).text s = "<a title=" & Chr(34) & sDesc & Chr(34) & " href=" & Chr(34) & sPath & Chr(34) s = s & & " target=" & Chr(34) & "_blank" & Chr(34) & ">" Response.Write s s = "<img border=" & Chr(34) & "0" & Chr(34) & " src=" & Chr(34) & sPath & Chr(34) & " width=" & Chr(34) & "50" & Chr(34) s = s & " height=" & Chr(34) & "50" & Chr(34) & " align=" & Chr(34) & "middle" & Chr(34) & "></a><br />" Response.Write s s = "<a href=" & Chr(34) & sPath & Chr(34) & " target=" & Chr(34) & "_blank" & Chr(34) & ">" & i & ". " s = s & sDesc & "</a>" Response.Write s next else 'no items exist end if end if %> </body> </html> Tag: What do I need to install to use vbscripting Tag: 212940
  - 10
    - VB script to download txt file I need a simple script to do the following in an Excel macro 1.) Open Internet Explore 2.) Go to a specific URL 3.) Download a file 4.) save it to my computer for future use with macro. I have been working at this and the only thing I can get working is step 1. Any help would be greatly appreciated. Tag: What do I need to install to use vbscripting Tag: 212934
  - 11
    - Basic Class Concept Hi, All, How to declare the class: Class A Property A1 Property A2 For each property, there are two properties B1 and B2, so you can use then as following: dim cls: set cls = new A cls.A1.B1="11" cls.A1.B2="12" cls.A2.B1="21" cls.A2.B2="22" Another question is: if the Class A has 20 properties and assign each one to a value with array: cls.A1=ar(1) cls.A2=ar(2) cls.A3=ar(3) ... How to use a loop for it? Thanks, -Andrew Tag: What do I need to install to use vbscripting Tag: 212933
  - 12
    - Default Separator for Date Hi [Slightly offtopic, no scripting issue] On English-US systems what is the default long date-format and separator? Is it MM/DD/YYYY or MM-DD-YYYY or MM.DD.YYYY or YYYY/MM/DD If there is no default what is the most common format to enter dates on the web, if the site is en-us? There is a difference between british and american date-defaults, isn't it? MfG, Alex Tag: What do I need to install to use vbscripting Tag: 212929
  - 13
    - Script Not Working Properly Hello, I have a script that restarts a service, I have it running from the Task Scheduler under Administrator. If I double click the script, it runs great, however, when the Task Scheduler runs it, the command prompt opens and nothing happens, it just sits there and the window never closes (the commands are never sent to the prompt). Below is the script: Option Explicit Dim objShell, intShortSleep, intLongSleep Dim strService Set objShell = CreateObject("WScript.Shell") ' Values set strService = "My Service" intShortSleep = 1500 intLongSleep = 5500 ' Cmd prompt opened objShell.Run "cmd" Wscript.Sleep intShortSleep ' Service stopped with 'Net' command objShell.SendKeys "net stop " & chr(34) & strService & chr(34) Wscript.Sleep intShortSleep objShell.SendKeys "{Enter}" Wscript.Sleep intLongSleep ' Service started with 'Net' command objShell.SendKeys "net start " & chr(34) & strService & chr(34) Wscript.Sleep intShortSleep objShell.SendKeys "{Enter}" Wscript.Sleep intLongSleep ' Cmd prompt exitedExit objShell.SendKeys "Exit" Wscript.Sleep intShortSleep objShell.SendKeys "{Enter}" Any Assistance is Greatly Appreciated, Chuck Tag: What do I need to install to use vbscripting Tag: 212926
  - 14
    - Add Computer account to AD Groups Hey everyone, I'm looking for a script to add a computer account to an AD Group by NetBios name. Anyone got one handy? Thanks! Tag: What do I need to install to use vbscripting Tag: 212925
  - 15
    - Can't Pull Installer Engine Patch File Property I am writing a script to push a small number of patches. I need to make a decision in the script based on the contents of the "Installer Engine" property, but can't find the Class that exposes this property. From the GUI you can find the information by viewing "Other version information" on the Version tab. I have noticed that the version tab only shows up for .exe files and the Installer Engine property only exists for patch files. I have tried filever and done some searching on msdn, but came up empty. If you know how to pull this info using vbscript or know of a command- line tool that will display the Installer Engine property please reply. Thanks Tag: What do I need to install to use vbscripting Tag: 212918
  - 16
    - Verification of input as a file or a folder Hello, I'm having an issue where I'm trying to create a script that parses through an input file where the lines in the input file is a folder path or a file name with the full path to the file, and that file or folder needs to be copied over to another location. For instance, the input file would look like this: c:\webroot\www.sheeltest.org\files\pdf\test1.pdf c:\webroot\www.sheeltest.org\files\pdf\test2.pdf c:\webroot\www.sheeltest.org\meeting\testmeeting\testmeeting.pdf c:\webroot\www.sheeltest.org\meeting\2008meeting\ The destination for these files would be: c:\webroot\www.sheelprod.org\files\pdf\test1.pdf c:\webroot\www.sheelprod.org\files\pdf\test2.pdf c:\webroot\www.sheelprod.org\meeting\testmeeting\testmeeting.pdf c:\webroot\www.sheelprod.org\meeting\2008meeting\ Is there a way to do this? Any help is appreciated. Thanks a lot! Sheel Tag: What do I need to install to use vbscripting Tag: 212917
  - 17
    - Need a script to show logon and logoff time for a specific user in Has anyone created a script to enumerate logon and logoff information for a specific user during a specified date range and then export the results to a .csv or txt file. Tag: What do I need to install to use vbscripting Tag: 212914
  - 18
    - Manipulating SAP User Accounts using VBScript Hello Everybody, I wonder if someone is able to assist. I need to create a VBScript to connect to SAP, Search for a User ID and then disable the User ID within SAP. I basically want to automate User Admin within SAP if I can. Does anyone know how I can achieve this? or have any links to sites where I can find some sample code? Kind Regards Chris Tag: What do I need to install to use vbscripting Tag: 212912
  - 19
    - Run VBS with Administrative Rights Hi all, I am currently writing a VBS file that will unregister a dll at logon for students but in order for this to be done the user needs to have administrative rights which we obviously don't want to give students. Is there a way I can make the script run as an administrator group policy or if there is a way I can add something to the script to make it run with administrative rights. Any help in this matter would be highly appreciated. Thank you Tag: What do I need to install to use vbscripting Tag: 212908
  - 20
    - Run VBS with Administrative Rights Hi all. I am currently writing a script that unregisters a DLL at login for students but the user needs Administrative rights to perform the operation which we obviously do not want to do. Is there way that I can make the script run at logon so they have aministrative rights. Thanks for any help you can provide Tag: What do I need to install to use vbscripting Tag: 212907
  - 21
    - Need vb script to show directory filtered thumbnail file list. All, Please modify this or supply code that will show a filtered list of files of a specified directory same as windows explorer and display files as thumbnails. Code: Private Sub OpenFolder(ByVal sFolderPath As String, Optional ByVal nView) Dim count As Long, lhWnd As Long, lPrevhWnd As Long, lhTargetWnd As Long ' Don't continue if the directory didn't exist If Dir(sFolderPath, vbDirectory) = vbNullString Then Exit Sub ' Find the last explorer parent window lPrevhWnd = FindWindow("CabinetWClass", vbNullString) ' Shell execute a new version of explorer Shell "explorer.exe /n,""" & sFolderPath & """", vbNormalFocus ' Loop until we find that new explorer parent window count = 0 lhWnd = lPrevhWnd Do While (lPrevhWnd = lhWnd Or lhWnd = 0) Or lhTargetWnd = 0 DoEvents count = count + 1 ' lhWnd = FindWindow("CabinetWClass", vbNullString) lhWnd = FindWindowEx(0&, lhWnd, "CabinetWClass", vbNullString) If lhWnd = 0 Then lhWnd = lPrevhWnd lhTargetWnd = FindWindowEx(lhWnd, 0&, "SHELLDLL_DefView", vbNullString) Debug.Print lPrevhWnd, lhWnd, lhTargetWnd, count If count > 100000 Then ' Fail out if we never find it so the program doesn't hang. MsgBox "Unable to find explorer window. Couldn't set the view mode.", vbCritical, "Couldn't set view mode" Exit Sub End If Loop ' Send the WM_COMMAND message to tell the window to change to the specified view mode SendMessage lhTargetWnd, WM_COMMAND, ByVal nView, 0& End Sub Tag: What do I need to install to use vbscripting Tag: 212898
  - 22
    - How to Create a ListBox Hi, All I would like to use a ListBox in VBScript. I am not using a web page or ASP Is there any way to do it using VBScript? Thanks, -Andrew Tag: What do I need to install to use vbscripting Tag: 212892
  - 23
    - Get date and time and format to DDMMYY-HHMM I am looking to get the date and time and format it into the format of DDMMYY-HHMM so that it can be added into the creation of a folder name. Does anyone have any ideas as to how this can be accomplished? Thanks, Sheel Tag: What do I need to install to use vbscripting Tag: 212882
  - 24
    - Search through permissions of all accounts on mail enabled users All, I am currently searching for the right way to complete this task. I need to enumerate all users within an OU that have mailboxes. Then I need to check the ACL's on those mailboxes for any users that are listed but do not have full control of the mailbox. As in, some of our vanity mailboxes have users that can view the mailbox, but they don't have full control. I'm attaching a little snipit of stuff i've tried, notice the section commented out, this was my first attempt. Then I tried using an array and that's not working either. Sub PerformQuery 'On Error Resume Next Const ACE_MB_FULL_ACCESS = &h1 Const ACE_MB_ASSOC_EXT_ACCT = &h4 Const ACE_MB_DELETE_STORAGE = &h10000 Const ACE_MB_READ_PERMISSIONS = &h20000 Const ACE_MB_CHANGE_PERMISSIONS = &h40000 Const ACE_MB_TAKE_OWNERSHIP = &h80000 Const ACE_MB_SYNCRONIZE=&h100000 Const ADS_ACETYPE_ACCESS_ALLOWED = 0 Const ADS_ACETYPE_ACCESS_DENIED = 1 Const ADS_ACETYPE_SYSTEM_AUDIT = 2 Const ADS_ACETYPE_ACCESS_ALLOWED_OBJECT = 5 Const ADS_ACETYPE_ACCESS_DENIED_OBJECT = 6 Const ADS_ACETYPE_SYSTEM_AUDIT_OBJECT = 7 Const ADS_ACETYPE_SYSTEM_ALARM_OBJECT = 8 Const ADS_ACEFLAG_INHERIT_ACE = 16 Dim OUTPUT_DELIMITER, empname, empuserid, empidnum, outhtml, txtUser, objUser, oSecurityDescriptor, dacl, ace OUTPUT_DELIMITER = vbTab Set con = CreateObject("ADODB.Connection") con.Provider = "ADsDSOObject" con.open Set command = CreateObject("ADODB.Command") Set command.ActiveConnection = con command.CommandText = "<LDAP://OU=Vanity,OU=Users,DC=domain,DC=com>;(&(objectCategory=person)(objectClass=user));displayName,ADsPath;subtree" command.Properties("searchscope") = 2 command.Properties("Page Size") = 3000 outhmtl = "<br>" & "The script is now processing the accounts." & "<br>" Set rs = command.Execute while not rs.eof Dim aceArray() Dim iCount txtUser = rs.fields("ADsPath") 'SystemOutput.InnerHTML = "The Adspath: " & txtUser Set objUser = GetObject(txtUser) Set oSecurityDescriptor = objUser.MailboxRights Set dacl = oSecurityDescriptor.DiscretionaryAcl Set ace = CreateObject("AccessControlEntry") 'Set objDictGroup = CreateObject("Scripting.Dictionary") For Each ace in dacl aceArray(iCount) = ace.AccessMask iCount = iCount + 1 'accessstr = "" 'accessmask = ace.AccessMask 'acetype = ace.AceType 'if (accessmask AND ACE_MB_FULL_ACCESS) = ACE_MB_FULL_ACCESS then ' select case acetype ' case ADS_ACETYPE_ACCESS_ALLOWED ' outhtml = outhtml & "The Mailbox: " & rs.fields("displayName") & " is okay." & "<br>" ' case else ' if (acetype <> ADS_ACETYPE_ACCESS_ALLOWED) and (acetype <> ADS_ACETYPE_ACCESS_DENIED) then ' outhtml = outhtml & "The Mailbox: " & rs.fields("displayName") & " has an account: " & ace.Trustee & " that does not have full control." & "<br>" ' end if ' end select 'end if 'objDictGroup.Add Next ReDim aceArray(iCount) i=0 FullAccessExists = False Do Until i = uBound(aceArray) if aceArray(i) = ACE_MB_FULL_ACCESS then FullAccessExists = True end if i = i + 0 Loop if not FullAccessExists then outhtml = outhtml & "The Mailbox: " & rs.fields("displayName") & " has an account: " & ace.Trustee & " that does not have full control." & "<br>" end if iCount = 0 rs.movenext wend Tag: What do I need to install to use vbscripting Tag: 212878
  - 25
    - Creating an Outlook Task with VB Script The following code fragment comes from here: http://www.microsoft.com/technet/scriptcenter/resources/officetips/sept05/tips0908.mspx Const olTaskItem = 3 Set objOutlook = CreateObject("Outlook.Application") Set objTask = objOutlook.CreateItem(olTaskItem) objTask.Subject = "Script Center Master Plan" objTask.Body = "Final report for Script Center master plan." objTask.ReminderSet = True objTask.ReminderTime = #12/12/2007 09:00 AM# objTask.DueDate = #12/12/2007 10:00 PM# objTask.Save It successfully creates an Outlook Task Item. Unfortunately it appears to have major flaw: The Due Time and the ReminderTime can be set for appointments that are in the past or on the current day but not for those that are in the future. For future dates it gets set to the Outlook "Working Day" default (e.g. to 08:00). Does anyone know how to get around this problem? Or how to create a "Reminder" instead of a "Task". I'm using Outlook 2003 Tag: What do I need to install to use vbscripting Tag: 212877

I have a SpeakClipBoard.vbs as follows:
[
Set ISpeechVoice = CreateObject("SAPI.SpVoice")

'read from clipboard
Set oIE = WScript.CreateObject("InternetExplorer.Application")
oIE.navigate "about:blank"
ISpeechVoice.Speak
oIE.document.parentWindow.clipboarddata.getData("text"), SPF_DEFAULT
Set oIE = Nothing

]

This speech script works fine on my machine [Windows XP Home Edition].
What 'installed software' on my machine enables this script to run.
And what might i need to (check for and) install on someone else's machine
to enable this script to run.

Also, how can I select different voices, programatically?
For instance, Select "Sam" or "Female Spanish".?

Thanks in advance!

ô¿ô
V e r n www.parentpresent.org
NoWorrys = KidSafe Internet Filter (Freeware)

Top

Re: What do I need to install to use vbscripting by Rafael

Rafael
Thu Dec 06 02:55:51 PST 2007

Hello

it's been a while since I played with text-to-speech engine which now has
been replaced by SAPI but here are a couple of links that might help you
find what you are looking for.

You can go to
http://www.microsoft.com/speech/speech2007/default.mspx to read more about
Speech technologies

and go to
http://msdn2.microsoft.com/en-us/library/ms723627.aspx
To get to know the application interface.

You will have to look for speech engines to find one that give you a
different voice and/or language. The old version of text-to-speech had many
by Lernout & Hauspie (I&H) but I do not think those are compatible with SAPI

As for VBScript, you can get the latest script engine at
http://www.microsoft.com/downloads/details.aspx?familyid=C717D943-7E4B-4622-86EB-95A22B832CAA&displaylang=en

Hope this helps.
--
**********
Rafael T

"vmars" <vm@verizon.net> wrote in message
news:%23yUu8U3NIHA.484@TK2MSFTNGP06.phx.gbl...
>I have a SpeakClipBoard.vbs as follows:
> [
> Set ISpeechVoice = CreateObject("SAPI.SpVoice")
>
> 'read from clipboard
> Set oIE = WScript.CreateObject("InternetExplorer.Application")
> oIE.navigate "about:blank"
> ISpeechVoice.Speak
> oIE.document.parentWindow.clipboarddata.getData("text"), SPF_DEFAULT
> Set oIE = Nothing
>
> ]
>
> This speech script works fine on my machine [Windows XP Home Edition].
> What 'installed software' on my machine enables this script to run.
> And what might i need to (check for and) install on someone else's machine
> to enable this script to run.
>
> Also, how can I select different voices, programatically?
> For instance, Select "Sam" or "Female Spanish".?
>
> Thanks in advance!
>
> ô¿ô
> V e r n www.parentpresent.org
> NoWorrys = KidSafe Internet Filter (Freeware)
>
>
>

Top