Excel object... AEONS!

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
    - Handling User Intervention whilst MoveFolder Object execution HI all I would like to know what is the method or idea to handle a renaming of folder that requires user intervention. When i performed a manual rename of a folder, i find that there is a manual input required to proceed with renaming: "Renaming, deleting "Program" could make the program may cause the program not to work... It prompts for OK or Cancel... How do i handle this case in VB Script..? Thanks Karthik Tag: Excel object... AEONS! Tag: 193514
  - 2
    - Attempting to Run a script with Admin privileges Hey, We have an admin wrapper here that runs using local admin rights. It uses the run as command to kick off a script with privileges but when we put it into AD login scripts it runs ok but as soon as something takes focus away from the command prompt window it stops the password from being passed and it sits there prompting the user for a password. Here is the script we are using is there anything we can do to get around having to bring up the command prompt to pass the password or is there a decent third party ap that could do it for us. Any help would be appreciated. Script: Note user names and password changed for obvious reasons Function RunUpdates appl="runas /user:Adminuser " & """wscript update.vbs""" WshShell.run appl,2,bwaitonreturn Do Until WshShell.Appactivate("runas.exe") wscript.sleep(200) Loop WshShell.sendkeys "password" & "{ENTER}" End Function Tag: Excel object... AEONS! Tag: 193512
  - 3
    - Read in text to array help The text file I'm trying to read in looks like this: -u www.test1.com (0,0) -i 192.154.3.25 (0,1) -e 2 (0,2) -s 1 (0,3) -n 1 (0,4) -u www.test2.com (1,0) -i 195.142.5.84 (1,1) -e 1 (1,2) -s 2 (1,3) -n 2 (1,4) What I'm trying to do is to make a two dimensional array with the data stored as shown above. I'm aslo trying to add an IF statement that goes like this If read -u then increase one to rows place. (as shown in example above) If anyone could help me with a little example of something like this that'd be awsome. This is what I have so far, but I don't know if I'm even going in the right direction. It looks a little messy and confusing to me. Again thanks for the help in advance. Set objTextFile = objFSO.OpenTextFile("c:\scripts\servers and services.txt", ForReading) Do Until objTextFile.AtEndOfStream strNextLine = objTextFile.Readline arrSplitChar = Split(strNextLine , " ") If (arrSplitChar(0) = "-u") Then Redim arrHoldStuff = arrWebSiteInfo(i, j) Redim arrWebSiteInfo(i + 1, 0) For i = 0 To Next ElseIf ((arrSplitChar(0) = "-i") || (arrSplitChar(0) = "-e") || (arrSplitChar(0) = "-s") || (arrSplitChar(0) = "-n")) Then ReDim arrWebSiteInfo( i, arrSplitChar(1)) Else Loop Tag: Excel object... AEONS! Tag: 193481
  - 4
    - Separating characters from username Hi, I am trying to write a script which will help map a users network drive on logon. It requires me to separate the username into 3 parts. For example:- if the username is abc123 The network drive address would be \\serveraddress\users\a\b\abc123 I am using vbs to write this script and have gotten this far - Run "net use u: \\serveraddress\users\" & oNetwork.UserName & " /persistent:no" Does anyone know how I can get about doing this? Thanks. Dikshant Tag: Excel object... AEONS! Tag: 193470
  - 5
    - Update Database (mdb) script How do you update all of the records in an Access (.mdb) table where the checkboxes are not checked? -- Cadstillo Tag: Excel object... AEONS! Tag: 193467
  - 6
    - string to array How to convert string to Array in VB/VBScript I have a string and I need to parse each chars to check if that chars is the one I am looking for...looks simple ut not striking me at this moment.... I was planning to iterating the array to its length and find out the chars by ASC function.... Tag: Excel object... AEONS! Tag: 193466
  - 7
    - Rescursive file search DateLastModified Hi, I'm relative new to vbscript, so i need a little help. I'd like to make a script that recursively searches for files with a DateLastModified within an hour or two from the current date and time. It's from a root folder and all it's subfolders. Thanks in advance, Robertico Tag: Excel object... AEONS! Tag: 193465
  - 8
    - Controlling VPN via VBScript Hi, I have a VPN connection using Microsoft's VPN client that is brought up initially when the computer is started up. I need a VBScript that can monitor this connection, make note when it gets disconnected, and then schedule it to reconnect 30 or so seconds later. Is there a way to do something like this? Unfortunately, the redial feature is not an option. Thanks, Chris Tag: Excel object... AEONS! Tag: 193461
  - 9
    - deleting folders created more than 3 days old I am writing a script that deletes any empty folders created more than 3 days ago. It won't however go more than 4 days. I am not sure I understand why. It is a case statement that checks for the current date and 3 days prior and ends with: Case Else objFSO.DeleteFolder(strFolder) 'uncomment this to delete the folders Any ideas why it would stop after 4 days? I mean it should be that if it isn't one of the 3 days given it would default to deleting it, right? Or am I totally off base here? Tag: Excel object... AEONS! Tag: 193460
  - 10
    - Copy file Hello! I'm writing a script, that will copy 3 files. I need to do this in order (not in the same time). How can i check, that copy of first file ended? Leszek Tag: Excel object... AEONS! Tag: 193453
  - 11
    - Copy files up to 1Mbyte I use this command xcopy c:\source m:\dest\local /m/e/e/v/h/y which works quite well. Now I need to copy only files below 1 MByte because files greater than 1 MByte are rare but can fill the destination too quickly. (Sorry for my English) I think, the answer will be in VBS. Thanks for all Bernd Tag: Excel object... AEONS! Tag: 193450
  - 12
    - rename a folder full of jpgs with the size of the file Is it possible to use vbscript to rename a folder full of jpgs, giving each one a new name with its size in kilobytes? So "sample.jpg" would become "29.jpg" indicating that the file size of 29.jpg is 20 kb. Tag: Excel object... AEONS! Tag: 193449
  - 13
    - READONLY Form fields So, I want to have a form that gets submitted to itself adn then I set the fields to readonly, but I want to have an "Edit" button so that people have one last chance to fix everything without sending them to an all new page before submitting. Does anybody out there know of away within VBscript to change this setting within each form field w/o having to re-submit the whole page again? For instance: <input type="text" name="church_phone" value="" size="16" maxlength="20" class="dfinput" ID="Text10" <% IF request("formstatus")="locked" THEN %>READONLY<% END IF %>> So, when I first submit the form I set a variable formstatus to "locked", but when I click the edit button I want it to change to "editable". Thanks! Willie Tag: Excel object... AEONS! Tag: 193446
  - 14
    - Accessing Nodelistvalues from mssoap client with vbs Hi I should write a script with vbs which calls a webservice with the mssoap client. If I call a service which returns only one value there is no problem. But if I try to call a webservice which returns an array of objects i get some problems. The following code works without problems in vba but not in vbs. I found out that i get the error if I try to access a value from a nodelist like items(i).length. Is there an other solutions to access values from a object array? Does someone have an idea how I could solve this problem? thank's michel Public Function TestSoap2() Dim objSoap Dim strReturn() Dim strWsdl Dim strError Dim strEmbDate Dim items Dim item Dim i Dim z ' ' EXAMPLE calling a google web service strWsdl = "http://www.omnisolutions.ch/SLXService/service.asmx?WSDL" Set objSoap = CreateObject("MSSOAP.SoapClient") objSoap.mssoapinit (strWsdl) items = objSoap.GetDocuments2("Name") For i = 0 To UBound(items) Step 1 For z = 0 To items(i).length - 1 MsgBox items(i).item(z).Text Next 'item = items(i).item(0) 'MsgBox items.length Next ' msgbox items Set objSoap = Nothing End Function Tag: Excel object... AEONS! Tag: 193445
  - 15
    - Error Handling Hello friends, I have written a script that goes through folder looking for a sub-folder named "Cookies". If it filnds Cookies then it will enumarate all files in that folder and delete te files which are older than 7 days. I want to implemnet error handling where it reports what is wrong if it cannot perform the above mentioned functions and contunie with the loop. It displays the error message if there is a directory permmission related issue and exits the script rather than going through it. Can youplease point out the error? As you see I have implemented On Error Resume Next ststement pretty much in every loop just for troubleshooting but I really cannot pinpoint where it is not working __________________________________________________________________________ Dim objShell, objFSO, sUserProfile, objUserProfile, sAppDataFolder, sUserDir, SFolders Dim sAppData, objDocsAndSettings, objUser, IDate, oCookies, oFile, File, oFilesCollection, tCookies, col Set objShell = CreateObject("Shell.Application") Set objFSO = CreateObject("Scripting.FileSystemObject") set sUserDir = objFSO.GetFolder("D:\TEST") ' Get user profile folder ShowSubFolders objFSO.GetFolder(sUserDir) ' Get Sub Folders 'On Error Resume Next Sub ShowSubFolders(Col) On Error Resume Next For Each SubFolder In Col.SubFolders If SubFolder.name = "Cookies" Then Wscript.echo "Deleteing Files From" & Space(2) & SubFolder.Path Set oFilesCollection = SubFolder.Files 'On Error GoTo 0 'On Error Resume Next For Each oFile IN oFilesCollection IF DateDiff("d",oFile.DateLastModified,Now)>7 Then oFile.Delete(True) If Err.Number <> 0 Then WScript.Echo "Can't Delte the file" & Space(2) & oFile.Path WScript.Echo "(" & Err.Number & ") " & Err.Description 'WScript.Echo "" WScript.Quit Err.Number End if 'Wscript.echo oFile.name Err.clear End If next 'On Error GoTo 0 End If 'On Error GoTo 0 ShowSubFolders SubFolder 'Err.clear Next 'Err.clear End Sub Thanks cha Tag: Excel object... AEONS! Tag: 193443
  - 16
    - Writing to Excel appending Please Help here is the problem this file will be on a network share when i rum the script the top portion works fine it opens the script and finds the first unused cell, the second part is just an example of what i want to do. when i run this on a computer i want it to write or append the information to the spreadsheet, and on a second computer third ect, can you please help i will need to write to at least 6 cells across x whatever down then the top portion will find the last used cell and it can start over again appending Thank you Bob M ----------------------------------------------------------------------------------------------------------------------------------- Const xlCellTypeLastCell = 11 Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\Test.xls") Set objWorksheet = objWorkbook.Worksheets(1) objWorksheet.Activate Set objRange = objWorksheet.UsedRange objRange.SpecialCells(xlCellTypeLastCell).Activate intNewRow = objExcel.ActiveCell.Row + 1 strNewCell = "A" & intNewRow objExcel.Range(strNewCell).Activate objRange.EntireColumn.Autofit() '========================================================================================= '========================================================================================= '========================================================================================= On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_Bus") For Each objItem in colItems Wscript.Echo "Bus Number: " & objItem.BusNum Wscript.Echo "Bus Type: " & objItem.BusType Wscript.Echo "Description: " & objItem.Description Wscript.Echo "Device ID: " & objItem.DeviceID Wscript.Echo "Name: " & objItem.Name Wscript.Echo "PNP Device ID: " & objItem.PNPDeviceID Next Tag: Excel object... AEONS! Tag: 193440
  - 17
    - update multiple PowerPoint files and modify ShockWave Flash page with new movies??? I'm lost trying to do this. I need to write a script to go thru many small Powerpoint presentations and embed new versions of movies in the ShockWaveFlash object. I can get to the right slide and detect the OleObject for the Flash but I can't figure out how to reference/modify it from the script. It's crude but I loop thru the slides looking for the OleObject ActiveWindow.Selection.SlideRange.Shapes(i).Select Select Case .Type Case msoOLEControlObject 'Type 12 If it's a OLEControlObject then I have the right page (all it contains is the ShockWave Flash movie. I just want to embed a new movie on this slide then save the presentation and move on. Is this possible?. If someone has a code snippett, it would help a lot.. Alternatively: I assume I could create a newslide and embed the movie Many Thanks from a VBS/WSH novice! Tag: Excel object... AEONS! Tag: 193435
  - 18
    - How users can update their own personal properties in Active Directory I wonder if it is possible for users update their personal properties in Windows 2003 - AD but only the fields i want to/choose. Can someone give me a tip or script how can this be done?... Thanks [] Ricky (sorry for so must posts) Tag: Excel object... AEONS! Tag: 193434
  - 19
    - HTA Logon Script I'm trying to create what I think would be a simple logon script. I've posted the general idea of what I want my log in script to do. We have AD 2003 wither xp and 2000 clients. I was assuming that it would be easy to crate a vbscript and then convert it to HTA. But I can't find any websites that are very clear. Can any one please suggest a beginners website? What I want to do is: -Have IE start with no tool bar or close button: -Display the school logo -Display a welcome message -Perhaps displeay something like the date and time and the name of the computer they're logged on to -Map several drives and then display the drives that are mapped (i.e. "Your home drive is H:, The Documents Drive is R:) -Map one or two printers and display the mapping -Display a link to report computer issues to the help desk -Display a link that goes to another HTA to allow users to add/delete printers -Display a link that goes to instructions of how to upgrade their computers to XP (a link to instructions to explain how to inititate an unattended install) -Then display a 'Close this window" -Just for fun, I thought it might be fun to have it setup so that when they click the close this window button, either it moves five inches and they have to click it again. Or it brings up another window saying "Are you sure you read the instructions" Or are you sure you want to close this window? But that would only confuse/annoy people so I wouldn't do it. It's just a passing thought. After they read it the first couple of times anyway, they'd know just to hit enter twice so they could ignore the messages. Tag: Excel object... AEONS! Tag: 193433
  - 20
    - Running a vbs file from a network path at logon What is the proper way of executing a vbs file from a network path upon start up of a machine in a workgroup not an ADSI? I have tried a variety of different netlogon paths and setting the home local to the network path, but I have not had any luck. I am sure I am missing something very simple, Thank you in advance. Tag: Excel object... AEONS! Tag: 193425
  - 21
    - capture a users home directory path to use as a folder name Below is part of a script I'm working on. This part is supposed to determine the user's existing home directory path so it can copy all the contents to the user's new home drive. How can I capture the existing home directory path? Thanks, Jeremy _____________________________ ' Determin existing home directory share path somehowe ' Pass existing home directory share path to variable objOldHomeDirectory = existing home directory share path ' Determining if existing home directory share is already on my server If InStr(objOldHomeDirectory, "\\s047") = 0 Then ' Create and share new home directory on \\s047-s0371-01 ***Code not presented here*************** ' Copy contents of existing home directory (including subfolders) and paste into the new home directory Set FSO = Wscript.CreateObject ("Scripting.FileSystemObject") objFSO.CopyFolder objOldHomeDirectory, \\s047-s0371-01\ & objHomeDirectory ' Change the Home Directory path in the Profiles tab objGroup.Put "HomeDirectory", \\s047-s0371-01\students\" & objHomeDirectory Tag: Excel object... AEONS! Tag: 193422
  - 22
    - Wxp - Locking CD-ROM Door Closed. Hello Everyone! ISSUE: locking CD-Rom door. (eg: you push the button and the tray dosn't open) OS: Windows XP Scripting Lang.: Visual Basic Script (.VBS) ================================ Basicly to use in a login script to lock the CD tray closed. and keep it locked untill I run a script to unlock the tray. I found some VB code to do this with the API's Since I'm new to .vbs I don't know how I could convert it to a script. can anyone help?? Thanks a million in advance. ~Marc Tag: Excel object... AEONS! Tag: 193418
  - 23
    - laptop / Desktop? Hi All, i would write a script that have difference procedure for laptop and desktop but i don't know which function can be check. any advise? thanks, William Tag: Excel object... AEONS! Tag: 193413
  - 24
    - xml.send errors???? 254643 cscript //nologo c:\util\ftpvbs.vbs "ftp://ftpav.ca.com/pub/inoculan/scaneng/Siglist.txt" "C:\TEMP\" "Siglist.txt" c:\util\ftpvbs.vbs(8, 1) msxml3.dll: System error: -2146697210. For the past 2 years, I have been successully issueing the following commands, every night, on Windows XP Pro, via the Task Scheduler. cscript //nologo c:\util\ftpvbs.vbs "ftp://ftpav.ca.com/pub/inoculan/scaneng/Siglist.txt" "C:\TEMP\" "Siglist.txt" cscript //nologo c:\util\ftpvbs.vbs "ftp://ftpav.ca.com/pub/inoculan/scaneng/ii_nt86.exe" "C:\TEMP\" "ii_nt86.exe" cscript //nologo c:\util\ftpvbs.vbs "ftp://ftpav.ca.com/pub/inoculan/scaneng/iv_nt86.exe" "C:\TEMP\" "iv_nt86.exe" cscript //nologo c:\util\ftpvbs.vbs "ftp://ftpav.ca.com/pub/inoculan/scaneng/fi_nt86.exe" "C:\TEMP\" "fi_nt86.exe" cscript //nologo c:\util\ftpvbs.vbs "ftp://ftpav.ca.com/pub/inoculan/scaneng/fv_nt86.exe" "C:\TEMP\" "fv_nt86.exe" The c:\util\ftpvbs.vbs file contains: Dim objArgument Set objArgument = Wscript.Arguments URL=objArgument(0) DestFolder=objArgument(1) ImageFile=objArgument(2) Set xml = CreateObject("Microsoft.XMLHTTP") xml.Open "GET", URL, False, "user", "pass" xml.Send set oStream = createobject("Adodb.Stream") Const adTypeBinary = 1 Const adSaveCreateOverWrite = 2 Const adSaveCreateNotExist = 1 oStream.type = adTypeBinary oStream.open oStream.write xml.responseBody ' Do not overwrite an existing file oStream.savetofile DestFolder & ImageFile, adSaveCreateNotExist ' Use this form to overwrite a file if it already exists ' oStream.savetofile DestFolder & ImageFile, adSaveCreateOverWrite oStream.close set oStream = nothing Set xml = Nothing About a week ago, I started to receive: c:\util\ftpvbs.vbs(8, 1) msxml3.dll: System error: -2146697210. I have no idea why or how to resolve this. I can manually download the 5 files with no problem. Prior to running the script, the previous versions of the 5 files are deleted from C:\temp. KB 254643 is the only article which has "System error" and -2146697210 Any help would be appreciated. Jerold Schulman Windows Server MVP JSI, Inc. http://www.jsiinc.com http://www.jsifaq.com Tag: Excel object... AEONS! Tag: 193406
  - 25
    - VBS file imports xml into access adp Hi everyone, I have a vbs file on a timed WinXP scheduled task that opens up Access 2003 then deletes older data from mssql server tables and then imports from an xml file using objAccess.ImportXML. This worked perfectly until last night when the server with the xml on it was down. Is there a way to check to make sure the xml is there before the routine starts? Kindest regards, Kevin Tag: Excel object... AEONS! Tag: 193404
- Next
  - 1
    - Dim stmt OK, first here is the code: sqlcmd = "SELECT space_available, ministry_id, pricing_id, min_group, max_group FROM tbl_event WHERE event_id = " + int_event + " AND (event_year = DATEPART(YYYY,GetDate()) OR event_year = (DATEPART(YYYY,GetDate()+1)))" set rs = conn.Execute(sqlcmd) IF rs("pricing_id") = 0 THEN bln_group = "false" ELSEIF rs("pricing_id") <> 0 THEN bln_group = "true" END IF 'This is the IF stmt that is giving me the problems IF num_spaces > rs("space_available") THEN bln_space = "false" ELSEIF num_spaces < rs("space_available") THEN bln_space = "true" END IF So, I am passing form data to this form, then doing a compare on some of the values. I pull from the database the total number of spaces available for the specified event and then compare that to the number of people they want to send to the event to determine if there is space available. I know this doesn't take into account if there are already registrations, that is the next step, but for now the compare is failing. When I write out the values, I get that the num_spaces is right, let's say 12 and the rs("space_available") is right, 225, but the compare is wrong, it resolves to bln_space="false". Now, I have been working on isolating this problem for like 18 hours (pathetic, I know), so perhaps some fresh eyes/minds can see where I have gone astray? Any input would be most appreciated. Willie Tag: Excel object... AEONS! Tag: 193399
  - 2
    - Uninstall software through VB scrips Trying to uninstall a software with it instead of reaching out to add and remove programs. Tag: Excel object... AEONS! Tag: 193394
  - 3
    - Stream object's Write method I'm trying out the following code: Set Shell = CreateObject("WScript.Shell") Set Stream = CreateObject("adodb.stream") adTypeBinary = 1 adSaveCreateOverWrite = 2 Stream.type = adTypeBinary Stream.Open Stream.Write Shell.RegRead("HKEY_CLASSES_ROOT\.zip\CompressedFolder\ShellNew\Data") Stream.SaveToFile "test.zip",adSaveCreateOverWrite The code errors out at the call to Stream.Write. According to the documentation for the Write method, it's expecting a Variant array of bytes. A type check of the Shell.RegRead call reveals that it does return a variant array containing bytes. The same thing happens if I replace the Shell.RegRead call with an Array of integers converted to bytes. The only thing that I can think of is that the Write method is expecting strongly-typed bytes, which is not possible in script. Is that the problem? Write method docs: http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthwrite.asp Tag: Excel object... AEONS! Tag: 193390
  - 4
    - Tool to convert PERL to VBS I am looking for a tool which can be used to convert PERL script to an equivalent VB script. I have done some googling but did not find one yet. If some one has done this please let me know. I tried Scriptomatic but could not convert it fully. Basically I have a PERL script that lists all shares on a list of servers (500), and add a deny group to them except admin shares. If anyone has a VB script please share. Thanks Tag: Excel object... AEONS! Tag: 193388
  - 5
    - Updating Access Information VIA VBS I have created an Access Database with a corresponding table to a script being executed. The vbs script will be executed at logon of a variety of different PCs (At this time not in an ADSI). When executed it will fill in the table with a variety of system information; comp name, ram, cpu, ect.... I have pretty much tweaked and finish the script to my liking, the only stage I have left is make sure that upon logon the script will check for updates to any of the system information, if updates exists to change the proper fields listed under that computer name (in the row). Currently I am using the computer name as the primary key, to avoid duplicate computer entries. (If there is a better way to handle duplicate information please let me know!) I found the following in TechNet Office Space. I believe the answer to my question is some how intertwined to a Recordset.Update, but I am unsure how to approach doing this. If anyone can help that would be fantastic any information needed from me please let me know and I will provide it ASAP. On Error Resume Next Const adOpenStatic = 3 Const adLockOptimistic = 3 Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") objConnection.Open _ "Provider = Microsoft.Jet.OLEDB.4.0; " & _ "Data Source = c:\scripts\inventory.mdb" objRecordSet.Open "SELECT * FROM GeneralProperties" , _ objConnection, adOpenStatic, adLockOptimistic strCriteria = "ComputerName = 'atl-ws-99'" objRecordSet.Find strCriteria objRecordset.Fields.Item("Department") = "Finance" objRecordset.Update objRecordSet.Close objConnection.Close Tag: Excel object... AEONS! Tag: 193381
  - 6
    - How to use WScript to execute DOS command line in VBScript Hi VBScript Expert, I am trying to execute the commandline from WScript object, but don't know the correct syntax as well as how to retrieve the commandline output result. Here are part of the codes for your reference: dim obj Set obj = WScript.CreateObject("WScript.Shell") obj.Run "Netstat.exe -n | find ""172.16.1.186:1388"" | find /C ""ESTABLISHED""" The whole purpose is to detect whether the connection to port 1388 has been established or not. If yes, do someting, else exit. Thanks for your help!!! -adam Tag: Excel object... AEONS! Tag: 193380
  - 7
    - WMI Output from different classes to CSV Hello, Using scriptomatic I thought it would be helpful to make a script to find the type of machine (Dell GX60, GX520, GX260 and so on) and BIOS version. I made the two scripts, whittled down the parts I don't need and now I want to put it into a CSV, the problem is that since the queries run against two different classes the For loops are seperated, making two lines per PC rather one in my destination CSV file. Is there a way to make the second For loop append to the correct line or have the loop run in such a way that the line I want is created? Here's my code (ignore wrapping by the NG engine): filePath = "C:\Temp\" filePrefix = "BIOS" fileExt = ".csv" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.CreateTextFile(filePath & filePrefix & fileExt) objFile.WriteLine "Computer Name,ID Number,Sytem Model,UUID,Serial Number,BIOS Version,Status,Version" arrComputers = Array("pc1","pc2","pc3) For Each strComputer In arrComputers Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_ComputerSystemProduct", "WQL", _ wbemFlagReturnImmediately + wbemFlagForwardOnly) For Each objItem In colItems objFile.WriteLine UCase(strComputer)&","&objItem.IdentifyingNumber&","&objItem.Name&","&objItem.UUID Next Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_BIOS", "WQL", _ wbemFlagReturnImmediately + wbemFlagForwardOnly) For Each objItem In colItems objFile.WriteLine UCase(strComputer)&","&objItem.SerialNumber&","&objItem.SMBIOSBIOSVersion&","&objItem.Status&","&objItem.Version Next Next Function WMIDateStringToDate(dtmDate) WScript.Echo dtm: WMIDateStringToDate = CDate(Mid(dtmDate, 5, 2) & "/" & _ Mid(dtmDate, 7, 2) & "/" & Left(dtmDate, 4) _ & " " & Mid (dtmDate, 9, 2) & ":" & Mid(dtmDate, 11, 2) & ":" & Mid(dtmDate,13, 2)) End Function Tag: Excel object... AEONS! Tag: 193379
  - 8
    - VB Script in totaling sums I have an Access database and am using Front Page with a little SQL and VB script to manipulate and display data. I am having some problems with a page that is displaying data properly but is not totaling points correctly by the desired variable. It is also not providing total points for the last entry on the page. I'm not sure this is the correct list to get help with this or not. Here is some of the code from the page. I need it to total points by NWHAHP even if there is a newshow or lastshow. I also need it to provide total points for the last NWHAHP entry on the page. Thanks in advance for any suggestions and assistance. If you need more information, please let me know.......DN <%@ LANGUAGE=VBScript %> <%dim Lastshow, Newshow, LastNWHAHP, NewNWHAHP Lastshow = " " Newshow = " " LastNWHAHP = " " NewNWHAHP = " " %> <%dim Totalpoints Totalpoints = 0.0 %> Within this area is the Database Results info.  </font> </font> <% Newshow = FP_FieldVal(fp_rs,"Name")%> <% NewNWHAHP = FP_FieldVal(fp_rs,"NWHAHP")%> <%if ((NewNWHAHP <> LastNWHAHP) and (LastNWHAHP <> " ")) or ((Newshow <> Lastshow) and (Lastshow <> " ")) then%> <tr><td nowrap colspan="3"> </td><td nowrap colspan="2"><font face="Arial" size="1" >Total Points</font></td><td nowrap ><font face="Arial" size="1" > <%=Totalpoints%></font></td></tr> <tr><td colspan="6"><hr width="100%"></td></tr> <% Totalpoints = 0%> <% end if %> <td nowrap ><font face="Arial" size="1" color="#000080"> <% Totalpoints =Totalpoints + FP_FieldVal(fp_rs,"Points")%> <%if ((NewNWHAHP <> LastNWHAHP) ) then%>  </tbody> <tr><td nowrap colspan="3"> </td><td nowrap colspan="2"><font face="Arial" size="1" >Total Points</font></td><td nowrap ><font face="Arial" size="1" > <%=Totalpoints%></font></td></tr> Tag: Excel object... AEONS! Tag: 193378
  - 9
    - Mapnetwork drive (not on the own machine) Hi, I'm a beginner in scripting and have a question about mapping a network drive. On my local machine (or as a logon script) this code works exactly as it should : Dim NetworkObject Set NetworkObject = CreateObject("Wscript.Network") NetworkObject.MapNetworkDrive "Z:", "\\server\user\LogFiles" But how can i do this e.g. from my machine on a remote machine ? I though that strComputer = "computername" defines the machine on which this script should run, but when i add this line to this basic script, it still runs on my machine. Please apologize for this question, but i'm just learning how to script in VB and currently i can't explain myself why this is not running in that case, in some other script i used this variable already and there it worked ? Best regards Uwe Tag: Excel object... AEONS! Tag: 193374
  - 10
    - Left join not working properly? I must be missing something simple but I have a SELECT query with a LEFT JOIN that works fine when I run it in Access but not when I run it from an ASP page against the exact same database. Here's a basic example that I can't get to work - the tables are set up like this: CUSTOMERS ========== ID NAME WARRANTY_PLAN_ID 1 John Smith 1 2 Jane Jones 0 3 Fred Johnson 2 WARRANTY ========== WARRANTY_PLAN_ID WARRANTY_TYPE 1 basic 2 extended 3 complete If I run this query: SELECT CUSTOMER.*, WARRANTY.* FROM CUSTOMER LEFT JOIN WARRANTY ON CUSTOMER.WARRANTY_PLAN_ID = WARRANTY.WARRANTY_PLAN_ID WHERE CUSTOMER_ID = 1 I get a single row back as you'd expect. But if I run this: SELECT CUSTOMER.*, WARRANTY.* FROM CUSTOMER LEFT JOIN WARRANTY ON CUSTOMER.WARRANTY_PLAN_ID = WARRANTY.WARRANTY_PLAN_ID WHERE CUSTOMER_ID = 2 It returns nothing. EOF. But that same query DOES work when I run it in Access. What am I missing? Thanks, Tom Tag: Excel object... AEONS! Tag: 193369
  - 11
    - wmic WMIC CALL allows execution of the methods available to a class. Can the GETSECURITYDESCRIPTOR method method of win32_logicalsharesecuritysetting be called using WMIC? Below is the result when I try - it isn't clear how to pass parameters to the method from the documentation. Anyone have experience with this? TIA Dave -------------------------------------------------------------------------------------------- wmic:root\cli>path win32_logicalsharesecuritysetting Caption ControlFlags Description Name SettingID Security settings of print$ 32772 Security settings of print$ print$ Security settings of HPOffice 32772 Security settings of HPOffice HPOffice Security settings of downloads 32772 Security settings of downloads downloads Security settings of recordings 32772 Security settings of recordings recordings Security settings of stuff (E) 32772 Security settings of stuff (E) stuff (E) wmic:root\cli>path win32_logicalsharesecuritysetting call /? Method execution operations. USAGE: CALL <method name> [<actual paramlist>] NOTE: <actual paramlist> ::= <actual param> | <actual param>, <actual paramlist> The following verb(s)/method(s) are available: Call [ In/Out ]Params&type Status ==== ===================== ====== GetSecurityDescriptor [OUT]Descriptor(object:Win32_SecurityDescriptor) Implemented [OUT]ReturnValue(uint32) SetSecurityDescriptor [IN ]Descriptor(object:Win32_SecurityDescriptor) Implemented [OUT]ReturnValue(uint32) wmic:root\cli>path win32_logicalsharesecuritysetting call getsecuritydescriptor Executing (win32_logicalsharesecuritysetting)->getsecuritydescriptor() ERROR: Code = 0x8004102f Description = Invalid method Parameter(s) Facility = WMI Tag: Excel object... AEONS! Tag: 193366
  - 12
    - Logon Script I am trying to create logs of user logon and logoff events to track for our employees to verify hours timecards hours. I have the following script applied as a logon script in a GPO: ECHO %username%,LogOn, %TIME%, %DATE%, %COMPUTERNAME% >> C:\%username%.csv I was wondering if there was a way to determine if the logon was via remote desktop or console. I know how to verify in the event log based on logon type but is there a way to get that information progmatically? Thank you for any help. I am new to scripting so any direction or code snippets would be greatly appreciated. Thank you again. Tag: Excel object... AEONS! Tag: 193365
  - 13
    - write to html text box vbscript Hi Guys, Im attempting to populate a text box in my asp.net solution using vbscript. Im able to read values from the text boxes using the following code (document.form1.txt_Product1.Value) im using the following code to try and write to it document.getElementById("lbl_ErrorHTML").value ="eeee" it doesnt work and gives the following error Microsoft VBScript runtime error: Object doesn't support this property or method: 'document.getElementById(...).value' can anyone help me with this ??? thanks C Tag: Excel object... AEONS! Tag: 193358
  - 14
    - RegEx Replace text not inside HTML tag Hi, My app generates a HTML results page and, while building up the page prior to writing it to disk, I want to add some extra HTML to highlight the text that has been matched via the search criteria of my app using RegExp. I am trying to create a pattern that will exclude HTML tags so that I can do a replace without junking the HTML. For example, if my result page looked like this: <HTML> <HEAD></HEAD> <BODY> <TABLE width=500> <TR> <TD>This is my sample page with a table and some text</TD> </TR> </TABLE> </BODY> </HTML> and a user types a lone "t" as the search criteria then the pattern needs to be able to search the entire page but only match the text not between a "<" and ">" so that the re-formatted page would look like this: <HTML> <HEAD></HEAD> <BODY> <TABLE width=500> <TR> <TD><span style='background-color:yellow;'>T</span>his is my sample page with a <span style='background-color:yellow;'>t</span>able and some <span style='background-color:yellow;'></span>ex<span style='background-color:yellow;'>t</span></TD> </TR> </TABLE> </BODY> </HTML> Cant for the life of me work out how to do this without junking the HTML! Thanks heaps Tag: Excel object... AEONS! Tag: 193353
  - 15
    - need to copy file to pc's in login script Hello, I need to copy a file to pc's in a login script. On the Pc the error that i get on the pc in eventvwr is Unable to copy screensaver to C:\Scsaver.scr: Object required Source WSH Event ID 4 Any ideas? All my research indicates that the logon GPO script runs using the Everyone Permission from the PC which has Read & Execute. I also added Write permission this did nothing. Tag: Excel object... AEONS! Tag: 193345
  - 16
    - VBS Newbie Hi, I am a total newb when it comes to programming. I am wondering if anybody can point me to a comprehensive guide to VBscript. I am having particular trouble with, objects, classes, methods, parameters, and properties. Is is a prerequisite that I know some other programming language before learning VBscript? Tag: Excel object... AEONS! Tag: 193340
  - 17
    - Clear cscript window output Is there a way to clear the screen when running a vbs script in cscript, like the cls command in dos and the syscls in rexx? Tag: Excel object... AEONS! Tag: 193333
  - 18
    - Multiple IP Address to Output into an Access Table I have been using the following script to gather IP information. Unfortunately now I need a script that can pull and separate the wired and wireless ip addresses for a local machine. When I implement the following script to write to an access database the database will only capture one of the two ip address, or it will use two rows to repeat the system information to display both IP address. I have used all the tricks I know and I have decided to seek help! If anyone has any input, it would be greatly appreciated. The temporary fix I have been using is to delimit the ips with a space, unfortunately I do need them to displayed in different fields for certain reports I will run from the database. So to recap: I need a script that can write both the IP Physical and the IP Wireless address to a table in two different columns not rows. If you need any information from me please ask, I am very interested in a solution to this problem. strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set IPConfigSet = objWMIService.ExecQuery _ ("Select * from Win32_NetworkAdapterConfiguration Where IPEnabled=TRUE") For Each IPConfig in IPConfigSet If Not IsNull(IPConfig.IPAddress) Then For i=LBound(IPConfig.IPAddress) to UBound(IPConfig.IPAddress) WScript.Echo IPConfig.IPAddress(i) Next End If Next Tag: Excel object... AEONS! Tag: 193332
  - 19
    - Creating database reports in MS Word using ASP I want to create an ASP page that will dynamically create a Word document based on a Recordset, and then display the document as an instance of Word in the browser. This is on an internal Web server, with everyone using Word 2000 and IE6. My goal is to have a page that can generate a printable report for any month or year selected. I tried using the script in this KB article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q301044) but it didn't create an instance of Word or Excel. It just dumped the content into the browser window. If creating an instance of an Office app involves too much programming overhead, is there a simple way of generating the necessary formatting so all content is formatted for printing on letter-size paper? Tag: Excel object... AEONS! Tag: 193331
  - 20
    - date time conversiton I have a column with value as timestamp. e.g. 2006-07-06 13:30:55.773000 I want to covert this to 24 hr clock timing how can I do this in scripting like VBscript thanks Tag: Excel object... AEONS! Tag: 193321
  - 21
    - group membership I'd like to create a script that loop through all of the groups in a particular OU and lists out members of each group. I've found scripts that do member lists, but you had to input the group name. Any help/links would be appreciated. Mar Tag: Excel object... AEONS! Tag: 193317
  - 22
    - Function Help Hi Everybody, I need to return "4,5,6,7,8" from "1,2,3,4,5,6,7,8,9,10" using a VB Script function. How can I achieve this. Any help is appreciated. TIA, Sunny Tag: Excel object... AEONS! Tag: 193312
  - 23
    - How to create a lookup table in VBScript Hi all, I am new to VBScript. I have, say 100, IP addresses, which are divided into 4 groups. E.g. UNIX_GRP: 192.168.1.2 192.168.2.3 192.168.8.200 ... (20 addresses in total) WINDOWS_GRP: 192.168.6.9 192.168.12.13 192.168.18.20 ... (65 in total) ROUTER_GRP: 192.168.1.1 192.168.2.1 ... (10 in total) FIREWALL_GRP: 192.168.1.2 ... (5 in total) Then I have a log file, which contains say 10,000 lines and each line contains an IP address (must in the above 100 addresses). I have to parse each line, get the IP address, and copy each log line into one of 4 files depending on which group the IP addres is in. I am thinking to create a lookup table for these 100 ip addresses, e.g. 192.168.1.1 ROUTER_GRP 192.168.1.2 UNIX_GRP ... So my script could easily figure out the ip address belongs to which group. I could do this quickly in unix shell or Perl, but I have to use VBScript for this project. I was wondering how to create a lookup table in VBScript, how to use IP-address as the array index or I have to use 2-d array. Or you might have suggestions to solve the problem. Thanks in advance. James Tag: Excel object... AEONS! Tag: 193311
  - 24
    - Sending data to a printer This seems like it should be easy, but I can't find any information in my documentation. Can somebody show me how to send "Hello, World!" to my printer? -- Crash Tag: Excel object... AEONS! Tag: 193307
  - 25
    - AJAX type databinding I have created a asp page that allows me to add records successfully to a database using a ajax methods. This works for me but i need to update the data table that is on the same page with the new record without refreshing the page. Does anybody know good methods for vbscript and ajax? Any help would be appreciated. Thanks. Tag: Excel object... AEONS! Tag: 193299

Hi,

I have a script where I'm doing this:

objExcel.Workbooks.Open strFile
objExcel.Cells(EXCEL_DATA_ROW_START, EXCEL_DATA_COLUMN).Select

Which works (almost) perfectly... It just takes FoReVeR!!! I'm opening
the file from a UNC share, and I've timed it about 15 times, and the
average came out at 17 seconds for the first line, and 11 seconds for
the second! And all the second line does is select a cell!

am I using something incorrectly? Should it really take almost 30
seconds to open an Excel file and get the contents of a cell? (And this
is running on a P4, 3,0GHz, 2GB, XP SP2, so it can't be because it's a
slow machine!)

If I open the file manually, it takes an average of 4 seconds to open,
and then as quick as I can be with a mouse to select a cell and copy
its contents.

Any advice greatly appreciated! :)

Plankmeister

Top