Excel 2003 filesystem dialog box...

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
    - Script request I am looking for a script that will scan a set of computers (based on an ActiveDirectory OU), and generate a list of all services, and their running account... (Not really required if the account is LOCAL SYSTEM). Also, a script that will scan all workstations/servers and generate a list of local accounts. I believe I have seen a RESKIT TOOL, that will generate a list of local account but must be on a machine by machine basis. Tag: Excel 2003 filesystem dialog box... Tag: 184051
  - 2
    - Create ODBC source - how to ? Hi, Do I have a way to call SQLConfigDataSource and SQLInstallerError from VBScript ? Or may be there is other way to achieve equivalent functionality ? Thank you in advance for your replies. Tag: Excel 2003 filesystem dialog box... Tag: 184050
  - 3
    - Network Neighbourhood enumeration - how to ? Hi, Of course it is possible to spawn 'net view' and look through its printout, But I would like to do this in proper Shell/COM way. I.e. starting from 'Entire Network', getting network types, then workgroups inside them, then computers inside workgroups. Please give me a direction on where to dig Thank you in advance. Tag: Excel 2003 filesystem dialog box... Tag: 184047
  - 4
    - Sending an email message Hi, I'm not very familiar with using vbScript and MS Office products. Can someone point me in the right direction regarding an error I am receiving when trying to send an email? The error I am getting is "The 'SendUsing' configuration value is invalid." My code looks like this: Set oMyMail = CreateObject("CDO.Message") oMyMail.To = "user@test.com" oMyMail.Subject = "Test Mail from script" oMyMail.Textbody = "Please ignore" oMyMail.AddAttachment "C:\output.txt" oMyMail.MIMEFormatted = False oMyMail.Send WScript.Echo "Message Sent From : " & oMyMail.From WScript.Echo " to : " & oMyMail.To I don't know if this is significant, but I'm using an Exchange 5.5 server, I have Outlook 2002 running as my client, and I am logged in as a non-Administrator. Thanks in Advance, JeffH Tag: Excel 2003 filesystem dialog box... Tag: 184041
  - 5
    - Object Expected Error I'm getting an error on this page that says Line: 76 Char: 2 Error: Object expected Code: 0 Can someone help determine what is causing this? thanks, Jackie [CODE BELOW] </script> <script language="javascript" type="text/javascript" src="dmstatscript.js"></script> <script> DMPage(); </script> </head> <body> <div id="pagewrapper"> <div id="logotop"> <a href="../index.asp" id="homelink" title="na & na">Home Page</a> </div> <div id="navtop"> <a href="../about/index.asp" id="link01" title="About">About Westar</a> [Line 76] <a href="../capabilities/index.asp" id="link03" title="Capabilities">Capabilities</a> <a href="../news/index.asp" id="link04" title="News & Events">News & Events</a> <a href="index.asp" id="link05" title="Careers" class="active">Careers</a> <a href="../contacts/index.asp" id="link06" title="Contact">Contacts</a> </div> <div id="breadcrumbs"><a href="../index.asp">Home</a> Â» <a href="index.asp">Careers</a> Â» Current Openings Â» Colorado</div> <div id="contentmain"> <div id="activestage" style="width: 516px; height: 312px"> <h1 id="sectiontitle">Current Openings in Colorado</h1> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" link="#333333" onLoad=";Stats()" stats=1 vlink="#666666" alink="#CC0000"> <td height="157"> <table width="454" border="0" cellspacing="0" cellpadding="0" height="18">  <tr> <td width="14"></td> <td valign="top" class="bodycopy" width="440" height="18"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <% Dim rsUserSpec Dim rsLocSpec Dim LocName jobcounter=0 While NOT rsNewsItems.EOF strSQL4 = "SELECT OfficeName FROM Offices WHERE LocationName = '" & rsNewsItems("WorkLocation") & "'" set rsLocName = Server.CreateObject("ADODB.Recordset") rsLocName.Source = strSQL4 rsLocName.ActiveConnection = objConn rsLocName.CursorType = adOpenForwardOnly rsLocName.Open Response.Write("<tr>") jobcounter=jobcounter+1 Response.Write("<tr>") Response.Write("<td class=""bodycopy"" width=""79%"" valign=""top""><B>Position:</B> " & rsNewsItems("PositionTitle") & "<BR>") Response.Write("<B>Location:</B> " & rsLocName("OfficeName") & "<BR>") ' Response.Write("<B>Description:</B> " & rsNewsItems("PositionDescription") & "<BR>") Response.Write("<B>For more information:</B> <A HREF=jobcode.asp?id=" & rsNewsItems("JobCode") & ">Click Here</A>" & "<BR>") Response.Write("<img src=""../shim.gif"" width=""10"" height=""10""> </td>") Response.Write("</tr>") Response.Write("<tr bgcolor=""#666666"">") Response.Write("<td class=""bodycopy"" width=""79%"" valign=""top""><img src=""../shim.gif"" width=""1"" height=""1""></td>") Response.Write("</tr>") rsNewsItems.MoveNext Wend If jobcounter = 0 Then Response.Write ("<font face=arial size=3 color=#b22222>There are currently no job postings available for this location.") Response.Write("<BR>") Response.Write("Please check back or select a new location.") End If set rsNewsItems = Nothing set rsUserSpec = Nothing set rsLocSpec = Nothing objConn.Close set objConn = Nothing Tag: Excel 2003 filesystem dialog box... Tag: 184038
  - 6
    - Script to reboot PCs Hi all, I was wondering if you can show me the code necessary reboot a Windows 2K or Windows XP equipmented PC? I frequently remote into a number of PCs and sometimes the need a reboot. Instead of asking someone directly and asking them to reboot the machines, isn't there a way to write a VBS script to do that? Can you also share with me the JScript equivalent for the WSH environment? Many thanks. Ben -- Tag: Excel 2003 filesystem dialog box... Tag: 184033
  - 7
    - Just-In-Time Debugger Shows Runtime Error in Startup Dialogue Box I'm just completing a working VBScript to use Telnet to send an e-mail when an error is detected by a scheduled task (for my sample I'm using not enough space on the C drive). I'm aware that there are also other solutions such as BLAT but I don't want to install any code. Everything seems to work well and I get the e-mail in my account but I have this nagging concern. The dialogue box labelled "Just-In-Time Debugger" has at the top the message "An exception 'Runtime Error' has occurred in Script.". It then lists Possible Debuggers of "New instance of Microsoft Script Debugger" and "New Instance of Microsoft Script Editor". If I step through there aren't any apparent problems. Do I really have a problem? Thoughts??? Tag: Excel 2003 filesystem dialog box... Tag: 184032
  - 8
    - WSH Hotkey When setting the WSH .Hotkey property how is the hotkey value set to the default "None"? Whatever I use becomes the hotkey since the value assigned to this property must be a string. Dim oShell As New IWshShell_Class Dim oShortCut As New IWshShortcut_Class oShortCut.Hotkey = ??? 'Default..."None" oShortCut.Save Set oShell = Nothing Set oShortCut = Nothing I cant simply not refer to the hotkey property because it is overwriting an already existing shortcut that has a hotkey in place but needs to be overwritten. Tag: Excel 2003 filesystem dialog box... Tag: 184031
  - 9
    - let user change permission on his home-folder dear vbs-ng, i could not find any help in the wsh-ng; may be you have an idea: the following script runs as a logon-script for a w2k3 domain for every user. it creates a home-folder and should set the permission for the administrator and the user. the permissions for the administrator are correct, but the user who started the script during login, does not have any rights. how can i give the user full right for its own home folder in a script ? thanx alot tim Dim WshNetwork, LogonUser Set WshNetwork = WScript.CreateObject("WScript.Network") Const WAIT_ON_RETURN = True Const HIDE_WINDOW = 0 Const USER_ROOT_UNC = "\\server01\home$" Const USER_ROOT_LOCAL = "D:\home" LogonUser = WshNetwork.UserName Call CreateHomeFolder(LogonUser) Sub CreateHomeFolder(strUser) Dim WshShell, objFS Set WshShell = Wscript.CreateObject("Wscript.Shell") Set WshNetwork = WScript.CreateObject("WScript.Network") Set objFS = CreateObject("Scripting.FileSystemObject") Call objFS.CreateFolder(USER_ROOT_UNC & "\" & strUser) Call WshShell.Run("cacls " & USER_ROOT_UNC & "\" & strUser & _ " /e /g Administrators:F", HIDE_WINDOW, WAIT_ON_RETURN) '--> setting the users permission Call WshShell.Run("cacls " & USER_ROOT_UNC & "\" & strUser & _ " /e /g " & strUser & ":F", HIDE_WINDOW, WAIT_ON_RETURN) End Sub Tag: Excel 2003 filesystem dialog box... Tag: 184030
  - 10
    - Getting clients active DFS server name? Hi! :) I need to check the connection speed between the client and the server before I start a program installation. My problem is that the installation files are on a DFS share. What I need is a list of the possible servers for this DFS share and if possible, the currentlly active one. In windows(xp) it's just to right click the directory accessed through a dfs to see a list of the servers (The active one's marked). This must be possible to get this information through a script to... Please help. :) (I'm using Win32_PingStatus to get the speed of the connection. If anyone's got better way, please tell me. :) ) Thanks a million! :-) /Sofia Tag: Excel 2003 filesystem dialog box... Tag: 184029
  - 11
    - Window name Hello, How to obtain the window name using only the executable path? Thanks, --=20 "A maior gl=F3ria n=E3o =E9 ficar de p=E9, mas levantar-se cada vez que se = cai." Conf=FAcio Vinicius Canto Xavier - MCP Windows 2000 Server & SQL Server Ciencias da Computa=E7=E3o 2004 - ICMC/USP - Brasil Tag: Excel 2003 filesystem dialog box... Tag: 184026
  - 12
    - SENDKEYS to Login to Windows Guys ~ has anyone used SendKeys to script a login to Windows. So, we have a Windows PC sitting at a logon screen and with a ?ap deploy tool? deliver a script to login as local admin. Can it be done were a Sendkeys will actualy pull up the login screen? Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.SendKeys "^%{DELETE}" Your thoughts please - vusio ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: Excel 2003 filesystem dialog box... Tag: 184019
  - 13
    - Recursing Folders I have a task where I need to find matching file names under two folders including subfolders. I have a working recursive routine, but it seems to just quit recursing before completion. Does anyone have any ideas? Thanks a million for any help. Tag: Excel 2003 filesystem dialog box... Tag: 184017
  - 14
    - How do you pass arguments to a script Back in DOS, you had batch files that could accept opening parameters. How does one do that in VBS? Tag: Excel 2003 filesystem dialog box... Tag: 184013
  - 15
    - REGEXP Hello, I try to validate User Input via a Regexp. Unfortunately it is not working... The User types a chemical formular like: H2SO4 in order to handle this input properly via HTML the two numbers need to be put between <sub></sub>. And here where it all starts. Obviously these two tags have to occur in pairs. So I tried something like: ^\w*(<sub>\d*</sub>)*\w* But that didn't work out. Any ideas? thx Ralf Tag: Excel 2003 filesystem dialog box... Tag: 184008
  - 16
    - remove duplicate itunes songs here's a little script to remove those annoying itunes duplicates. just needs some modification such as your itunes directory... ----------------- Set objFSO = Wscript.CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder("D:\iTunes") Set colSubFolders = objFolder.Subfolders 'get inside each artist's folder For Each objSubFolder in colSubFolders 'Wscript.Echo objSubFolder.Name 'once inside the folder do the following... Set colSubSubFolders = objSubFolder.Subfolders 'Get inside each album folder For Each objSubSubFolder in colSubSubFolders 'once inside do the following 'WScript.Echo vbtab & objSubSubFolder.name Set colMP3Files = objSubSubFolder.Files For Each objMP3File in colMP3Files 'Wscript.Echo vbtab & objMP3File.Name strCurrentMP3Name = objMP3File.Name For Each objMP3File2 in colMP3Files 'Wscript.Echo Left(strCurrentMP3Name, Len(strCurrentMP3Name)-4) & vbtab & Left(objMP3File2.Name, Len(objMP3File2.Name)-6) If UCase(Left(strCurrentMP3Name, Len(strCurrentMP3Name)-4)) = UCase(Left(objMP3File2.Name, Len(objMP3File2.Name)-6)) Then 'Wscript.Echo(UCase(strCurrentMp3Name & vbtab & objMP3File2.Name)) Wscript.Echo objMP3File2.Path objFSO.DeleteFile(objMP3File2.Path) End If Next Next Next Next Tag: Excel 2003 filesystem dialog box... Tag: 184005
  - 17
    - Problem runing EXE file with PARAMETERS Hello All I'm building a script to automatizing my work, first i have to take all the files in a directory and rename there name e.g - 000.jpg, 001.jpg, 002.jpg ... but if the file is bigger then 59KB the script will call a program (convert) to resize the file so far the script do it's job to rename the files, but when i call the exe file, nothing happen. can any one help me here function CreateNewFolder(byVal Path, byVal NewFolderName) Dim objFSO Set objFSO = CreateObject("Scripting.FileSystemObject") Dim FullPath FullPath = Path & NewFolderName if Not objFSO.FolderExists(FullPath) Then objFSO.CreateFolder(FullPath) CreateNewFolder = True Else CreateNewFolder = False End If Set objFSO = nothing End function ' ------------------------------------------ Dim objFSO Dim objFolder Dim FolderPath Dim objFolder_Contain Dim foundFile Dim Crate_Folder_Named Dim strFilename Dim MaxFileSize MaxFileSize = 59000 FolderPath = "f:\test\" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder(FolderPath) Set objFolder_Contain = objFolder.Files Set oShell = CreateObject("WScript.Shell") Crate_Folder_Named = "Renamed Files" Call CreateNewFolder(FolderPath, Crate_Folder_Named) Dim Prfix Dim i Dim Lenght Lenght = 4 i=0 iRC = 0 For Each foundFile In objFolder_Contain Prfix = "" strFilename = foundFile.name ' ------------------------- Build The prefix for evry File ------------------------ For ii=1 to (Lenght-Len(i)) Prfix = Prfix & "0" next Prfix = Prfix & i Extention = Right(strFilename, len(strFilename)-InStr(strFilename, ".")) '------------------------------------------------------------------------ Dim fso, f1 Set fso = CreateObject("Scripting.FileSystemObject") Set f1 = fso.GetFile(foundFile) If (f1.Size > MaxFileSize) Then iRC = oShell.Run("convert -resize 90% " & f1 & " " & FolderPath & "test.jpg", 0, True) 'iRC = oShell.Run("ping 127.0.0.1 -t", 1, True) If iRC <> 0 Then WScript.Echo "convert returned error level " & iRC Else WScript.Echo "Convert finished" End If End If f1.Copy(FolderPath & "\" & Crate_Folder_Named & "\" & Prfix & "." & Extention) i = i+1 Next Set objFSO = Nothing '--------------------- Msgbox "DONE" Tag: Excel 2003 filesystem dialog box... Tag: 183998
  - 18
    - Question from newbie Hi all, I'm very new to VBScript. In fact, I've just learned VBScript today. My question is that whether or not I can call the Win32 API function GetSystemMetrics from VBScript ? In fact, I want to detect whether the machine is running Tablet PC OS. Thanks a lot. Tag: Excel 2003 filesystem dialog box... Tag: 183994
  - 19
    - Displaying the format floppy disk window Hi all, Does anyone know the VBScript that will display the format a floppy disk window/dialog. Thanks very much for your help Karen Tag: Excel 2003 filesystem dialog box... Tag: 183985
  - 20
    - How to clear Published Certificates in AD for all users using VB Hello All, We need to clear all our published certificates from AD. I was able to figure out how to do this per users/CN (script below) and I'm wondering if it is possible to do this at the OU level? Any help would be greatly appreciated. Thanks in advance! AJZ Const ADS_PROPERTY_CLEAR = 1 Set objUser = GetObject _ ("LDAP://cn=MyerKen,ou=Management,dc=NA,dc=fabrikam,dc=com") objUser.PutEx ADS_PROPERTY_CLEAR, "userCertificate", 0 objUser.SetInfo -- AJZ ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Excel 2003 filesystem dialog box... Tag: 183984
  - 21
    - Changing local admin passwords via vb script I found this script to change local computer account passwords. Set objUser = GetObject("WinNT://" & strComputer & "/Administrator,user") objUser.SetPassword("password") I am new to scripting and I am unsure if it is safe to run this script on the network. Does anyone have any experience changing passwords with scripts. Tag: Excel 2003 filesystem dialog box... Tag: 183983
  - 22
    - Writing into HKCU\...\Policies Hi, Since there is no way I can use script to modify GPO on a client PC (the PC is not in the domain), I am trying to modify appropriate Registry key that is responsible for the policy I need: HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\WindowsUpdate\DisableWindowsUpdateAccess"=dword:00000001 The problem is that a user does not local Administrator rights, so I cannot write that key/value. I could run VB script under local admin account, but then HKCU would become admins HKCU, and I need to modify HKCU for the user, not for the admin. I tried to play with HKEY_USERS tree and got some results on XP: I was able to find user's HKCU there and modify it, but on Windows 2000 SP4 the script fails. When I am enumerating subkeys in HKEY_USERS using StdRegProv function EnumKey (and the script is being run in the local admins context) it does not return list of subkeys representing user profiles. Instead, it retuns subkeys for .DEFAULT profie. Anyways, this probably not a good approach to do what I want. I could write some stuff on C++, but I need a hint how to elevate rights (maybe how to modify Access Token privileges or something like that) so that to change that registry key in HKCU. Thanks in advance, Alex Tag: Excel 2003 filesystem dialog box... Tag: 183978
  - 23
    - Creating folders using VB Script Hello. I have a small task I need to do at work. I have to create 2 folders within a folder structure. However I need to create these 2 folders in EVERY SINGLE existing folder AND their subfolders. So let's say we have folders Parent1, Parent2 and Parent3, each has sub-folders named Sub1 and Sub2. This script needs to create a folder named New1 and New2 (examples) within all Parents and Subs. Also each parent doesnt necessarily have 2 sub folders... some have 1, others have 20. Anyone know of a good way of doing this? Cheers! Tag: Excel 2003 filesystem dialog box... Tag: 183976
  - 24
    - How to enumerate moniker protocols ? Hi, In WinXP Pro, IIS 5.1 is managed by its own protocol, "IIS://", not by "winmgmts://.../microsoftiisv2/...". How should I enumerate moniker protocols with VBScript, and what docs should I read to learn what to do with them ? Thank you in advance for your reply. Tag: Excel 2003 filesystem dialog box... Tag: 183970
  - 25
    - How to resize a .HTA ? Hi, I am looking at Scriptomatic 2.0 and it is a great sample of useful .HTA-application. I have long searched an easy way to write a non-primitive GUI in something simpler than C++, and Scriptomatic2 offers very useful patterns to borrow and follow. Now I would like to resize my own .HTA window and have all inputs/controls to obey this resizing. F.e., in Scriptomatic2, 1st and 2nd rows should stick to top, Language, Output Format, and bottom-right buttons should stick to right, big script edit window should be resized in both dimensions, and hostname-list window should be resized in width but not in height. Please suggest me how should I specify this behaviour in layout, or how should I handle events to implement this functionality. Thank you in advance for your replies. Tag: Excel 2003 filesystem dialog box... Tag: 183969
- Next
  - 1
    - Thank you all for your help Dear people, With your help I have got a lot of useful knowledge about VBScript/WSH and other related stuff. Special thanks to ekkehard.horner , LakeGator, Bob Barrows, James Whitlow. Now I understand what docs I should read further. Hope I would get equally useful responses on my further questions. Thank you a lot. Tag: Excel 2003 filesystem dialog box... Tag: 183968
  - 2
    - LDAP Query Anomaly. In trying to return postOfficeBox I came across this problem I still can't explain... Perhaps someone can shed some light into this for me. I ran the following script to query LDAP for postal address, postal code, samaccountname, etc... Everything returns fine, except for postofficebox. I subsequently pulled a script off the MS site that returned the postofficebox via enumerateusers function, but I don't understand why this script just fails on postofficebox? ***************************************************************************Â** Option Explicit Dim objRootDSE, strDNSDomain, objConnection, objCommand, strQuery Dim objRecordSet, strUserDN, strOS, strFilePath ' Determine DNS domain name from RootDSE object. Set objRootDSE = GetObject("LDAP://RootDSE") strDNSDomain = objRootDSE.Get("defaultNamingContext") 'msgbox strDNSDomain ' Use ADO to search Active Directory for all users. Set objCommand = CreateObject("ADODB.Command") Set objConnection = CreateObject("ADODB.Connection") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" objCommand.ActiveConnection = objConnection strquery = "<LDAP://ou=angrc,ou=ang,dc=ang,dc=ds,dc=af,dc=mil" & ">;(objectCategory=user);" _ & "cn,postalCode,sAMAccountName,userPrincipalName,postOfficeBox;subtree" 'msgbox strquery objCommand.CommandText = strQuery objCommand.Properties("Page Size") = 100 objCommand.Properties("Timeout") = 30 objCommand.Properties("Cache Results") = False Set objRecordSet = objCommand.Execute ' Spreadsheet file to be created. dim strExcelPath, objExcel, objSheet, i strExcelPath = "c:\scripts\users.xls" ' Bind to Excel object. On Error Resume Next Set objExcel = CreateObject("Excel.Application") If Err.Number <> 0 Then On Error GoTo 0 Wscript.Echo "Excel application not found." Wscript.Quit End If On Error GoTo 0 ' Create a new workbook. objExcel.Workbooks.Add ' Bind to worksheet. Set objSheet = objExcel.ActiveWorkbook.Worksheets(1) objSheet.Name = "AD Users" i = 1 ' Enumerate user objects. Do Until objRecordSet.EOF strUserDN = objRecordSet.Fields("sAMAccountName") i = i + 1 objsheet.cells(i, 1).value = strUserDN objsheet.cells(i, 2).value = objRecordSet.Fields("postOfficeBox") objsheet.cells(i, 3).value = objRecordSet.Fields("postalCode") ' End If objRecordSet.MoveNext Loop objExcel.Columns(1).ColumnWidth = 20 objExcel.Columns(2).ColumnWidth = 30 objExcel.Columns(3).ColumnWidth = 30 objExcel.Columns(4).ColumnWidth = 30 ' Save the spreadsheet and close the workbook. objExcel.ActiveWorkbook.SaveAs strExcelPath objExcel.ActiveWorkbook.Close ' Quit Excel. objExcel.Application.Quit ' Clean up. objConnection.Close Set objRootDSE = Nothing Set objCommand = Nothing Set objConnection = Nothing Set objRecordSet = Nothing Wscript.Echo "Done" ********************************************************************* Tag: Excel 2003 filesystem dialog box... Tag: 183967
  - 3
    - Copy to Clipboard via VBSCript? Hello all, Is it possible to copy a text to clipboard via VBScript? i tired the following given in MSDN but this is not working strCopy = "This text has been copied to the clipboard." Set objIE = CreateObject("InternetExplorer.Application") objIE.Navigate("about:blank") objIE.document.parentwindow.clipboardData.SetData "text", strCopy objIE.Quit Does any one have any other option? Best Regards Karthik Tag: Excel 2003 filesystem dialog box... Tag: 183959
  - 4
    - ActiveX component can't create object: 'WScript.Shell' Hi, I'm trying to Print a PDF through VBS. I found related topics in this group. One solution I found was using WshShell.RegRead(...) But I'm getting following error for the code - Set WshShell = CreateObject("WScript.Shell") "ActiveX component can't create object: 'WScript.Shell'" I don't know the reason. I'm new to vbs and the issue is urgent. Can anyone help me? (I've installed Windows Script 5.6 .. What else should I check?) Tag: Excel 2003 filesystem dialog box... Tag: 183953
  - 5
    - Check type TS protocol Hi all On my TS server users will logon via RCP and ICA. Login script I must set different settings for RDP users and ICA users eg if user Tom login via RDP I must set settings A in registry but if iser Tom login via Citirx I must set - B in registry Do you know via vbs chceck type of connection? Have a nice day, Michal Tag: Excel 2003 filesystem dialog box... Tag: 183940
  - 6
    - Asp VBscipt and AOL proxy server variables. I hope this is the correct place to post this question. If not can someone point me at a more appropriate newsgroup. I have an Asp Vbscript server application which tries to get the ip address of the client. Mostly the ip address comes from IPAddress = Request.ServerVariables("HTTP_REFERER ") but where a proxy is being used this will contain the ip address of the proxy. In this circumstance the proxy server will normally place the real ip address into Request.ServerVariables("HTTP_X_FORWARDED_FOR") or HTTP_X_COMING_FROM or HTTP_FORWARDED_FOR etc etc My application deals with all that quite well but.... In the case of Aol this is not the case. All it sends is the proxy ip in HTTP_REFERRER and leaves the other server variables blank. I did find a note on the net which states that Aol do not forward the real ip as they consider it to be a security feature for their clients. But not everything reported on the net is correct. My question is: Can anyone confirm that it is simply not possible to obtain the real Ip address where the client is using Aol's proxy server? Then I can tell my boss to stop whittling and we can move on ;-) Regards Bill Tag: Excel 2003 filesystem dialog box... Tag: 183939
  - 7
    - Verify OS of remote computers from txt file I can't get this script to connect to WMI of each pc in the text file.It will ping then so I know it's reading the text file. What I did notice is there is a space after the last letter of the computer name, eg.. 'computername ', I tried using the Trim() command but the space still remains. If the ping command can get around the space why can't the GetObject? Maybe this isn't the problem but it is the only thing I can find. '****************************** PC's are already in text file Set objInputFile = oFSO.OpenTextFile("c:\pingresult.txt", ForReading) arrTargets = Split(objInputFile.ReadAll, vbCrLf) objInputFile.Close '****************************** Cleanup TMP files oFSO.DeleteFile(fResultFile) oFSO.DeleteFile(objInputFile) '****************************** Ping each PC in TMP file For Each strTarget In arrTargets Set objShell = CreateObject("WScript.Shell") Set objExec = objShell.Exec("ping -n 2 -w 1000 " & strTarget) strPingResults = LCase(objExec.StdOut.ReadAll) If InStr(strPingResults, "reply from") Then WScript.Echo VbCrLf & strTarget & " responded to ping." '****************************** Verify it is XP Servive Pack 1 Machine Set objWMIService = GetObject("winmgmts:\\" & strTarget & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_OperatingSystem",,48) For Each objItem in colItems OSver = objItem.Caption & " " & objItem.CSDVersion Next '***************************** Run a repair command If Instr(OSver, "Windows XP Professional Service Pack 1") Then strPath = "\\Server\installs\SMS 2003 toolkit 2\Uninstall\SMSunIst\NewSMSclean.vbs" Set objShell = CreateObject("WScript.Shell") objShell.Run ("cmd /c " & "psexec.exe" & " -s " & _ "\\" & strTarget & " " & "cscript //nologo " & strPath),0,true Else '***************************** It's not XP Service Pack 1 then quit wscript.quit End if End if Next Tag: Excel 2003 filesystem dialog box... Tag: 183938
  - 8
    - Netsh dhcp trouble i wish to use the netsh add server command in an unattended installation, however it will not work as it cannot find active directory. Anyone know how to get around this problem, i'm using 2003 Server standard. if i add the server through the gui it installs and authorises fine and it doesn't complain about Active directory then. thanks in advance D Tag: Excel 2003 filesystem dialog box... Tag: 183937
  - 9
    - spawn a process and read/write its stdout/stdin - how to ? Hi, In Unix shell, Perl and CMD.EXE this operation is pretty common. (p1 | p2, or open("p2|")) Please suggest what should I use in VBScript. Thank you in advance Tag: Excel 2003 filesystem dialog box... Tag: 183932
  - 10
    - WSH library reference Hi, Could you please direct me to more/less well organized reference on WSH library ? Sometimes official docs can be confusing for a beginner. For example, why "Dictionary" is in "Scripting.", and "RegExp" is in "VBScript." ? I have some background in Perl/Python/Ruby/Unix shell, so I would like to use WSH to its full potential. Especially I would like to know what interesting things can be done with CreateObject/GetObject. Please advise me a good way to find such knowledge. Thank you in advance. Tag: Excel 2003 filesystem dialog box... Tag: 183927
  - 11
    - Getting Checkpoint VPN-1 status? Hi, In a script we need to detect if Checkpoint's SecuRemote is connected. Anyone know of a good way to do this? Regards, Mattias Tag: Excel 2003 filesystem dialog box... Tag: 183926
  - 12
    - Script which tells, where user is logged on @Fosco: Thanks for the script. I already have similar solution for another thing. I was wondering, if there is any AD LDAP entry, which I can query for this information - it would be much easier and also faster. For the time being, I guess I would just use this kind of script... -- mcmallar ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Excel 2003 filesystem dialog box... Tag: 183923
  - 13
    - Retrieve a property value by its name - how to ? Hi, For a WMI object, I can get a list of its property names from its ".Properties_" Now I would like to retrieve a list or map/hash of all its property names and values, in pairs. In fact, finally I would like to get a structured hierarchical pretty-print of its innards, like JSON, XML or s-expression notation. Please suggest me the shortest way to achieve this in VBScript. What should I start with ? May be there is something ready-made ? Are there special cases for computable properties ? I am quite a beginner in WSH/VBScript/WMI, so I would appreciate your useful responses. Thank you in advance. Tag: Excel 2003 filesystem dialog box... Tag: 183921
  - 14
    - 'function'-like objects in VBScript Hi, In JScript, there is nice feature - function objects ("new Function"). Sometimes it is very useful to parametrize one function by passing it another functional object describing some specific actions in its body. Now I would like to know from you how to achieve similar functionality in VBScript ? Thank you in advance for your replies. P.S.: I would prefer JScript, but VBScript has better binding to COM and WMI, so I am forced to use VBScript. In JScript you have to hassle with VBArray/toArray, and it does not offer an easy way to put a SafeArray property back into the object. Don't know why Microsoft decided to do so ... Tag: Excel 2003 filesystem dialog box... Tag: 183920
  - 15
    - Cluster Monitoring Script Error Problem Hi, I am writing a script ot monitor some veritas clusters. The basics of the script is that it connects to the clustered server name using WMI, then enumirates the actual servername, logs this in the Event log, which is then picked up by OpenView. This works well when the server is up, the problems I am having is that when the server is offline, the WMI call, does not seem to finish running and does not return anything so, the error code to detect if the server is offline is never run. So the warning message is not written to the event log. This is kind of defeating the point of my script, as I don't really need to know when they are up but need OpenView to log an event when they go offline. Here is the setion of code I am having problems with, Sub CheckCluster ( strClusterName ) msgbox strClusterName Set objWMIService = GetObject("winmgmts:\\" & strClusterName & "\root\CIMV2") If Err.Number<>0 then msgbox "Error Generated " & Err.Number & " and " & " strClusterName WriteEvent "Cluster : " & strClusterName & " Can't Be Contacted", 1 err.clear Exit Sub end if Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_OperatingSystem", "WQL", wbemFlagReturnImmediately + wbemFlagForwardOnly) if objItem = vbnull or For Each objItem In colItems strNodeName = objItem.CSName Next 'WScript.Echo "CSName: " & objItem.CSName If strNodeName <> "" Then strSiteName = left (strNodeName, 4) Select Case (strSiteName) Case "SIT1" strActiveSite = "Site 1" Case "SIT2" strActiveSite = "Site 2" End Select WriteEvent "Cluster : " & strClusterName & " Running on Node :" & strNodeName & " Active Site is : " & strActiveSite, 0 Else WriteEvent "Cluster : " & strClusterName & " CAN'T BE CONTACTED CHECK OTHER DATA CENTRE IF BOTH ARE DOWN LOG CALLL", 1 End If End Sub Thanks, Richy Tag: Excel 2003 filesystem dialog box... Tag: 183918
  - 16
    - Load and Print PDF in IE Hello, I am developing a web application which will enable the users to print the PDF file stored on the server. The user should be able to print PDF through their local printers.So I am trying to Print a PDF through Scripting, and used "Acrobat Control for ActiveX". I was able to load the PDF in IE through Scripting, but PrintAll() or Print() command of the ActiveX control object doesn't seem to be working. I've used following code. <OBJECT id="myctr" height=480 width=640 classid=clsid:CA8A9780-280D-11CF-A24D-444553540000 VIEWASTEXT> <PARAM NAME="_Version" VALUE="327680"> <PARAM NAME="_ExtentX" VALUE="16933"> <PARAM NAME="_ExtentY" VALUE="12700"> <PARAM NAME="_StockProps" VALUE="0"> <PARAM NAME="SRC" VALUE="D:\usp\test.pdf">  </OBJECT> <script language =vbscript>myctr.Print()</script> How to invoke Print command of "Acrobat Control for ActiveX"? Tag: Excel 2003 filesystem dialog box... Tag: 183916
  - 17
    - Create local users on computers defined in a textfile Hi, I wanna use a script that creates a local user account and sets a password on a list of computes defined in a textfile. I can´t make the script work. I would also like to have a second run of the script to append the logfiles failed.txt and success.txt and if possible have a timestamp written to the logfiles between runs. Is this possible? Regards Jason set fsomain=createobject("scripting.filesystemobject") set failedmachines=fsomain.createtextfile(".\failed.txt") set successmachines=fsomain.createtextfile(".\success.txt") Dim txtcomputername Dim passwrd On Error Resume Next set machines=fsomain.opentextfile(".\pcs.txt") Do While not machines.AtEndOfLine txtcomputername = machines.ReadLine Set colAccounts = GetObject("WinNT://" & txtcomputername & "") Set objUser = colAccounts.Create("user", "admin2") objUser.SetPassword "8520" Set objGroup = GetObject("WinNT://" & txtcomputername & "/Administrators,group") Set objUser = GetObject("WinNT://" & txtcomputername & "/admin2,user") objUser.SetInfo objGroup.Add(objUser.ADsPath) If Err Then HandleErr() Else successmachines.WriteLine txtcomputername & " success" nCount = nCount + 1 End If loop Sub HandleErr() failedmachines.WriteLine txtcomputername & " " & "failed. " & Err.Number Err.Clear End Sub 'Close all open files txtdata.close failedmachines.close successmachines.close 'Messagebox med klar MsgBox nCount & " computers updated" set fsomain=nothing set txtdata=nothing set usr=nothing set dellasset=nothing Tag: Excel 2003 filesystem dialog box... Tag: 183915
  - 18
    - Script which tells, where user is logged on Thanks for info and code. I am very surprised that domain servers do not hold any info on who is logging on which machine. BTW, we do not use WINS. I heard it is possible to get this kind of information from WINS. -- mcmallar ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Excel 2003 filesystem dialog box... Tag: 183913
  - 19
    - browse folder dialog Hi, how can open a 'browse folder dialog' in vbs? like this one http://www.fadata.de/Suchen.gif I want the user to pick a FOLDER not a FILE! Thx Robin Tag: Excel 2003 filesystem dialog box... Tag: 183910
  - 20
    - display a message on a remote machine with vbs and without using (net send) Hey all. We have a set of kiosk machines that get signed on with low level user accounts (non admin/non power user type accounts) and I am trying to figure a way to popup a message on those machines using vbscript. I have tried both vbs and psexec and a combination of both, but I cannot seem to get the message to display. If I run a tasklist on the machines in question, I see the wscript job running, just never see the message? Surely someone has done this before? Tag: Excel 2003 filesystem dialog box... Tag: 183891
  - 21
    - Finding Thin Client name I know there is a way to find the name of a Thin Client using a batch file but I would rather find the name of the client using VBS. Is this possible and if so how do I do it. I currently run a Citrix Server and am looking at using the ThinClient name as the variable for mapping default printers. This way I can map the printer by the location of the client. Thanks for the help! Tag: Excel 2003 filesystem dialog box... Tag: 183889
  - 22
    - help with wscript.shell Below is my script for running a wsf nested with a seperate vbs file. The problem I'm running into is with the spaces in 'my group name' - If I put quotes around it, vbs execution fails (naturally). Is there a seperate character to depict quotes within quotes or something? Also, is it possible to use variables from within this line as well? like "My" & variable & "Group Name"? Set objApp = CreateObject("WScript.Shell") objApp.run "cmd /k cscript //nologo c:\progra~1\GPMC\Scripts\setGPOcreationpermissions.wsf my group name /Domain:Mydomain.com" Any help is appreciated -- Josh Messerschmitt Tag: Excel 2003 filesystem dialog box... Tag: 183887
  - 23
    - detect IP subnet in login scrip I have some users that travel from site to site. Each site has a different IP subnets (assigned via local DHCP.) I would like my logon scrip to determine which office a user is logged into based on the computers IP address. That way I could call another logon script (or goto section of a logon script) based on the IP address. I can then add printers and/or map drives according to the office being used. -check local IP -if IP = a.a.a.* goto siteAlogon -if IP = b.b.b.* goto siteBlogon etc. Thanks Ken Tag: Excel 2003 filesystem dialog box... Tag: 183886
  - 24
    - Customizing Output of Group Membership Currently, when I search for a users group membership i get an output like the following: Member of: CN=My Users,OU=Groups,DC=mydomain,DC=com How can I make it show like this: Member of: My Users I'm using VBScript. Tag: Excel 2003 filesystem dialog box... Tag: 183881
  - 25
    - use ConnectObject without WScript? Hello. I'm trying to make a (vb)script that does sockets: IE: SET Test = WScript.CreateObject("MSWinsock.Winsock", "Test_") SUB Test_Connect() : msgBox "Test::Connected" : END SUB The problem is, the program in which the script runs within, doesn't let me use the WScript object. I get this error i nthe program that runs the script: Error '424'; Object required: 'WScript' I runs fine is I run the script with wscript.exe or cscript.exe I tried the following: SET Test = CreateObject("MSWinsock.Winsock") ConnectObject Test, "Test_" SUB Test_Connect() : msgBox "Test::Connected" : END SUB But I get this error: Type mismatch: 'ConnectObject' I saw na example of ConnectObject byitself, which seems to be the same as WScript.ConnectObject, so why wont it work? I just want to do sockets and use events from it! Thanks. Tag: Excel 2003 filesystem dialog box... Tag: 183872

Is there a way to open an explorer type dialog box to help a user
select a folder to save a document in?

For instance, the user clicks on a submit button in a worksheet and a
explorer like dialog opens where the user and browse to the desired
folder and the click okay to pass that folder path back to the VBA
script.

Thanks
Kevin

Top

Re: Excel 2003 filesystem dialog box... by Kevin

Kevin
Mon Nov 28 13:18:36 CST 2005

Never mind. Found it.

Kevin

Top