Delete row from excel

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
 - Unable to run vbscript at system startup Hello, I am trying to execute following script at system startup from SOFTWARE\Microsoft\Windows\CurrentVersion\Run. Now the problem is this script does not have exit/end if as it is meant for monitoring due to this startup is waiting for the script to end - which will never happen. If I run this script from user login everything works fine - but when the user logs out the script also gets terminated. I tried using batch file from within I called the vbs file but the batch also gets stuck at the vbs prompt and does not quit. I know I am missing something here but what? The script which needs to be run.... ---------------- Dim strComputerName strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colServices = objWMIService. _ ExecNotificationQuery("Select * from __instancemodificationevent " _ & "within 30 where TargetInstance isa 'Win32_Service'") i = 0 Do While i = 0 Set objService = colServices.NextEvent If objService.TargetInstance.State <> _ objService.PreviousInstance.State Then 'Wscript.Echo objService.TargetInstance.Name & " is " & objService.TargetInstance.State & ". The service previously was " & _ 'objService.PreviousInstance.State & "." 'Wscript.Echo objService.TargetInstance.Name if ucase(objService.TargetInstance.Name)<>"WUAUSERV" then if ucase(objService.TargetInstance.Name)<>"WINHTTPAUTOPROXYSVC" then if ucase(objService.TargetInstance.Name)<>"NTMSSVC" then if ucase(objService.TargetInstance.Name)<>"CREPSRV" then Set oWshShell = CreateObject("WScript.Shell") Set WshNetwork = WScript.CreateObject("WScript.Network") strComputerName = WshNetwork.ComputerName 'Wscript.Echo strComputerName Set objEmail = CreateObject("CDO.Message") objEmail.From = "ServiceStatus@adventity.com" objEmail.To = "ServerAdmin@adventity.com" objEmail.Subject = "Service Status Changed on " & strComputerName objEmail.Textbody = objService.TargetInstance.Name & " is " & objService.TargetInstance.State & ". The service previously was " & _ objService.PreviousInstance.State & "." objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = _ "advex01.corp.adventity.com" objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 objEmail.Configuration.Fields.Update objEmail.Send End If End if End if End if End if Loop ------------------------------- Tag: Delete row from excel Tag: 187813
 - 2
 - Need to reed data into a script I have a script that installs a TCP/IP printer port and shared printer. The script works fine. (See Below) However I need to install over 100 different printers to my print server. All the printer speciffic information I need is in an Excell spread sheet, (Port name, IP address, Driver name, Printer name, Share name, Location, etc. ). I want to run this script and have it create all my printer ports and printer shares. I know I will have to change the printer speciffic data in the script to variables, but I am not sure how to have the script read the data form either Excell or a .CSV file. I assume I will then have to setup some kind of loop. I am new to scripting and any help is appreciated. Thanks Chris Coates ccoates@gfs.com Dim oPort Dim oMaster Dim oPrinter Set oMaster = CreateObject("PrintMaster.PrintMaster.1") Set oPort = CreateObject("Port.Port.1") Set oPrinter = CreateObject("Printer.Printer.1") oPort.ServerName = "" oPort.PortName = "IP_10.251.1.94" oPort.PortType = 1 oPort.HostAddress = "10.251.1.94" oPort.PortNumber = 9100 oPort.SNMP = false oPort.SNMPDeviceIndex = 1 oPort.CommunityName = "public" oPort.QueueName = "" oPort.DoubleSpool = false oMaster.PortAdd oPort If Err <> 0 then end If oPrinter.ServerName = oPort.ServerName oPrinter.PrinterName = "NET957" oPrinter.Shared = True oPrinter.ShareName = "NET957" oPrinter.Location = "HR" oPrinter.Comment = "" oPrinter.EnableBidi = false oPrinter.DriverName = "HP LaserJet 8000 Series PCL" oPrinter.PortName = oPort.PortName oPrinter.DriverPath = "" oPrinter.InfFile = "c:\windows\inf\ntprint.inf" oMaster.PrinterAdd oPrinter oMaster.PrinterSet oPrinter If Err <> 0 then end If Tag: Delete row from excel Tag: 187812
 - 3
 - loops and tables This is a multipart message in MIME format. --=_alternative 0064CE658025711B_= Content-Type: text/plain; charset="us-ascii" I'm trying to loop through a text file that contains losts of surnames and produce a table with all the A surnames in row 1, B surnames in row 2 etc but I'm getting a bit stuck, I keep ending up with a table with 24 rows and only the surnames begining with A in all the rows. I realise I need to add another loop in somewhere to produce the table row and then move onto the next letter but i can't get my head round it at the moment. Here's my code: <table border="1" width="520" align="center"> <% for i = 65 to 89 do while objTextFile.AtEndOfStream <> True strTextFileLine = objTextFile.ReadLine if Left(strTextFileLine, 1) = i then strSurnameList = strSurnameList & strTextFileLine & "," end if Loop strMain2 = "<tr><td>" & strSurnameList & "</td></tr>" response.write strMain2 next %> </table> --=_alternative 0064CE658025711B_= Content-Type: text/html; charset="us-ascii" I'm trying to loop through a text file that contains losts of surnames and produce a table with all the A surnames in row 1, B surnames in row 2 etc but I'm getting a bit stuck, I keep ending up with a table with 24 rows and only the surnames begining with A in all the rows.  I realise I need to add another loop in somewhere to produce the table row and then move onto the next letter but i can't get my head round it at the moment. Here's my code: <table border="1" width="520" align="center">         <%         for i = 65 to 89                 do while objTextFile.AtEndOfStream <> True                         strTextFileLine = objTextFile.ReadLine                                 if Left(strTextFileLine, 1) = i then                                         strSurnameList = strSurnameList & strTextFileLine & ","                                 end if                     Loop                 strMain2 = "<tr><td>" & strSurnameList  & "</td></tr>"                 response.write strMain2         next         %>         </table> --=_alternative 0064CE658025711B_=-- Tag: Delete row from excel Tag: 187809
 - 4
 - Getting domain information in Windows 2000 Hello there. Hope someone can help me out here! I've got a script which uses the WMI service to get information about the domain, using this query.... Select * from Win32_NTDomain where DomainName='MYDOMAIN' From this information, I use the DcSiteName to automatically configure the local machine (long story). Anyway, this works fine - I can grab the domain controller site name under windows XP, but this won't work for Windows 2000. This is true, according to the scripting pages on Microsoft.com. So basically, im asking if there is a way I can find out the DC Site Name under windows 2000, using VBScript? Thanks in advance, Simon Tag: Delete row from excel Tag: 187806
 - 5
 - Modify Script to Enumerate Distribution Lists I use this script (below) to enumerate security groups a user belongs to. How can I enumerate Distribution Lists? They are not included in the Groups. I'm on a Server 2003 Active Directory domain, single domain (2003 Native mode). Script: dsRoot = "WinNT://Company/jsmith" set wshShell = Wscript.CreateObject("Wscript.Shell") set dsObj = GetObject(dsRoot) For Each Prop In dsobj.groups wscript.echo prop.name Next 'Prop Related question: Where can I find a list of the properties / collections used with "dsobj" ? Tag: Delete row from excel Tag: 187804
 - 6
 - delete dns zone I'm trying to find a script to delete a dns zone, but have not had any success. I've tried http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dns/dns/dns_wmi_provider_samples_managing_dns_zones.asp but this example seems over complicated. And the examples in the MS script repository don't mention deleting zones http://www.microsoft.com/technet/scriptcenter/scripts/network/dns/default.mspx Can anyone help? I think i need to use the delete_ method but am not sure how to implement it. Tag: Delete row from excel Tag: 187801
 - 7
 - How to change who can add computer to domain using vbscript Hi, I found the below vbscript from http://computerperformance.co.uk/vbscript/vbscript_computer_spreadsheet.htm which allows me to add computer accounts into Active Directory from a spreadsheet. That part works great. What I'd like to know is how to ammend this script so it allows a specified Group to join these computers to the domain. Any help would be much appreciated. ' ComputerSpreadsheetADV.vbs ' Sample VBScript to Create Computer Accounts from a Spreadsheet ' Author Guy Thomas http://computerperformance.co.uk/ ' Version 1.4 - May 2005 ' ------------------------------------------------------' Option Explicit Dim strComputer, strOU, strSheet, intRow Dim objRootLDAP, objContainer, objComputer, objShell Dim objExcel, objSpread ' -------------------------------------------------------------' ' Important change OU= and strSheet to reflect your domain ' -------------------------------------------------------------' strOU = "OU=newComputers ," ' Note the comma strSheet = "C:\newComputers.xls" ' Bind to Active Directory, Computers container. Set objRootLDAP = GetObject("LDAP://rootDSE") Set objContainer = GetObject("LDAP://" & strOU & _ objRootLDAP.Get("defaultNamingContext")) ' Open the Excel spreadsheet Set objExcel = CreateObject("Excel.Application") Set objSpread = objExcel.Workbooks.Open(strSheet) intRow = 2 'Row 1 often contains headings ' Here is the loop to cycle through the cells Do Until objExcel.Cells(intRow,1).Value = "" strComputer = objExcel.Cells(intRow, 1).Value ' Build the actual computer and add error-correcting code On Error Resume next Set objComputer = objContainer.Create("Computer", _ "cn=" & strComputer) objComputer.Put "sAMAccountName", strComputer & "$" objComputer.Put "userAccountControl", 4096 objComputer.SetInfo If err.number <> vbEmpty Then Wscript.Echo "Error " & err.number End If intRow = intRow + 1 Loop objExcel.Quit ' Optional section to launch Active Directory Uses and Computers Set objShell=CreateObject("WScript.Shell") objShell.Run "%systemroot%\system32\dsa.msc" WScript.Quit ' End of Sample ComputerSpreadsheetADV VBScript. -- Please reply to news group only. Thank you. Tag: Delete row from excel Tag: 187800
 - 8
 - Retrive Bios Events Hi, Is there a way of retriving the bios logs from a computer with a script. We wish to run a computer startup script on win2K based computers that would be able to look at the bios log to see if the case had been opened at some time. If so we will then need to take certain action. If this is at all possible could somebody be kind and show me a sample of the could that I would need to run. Thanks Kenneth Tag: Delete row from excel Tag: 187795
 - 9
 - Trying to write a program that would collect images received as email attachments Hello, Desperately, I am trying to find a way to write a program that would collect images received as email attachments and save them to a specific folder with a changed filename into whatever was the subject of that email. There would be one image per email. Here is how I think it would work: (1) Receive an image in email attachment. (2) Retrieve the image from that attachment. (3) Change the name of the image file into what was written in the Subject of that email. (4) Save the renamed image file into a specific folder. (4) Delete the received email I have done some research and found that the application would need to interact with MAPI. Could you please tell me if you have seen any similar programs written in VBScript somewhere on the internet, or could you give me some very specific advice or directions. P.S. I have my own Windows 2003 server, and can install anything on my server if I need to. Thank you, Vanessa Lee Tag: Delete row from excel Tag: 187793
 - 10
 - Automated way to clear custom event log Hi, Anyone know how to automate clearing of custom event logs? I've been able to clear the default logs with an modified script repository example: 'clears the event logs. strComputer = "." Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate,(Backup,Security)}!\\" & strComputer & "\root\cimv2") Set colLogFiles = objWMIService.ExecQuery ("Select * from Win32_NTEventLogFile where LogFileName='Application'") For Each objLogfile in colLogFiles objLogFile.ClearEventLog() Next Wscript.Echo "Application Log Cleared" Set colLogFiles = objWMIService.ExecQuery ("Select * from Win32_NTEventLogFile where LogFileName='Security'") For Each objLogfile in colLogFiles objLogFile.ClearEventLog() Next Wscript.Echo "Security Log Cleared" Set colLogFiles = objWMIService.ExecQuery ("Select * from Win32_NTEventLogFile where LogFileName='System'") For Each objLogfile in colLogFiles objLogFile.ClearEventLog() Next Wscript.Echo "System Log Cleared" Set colLogFiles = objWMIService.ExecQuery ("Select * from Win32_NTEventLogFile where LogFileName='Scripts'") For Each objLogfile in colLogFiles objLogFile.ClearEventLog() Next Wscript.Echo "Scripts Log Cleared" _________________________________________________________ But the custom log "Scripts" (also created from an example in the Script Repository) doesn't get cleared: Any idea how I can make this work? Tag: Delete row from excel Tag: 187792
 - 11
 - Changing Wav Files Hi, I have a telephone system that records all conversations as a standard WAV file. This Wav files are good for training purposes but no good for legal use. To make them usable in a court of law the recordings must be in an uneditable format. could this be done with VB Script? Regards Ian Tag: Delete row from excel Tag: 187789
 - 12
 - reggular expressions I would like to replace a "-" in a string but only when it is surounded by either a letter or a number. for example "A-4" or "3-V" but not "S-D" or "4-4" Thanks Tag: Delete row from excel Tag: 187765
 - 13
 - How to repeatedly check for a condition before continuing? Hello. In a batch file I can repeatedly check for a conditon before continuing: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :Repeat IF EXIST c:\temp\finished.log GOTO Continue ECHO "Not finished yet..." Sleep 60 GOTO Repeat :Continue ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Can anyone provide a simple, basic code snippet that will allow me to do the equivalent in VBScript? More specifically, I'm trying to check if a file has closed before continuing - and I need this checking to repeat itself in continuous loop. Thanks! Tag: Delete row from excel Tag: 187749
 - 14
 - Writing to a file and then reading the file contents How does one write to a file and then read the file contents with out closing the file inbetween (if it is possible)? I'm tinkering with the serial com port to see if the input buffer can be read after writing to the output buffer. I can write bytes and such to the comport by treating it like a file (substitute "COM1:" for the "test.txt"), so the next question is can I get the contents of the input buffer by reading the open file before closing it. Can the below code be fixed such that it can read the contents of the test.txt file after writing to it with out closing the file first? =================== Set fs=CreateObject("Scripting.FileSystemObject") Set a = fs.CreateTextFile("test.txt",True) a.write "this is a test" Wscript.Sleep 1000 'get test.txt file contents here 'wscript.echo test.txt file contents here a.Close() Tag: Delete row from excel Tag: 187747
 - 15
 - scripting IE to download ftp file I have run into problem with batch file execution of FTP. Every now and then the ls something*.txt gets hung. Consequently I wonder if I have better chance of IE as control from vbscript How do I find if a file of certain pattern exists from IE control? There may be more than one that fit the pattern, or maybe nothing. If present, I like to get the file name. However, I don't have a clue in this, as I am not dealing with html but FTP protocol from IE. I know how to make IE navigate to the desired directory but I need help to list content of the desired ftp directory ain terms of names, sizes, date time created if possible Thank you very much for your time. Tag: Delete row from excel Tag: 187742
 - 16
 - Script to compair two files Help? Hi I am trying to write a Windows 2003 Server logon script to compair two files ("file1" and "file2"), if the files are different (say in size) then I need to replace "file2" with "file1". The algorithm is: if file1 "is different" from file2 then Overwrite file2 with file1 (a simple "copy file1 file2" will suffice) Is there a simple way to do it using a script (VBScript) so I can run it when the user logs on? My VBScript knowledge is NIL, I have no problems compiling a Visual Basic program to perform the task, but would like to see how it can be done using a script. Any help would be appreaciated. Regards Gitendra Tag: Delete row from excel Tag: 187740
 - 17
 - Unloading and reloading Powerpoint Help Wondering if VBS would unload and then launch a .ppt and start the show on a remote computer? It's in the basement and viewed on remote tv's throughout building. MS Powerpoint 2003 w/(sp3) if it makes a difference. Thanks Nate Tag: Delete row from excel Tag: 187730
 - 18
 - Rename file extension Hello all, I need help to rename a file extension using the VBScript. I am relatively new to this and have put this much together so far: strComputer = "." Set objWMIService = GetObject _ ("winmgmts:" & "!\\" & strComputer & "\root\cimv2") Set colFiles = objWMIService.ExecQuery _ ("Select * from Cim_Datafile where Name = " _ & "'D:\\test\\test.txt'") For Each objFile in colFiles errResult = objFile.Rename("D:\test\test." & FormatdateTime(Now(),"ddhh")") Wscript.Echo errResult Next I need the file extension to be in the format test.ddhh complete with the two digit day and hour. Any help is appreciated. Thanks! JV Tag: Delete row from excel Tag: 187728
 - 19
 - Need help with another commandline argument I want to be able to close a running application like notepad.exe using vbscript (the simplest way I've found so far) using the test.bat batch file. The below test.vbs file is what I've come up with so far for testing. Test.vbs gets the notepad.exe as an argument, but i haven't found a way to get it to be successful in the script to close a running notepad.exe. If I substitute notepad.exe for the xxx down in the script, then the test.vbs will close the running notepad.exe. Any suggestions on getting it to work? Thanks! ========test.vbs======= Set objArgs = WScript.Arguments if objargs.count <> 1 then wscript.echo "expected a command-line argument" wscript.quit end if xxx = objArgs(0) wscript.echo "xxx" Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" _ & "." & "\root\cimv2") Set colProcess = objWMIService.ExecQuery _ ("Select * from Win32_Process Where Name = " & "'xxx'" ) For Each objProcess in colProcess objProcess.Terminate() next wscript.quit =======test.bat=========. @echo off test.vbs notepad.exe Tag: Delete row from excel Tag: 187726
 - 20
 - Frames and Window Resizing I have an HTML page which has two frames on it - Header and Body are the frame names. Is it possible to resize the window containing the html frames when the ASP page being displayed in the Body frame is loaded and reloaded? I guess what I am asking is how do I reference to the window containing the HTML page from one of the pages being displayed in one of the frames. If this can be done, can anyone supply some code segments for me to achieve this? Paul Smith Tag: Delete row from excel Tag: 187723
 - 21
 - Incidental Factiod: pertaining to ConnectObject/GetRef in Class Code A year ago, I posted a question/complaint about the apparent lack of support for "ConnectObject" or "GetRef" in class code. I had been attempting to instantiate a class from within an actX object and then connect with events fired by that class (not the actX object itself). This works well enough in "main line" vbs code, but not (as best I can tell) in class code. I recently tried to do the same thing, and failed again (groan!). I even searched this ng, and found my previous disgruntled posting. Then I remembered something, i.e., that you can refer to the current instance of class code as "Me", within the class. It occurred to me that "Me" might be equivalent (or even identical to) "GetRef". A "GetRef" gives you an object whose default member calls the routine which you specify. Likewise, if "Me" is a reference to the current instance, then if one refers to "Me" in code, then one will also get a call to the default member of "Me". Cut to the chase. This did work the way I expected it would, and I was then able to (in effect) do a "GetRef" in class code. Here is an example (although referring to a proprietary actX (oSCO) which is setting a "CBT Hook" to detect window openings). When it detects a window opening, it will call me back with the information: --- <snip> --- ' set an "ole callback" for the hookproc... Set oSCO.SetCallBack = Me ' reference to the default member of THIS instance ... ' this is "my hookproc" (called from real hookproc embedded in sco)... Public Default Function myHookWndFunc(uMsg, wParam, lParam) ... ' and this is the "real" hookproc located in the actX (oSCO) object. ' it will intercept the hookproc calls and refer them back to script. Public Function GenericHookProc(ByVal ncode As Long, _ ByVal wParam As Long, ByVal lParam As Long) As Long Dim oCallBack As Object Set oCallBack = m_oCallBack ' the ole callback GenericHookProc = oCallBack(CVar(ncode), CVar(wParam), CVar(lParam)) End Function --- </snip> --- Note: there is no documentation about "Me", other than another obscure ng posting by mikHar, way back in 2000. As an "undocumented- and-unsupported" feature, one might justifiably be cautious about using this, because in the past microsoft has abruptly "corrected" (i.e., removed) other undocumented-and-unsupported features. The "good news" is that it will probably take an "act of congress" for microsoft to ever do any further maintenance or support for vbs, so it is extremely unlikely that "Me" will ever go away anytime in the foreseeable future. cheers, jw Tag: Delete row from excel Tag: 187721
 - 22
 - DHTML question I am wrting Access DAP. On the page I need to create a new record based on a current rcord so I am developing copy operation. I have lots of HTML controls on the page. When I click new, it should keep all the data in the controls as it is except a few. How can I achieve this using DHTML thanks Tag: Delete row from excel Tag: 187718
 - 23
 - recursion to display records I am learning how to get records from a database. I was able to accomplish but I know there are 6 records and I only display 1. I know what to do but do not know how in vbscript. i think the script needs a for loop to display records until completed but was unable to get working. ----------------CODE BELOW-------------------- Const DB_CONNECT_STRING= "provider=SQLOLEDB.1;data source=localhost;database=PSMT;uid=mydbUser;pwd=???????" Set MyDB = CreateObject("ADODB.Connection") MyDB.Open(DB_CONNECT_STRING) SQLString = "select SystemName, Win32_ComputerSystem_TotalPhysicalMemory, OSInstallDate, LAST_UPDATED from SystemInfo where (Win32_ComputerSystem_TotalPhysicalMemory) < 120746688" set MemQuery = MyDB.Execute(SQLString) If Not MemQuery.EOF then SystemName = MemQuery.Fields("SystemName") PhysicalMem = MemQuery.Fields("Win32_ComputerSystem_TotalPhysicalMemory") OSINstallDate = MemQuery.Fields("OSInstallDate") LastUpdated = MemQuery.Fields("LAST_UPDATED") WScript.Echo(SystemName & vbtab & PhysicalMem & vbtab & OSINstallDate & vbtab & LastUpdated) End if MyDB.Close Tag: Delete row from excel Tag: 187717
 - 24
 - Setup.exe Silent intall w/.ISS not working I am a novice in vbscript. Nonetheless I have an application on all computers I need to be installed with a script on all computers. The following works: Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run = "D:\TL06\setup.exe -s -f1D:\TL06\setupNEW.iss", 1 True (-s is to silent install and the -f1 indicates the file location for the response file needed in the silent install.) The problem is the folder has a space, so with the change in folder name the following does NOT work: Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run = "D:\TL 06\setup.exe -s -f1D:\TL 06\setupNEW.iss", 1 True I tried adding extra quotes before and after but it does not work. I tried declaring variables for the files but that does not work either. I am missing something? or is it not possible to add arguments to a file who's path has a space in it? The error that comes up is that The system cannot find the specified file. Please help anyone. R D J Tag: Delete row from excel Tag: 187715
 - 25
 - Verify is a service can be stopped I am trying to automatically start a service that is failing. Before I can start the service, I need to verify that the service can be stopped. I have the following code that tells me the state of all services running that can be stopped. What I need to do is only check if a particular service can be stopped, then if it can, kick off the stop and restart of the service. I can stop and start, I just need to fix the following code to check for a particular service. strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colServices = objWMIService.ExecQuery _ ("Select * from Win32_Service Where AcceptStop = True") For Each objService in colServices Wscript.Echo objService.DisplayName Next Thanks Tag: Delete row from excel Tag: 187714
- Next
 - 1
 - XCOPY in VBscript Anyone have an xcopy-like written in vbscript? Not a script that calls DOS xcopy, but actually have a script that performs like xcopy? Thanks. Tag: Delete row from excel Tag: 187712
 - 2
 - SQL stored procedures: display both output and recordset I'd like to retrieve both a recordset and the output parameter from a SQL stored procedure. I can do one or the other but not both. The stored procedure itself is a simple query with an input and output parameter. The parameters: oCmd.Parameters.Append oCmd.CreateParameter("@ID", adVarChar, adParamInput, 15 , "9123456") oCmd.Parameters.Append oCmd.CreateParameter("@Return_Code", adVarChar, adParamOutput, 50, "") If I use: oCmd.Execute I can read the output parameter using: wscript.echo oCmd.Parameters("@Return_Code").Value or wscript.echo oCmd.Parameters(1).Value If I use: set rs = oCmd.Execute I can loop through the recordset and correctly display the data. I can't display the output parameter. I tried to use: Set rs = rs.NextRecordset wscript.echo oCmd.Parameters("@Return_Code").Value wscript.echo oCmd.Parameters(1).Value That doesn't work. I then tried to close the recordset: Set rs = rs.NextRecordset rs.close wscript.echo oCmd.Parameters("@Return_Code").Value wscript.echo oCmd.Parameters(1).Value To no avail. I did set nocount in the stored procedure. I can get either the output data or the recordset data so the stored procedure is returning the data to my script. At this point all I want to return is "Hello world" from the stored procedure. I'm new to the world of running stored procedures from vbscript, though I have been running queries for a long time. Any ideas? Swyck Tag: Delete row from excel Tag: 187711
 - 3
 - RePost: Problem handling Date Comparison in VBScript I had posted the following earlier. However, the help I got did not resolve the problem. I appreciate any advise/help to resolve the following. Thanks in advance. I have a html form with few fields. The fields are claim number, month, day and year. Actually the month, day and year together forms the claim date. There is also a variable named QuarterEndDate which contains the quarter end date value which happens to be 12/31/05. Now, before submitting the form, I need to do some validation check. The first validation (which I cannot get it to work) is that the claim date should be less than the Quarter End Date. The second validation is that there has to be a claim number regardless (which works by itself but does not when the first validation comes up). I would like to know what is the problem with the first validation in the code below? Function frm_Details_OnSubmit validation = TURE Function frm_Details_OnSubmit validation = TURE If DateValue((frm_Details.ExpMonth_0.value) & "/" & (frm_Details.ExpDay_0.value) & "/" & (frm_Details.ExpYear_0.value)) > DateValue(QuarterEndDate) Then Alert("You must enter claim date within the End Quarter Date") document.frm_Details.ExpMonth_0.focus frm_Details_OnSubmit =False ElseIf (frm_Details.ClaimNo_0.value = "") Then Alert("You must enter a value for Claim number.") frm_Details.ClaimNo_0.focus frm_Details_OnSubmit =False Else frm_Details_OnSubmit = True End If End Function Tag: Delete row from excel Tag: 187710
 - 4
 - ocx permission denied I've updated an ocx (using VB6) that is currently being used in an asp 3.0 application. I created an internet package(using VB6) containing the ocx and corresponding dll's. I then placed both the CAB and support files on my webserver. I also registered the dll's on the web server. I updated my asp script to reflect the new object's classid and version#. When I call the asp page I receive an alert "permission denied" when it calls the ocx. If anyone could provide some feedback on how to overcome this issue I greatly appreciate it. I also created a very simple ocx on my local machine complied and saved to my system32 dir. I tried using it on my local machine in an asp page; when it call the object's method on this com thru a windowonload event I received a prompt "object doesn't support this property or method"? Thanks in advance! Tag: Delete row from excel Tag: 187708
 - 5
 - Determine if a script was run from an HTA Is there a way to determine if an external vbscript was called from an HTA? Tag: Delete row from excel Tag: 187707
 - 6
 - Input box Hi all I would like to create a service dependance with the command: oShell.Run "sc config " & ServiceOVO & " depend= " & chr(34) & ServiceApplicatif & chr(34), 1,True My problem is that ServiceApplicatif is badly interpreted when it has spaces in the name. ServiceApplicatif is entered with the following line: ServiceApplicatif = InputBox("Enter the name of service Applicatif (Service name) " , "Service") How can I make sure that spaces in the inputbox are converted as spaces in the variable ? or how can I modify the string to insert chr(32) ? to have a correct service installation Thanks and have a good day Bruno Tag: Delete row from excel Tag: 187704
 - 7
 - List of the 20 most recent subfolders in a folder Hi, I'm looking for a script to read through the "subfolders" in a folder and make a list of the 20 most recent folders. Actually the "subfolders" are really zip files (pretending to be subfolders). TIA Alex Tag: Delete row from excel Tag: 187701
 - 8
 - changing values in registry subkeys Hi All I'm looking to search through all subkeys of a specific registry key for a given value. The code below works fine for echoing out the names of the subkeys..... ---------------------------------------------------------------------------------------------------------------------- const HKEY_LOCAL_MACHINE = &H80000002 strComputer = "." Set StdOut = WScript.StdOut Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" &_ strComputer & "\root\default:StdRegProv") strKeyPath = "SYSTEM\CurrentControlSet\Services" oReg.EnumKey HKEY_LOCAL_MACHINE, strKeyPath, arrSubKeys For Each subkey In arrSubKeys StdOut.WriteLine subkey Next ---------------------------------------------------------------------------------------------------------------------- ...... but how do I check each subkey for a specific value? Tag: Delete row from excel Tag: 187697
 - 9
 - Folder last accessed / modified Hi Guys, doing a bit of network maintenance at the moment and I'd like to archive some folders that havn't been accessed/modified since 2003. I would like to generate a script to search a directory and output the names of all the folders that have not been accessed since 2003 to a txt file. The text document should also contain when the folders were last accessed. The server uses NTFS. Tag: Delete row from excel Tag: 187693
 - 10
 - formatnumber i try to add numbers from text type number data. ABC = formatnumber("12") + formatnumber("50") but the result is 1250, not 62 i change "+" to "*", then it can be multiplied. how can i do additon? Thanks a lot. tony Tag: Delete row from excel Tag: 187683
 - 11
 - Select a Cell Range in Excel using numbers Hi Every One, I'm just trying to write a VBscript to edit an Excel file. Just want t select a range of cells *using column and row numbers*. Here is m sample code : Dim objUser, strExcelPath, objExcel, objSheet, k, objGroup strExcelPath = "C:\UserGroup.xls" Dim objXL Set objExcel = WScript.CreateObject("Excel.Application") objExcel.Workbooks.Add objExcel.ActiveWorkbook.Worksheets(2).Select objExcel.ActiveWindow.SelectedSheets.Delete objExcel.ActiveWorkbook.Worksheets(2).Select objExcel.ActiveWindow.SelectedSheets.Delete Set objSheet = objExcel.ActiveWorkbook.Worksheets(1) objSheet.Cells(1, 1).Value = "User Common Name" objSheet.Cells(2, 1).Value = "sAMAccountName" objSheet.Cells(3, 1).Value = "Display Name" objSheet.Cells(4, 1).Value = "Distinguished Name" objSheet.Cells(5, 1).Value = "Groups" objExcel.ActiveWorkbook.SaveAs strExcelPath objSheet.Range(cells(1,1),cells(2,3)).Select *<-- this doesn't work* objExcel.ActiveWorkbook.Close objExcel.Application.Quit Set objUser = Nothing Set objGroup = Nothing Set objSheet = Nothing Set objExcel = Nothing Can anyone help me, pleaaaase Cheers, The K - The K ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: Delete row from excel Tag: 187682
 - 12
 - Importing Certificates into IE Is there a way to import Certificates into Internet Explorer via VBScript? I thought I found something on the internet that showed how to do this the other night but now I can't seem to find it. I would like to integrate this into my logon script. Thanks Talyn Tag: Delete row from excel Tag: 187677
 - 13
 - Object doesne't support this priority or metode Email 800a01B6 Can someone help me, I am new on this Erik Gjertsen ' UserSpreadsheet .vbs ' Sample VBScript to create User accounts from a spreadsheet ' Author Guy Thomas http://computerperformance.co.uk/ ' Version 4.6 - June 2005 ' ------------------------------------------------------' Option Explicit Dim objRootLDAP, objContainer, objUser, objShell Dim objExcel, objSpread, intRow Dim strUser, strOU, strSheet Dim strCN, strSam, strFirst, strLast, strPWD, strEmail ' -------------------------------------------------------------' ' Important change OU= and strSheet to reflect your domain ' -------------------------------------------------------------' strOU = "OU=test ," ' Note the comma strSheet = "D:\Scripts\NewUser44.xls" ' Bind to Active Directory, Users container. Set objRootLDAP = GetObject("LDAP://rootDSE") Set objContainer = GetObject("LDAP://" & strOU & _ objRootLDAP.Get("defaultNamingContext")) ' Open the Excel spreadsheet Set objExcel = CreateObject("Excel.Application") Set objSpread = objExcel.Workbooks.Open(strSheet) intRow = 3 'Row 1 often contains headings ' Here is the 'DO...Loop' that cycles through the cells ' Note intRow, x must correspond to the column in strSheet Do Until objExcel.Cells(intRow,1).Value = "" strSam = Trim(objExcel.Cells(intRow, 1).Value) strCN = Trim(objExcel.Cells(intRow, 2).Value) strFirst = Trim(objExcel.Cells(intRow, 3).Value) strLast = Trim(objExcel.Cells(intRow, 4).Value) strPWD = Trim(objExcel.Cells(intRow, 5).Value) strEmail = Trim(objExcel.Cells(intRow, 6).Value) ' Build the actual User from data in strSheet. Set objUser = objContainer.Create("User", "cn=" & strCN) objUser.sAMAccountName = strSam objUser.givenName = strFirst objUser.sn = strLast objUser.Email = strEmail...............................Problem objUser.SetInfo ' Separate section to enable account with its password objUser.userAccountControl = 512 objUser.pwdLastSet = 0 objUser.SetPassword strPWD objUser.SetInfo intRow = intRow + 1 Loop objExcel.Quit WScript.Quit ' End of Sample UserSpreadsheet VBScript. Tag: Delete row from excel Tag: 187675
 - 14
 - Why does one logon script work and the other not work I am trying to write a logon script for users logging into Windows 2003 terminal server. I need to determine what usergroups they belong to. I downloaded two scripts and the first one only works for users in the administrator group. The second script works for all users. I'm thinking it is an Active Directory security setting. For my own education, how can I make the first script work for all users. Thanks for your help ' Only works for administrators Set objADSysInfo = CreateObject("ADSystemInfo") strUser = objADSysInfo.UserName Set objUser = GetObject("LDAP://" & strUser) For Each strGroup in objUser.memberOf Set objGroup = GetObject("LDAP://" & strGroup) Wscript.Echo objGroup.CN Next ' works for everybody Set WshShell = WScript.CreateObject("WScript.Shell") strDomain = WshShell.ExpandEnvironmentStrings("%USERDOMAIN%") strUserName = WshShell.ExpandEnvironmentStrings("%USERNAME%") Set objUser = GetObject("WinNT://"& strDomain &"/"& strUserName, user) For Each objGroup In objUser.Groups If strGroupList = "" Then strGroupList = objGroup.Name Else strGroupList = strGroupList & ", " & objGroup.Name End If Next WScript.Echo strGroupList Tag: Delete row from excel Tag: 187672
 - 15
 - Permission Denied and Path Not Found errors I'm stuck in a loop with a remote script: If I use the following line to connect to a remote system from a server, I get a "Permission Denied" error: Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" _ & strComputers(y) & "\root\cimv2") I can launch this script on one of my remote systems to connect to another remote system (rather than launching it from the server), and the entire script runs fine. So, I use the "Locator" version, which connects successfully: Set objSWbemLocator = CreateObject("WbemScripting.sWbemLocator") Set objWMIService = objSWbemLocator.ConnectServer(strComputer, _ "\root\CIMV2", _ "strUser", _ "strPW", _ "MS_409", _ "NTLMDomain:" + strComputer) However, when I use this "Locator" version, the following line in my script fails with a "path not found" error: Set objTargetFolder = objFSO.GetFolder("\\" & strComputer & _ "\c$\" & strTargetFolder) I believe this is because "C$" is not accessible. Is there another way to access the C drive remotely? Thanks, -- Bill Baker PS: In case anyone notices, I had posted this question in the scripting.remote area, but no one seems to be home there. Tag: Delete row from excel Tag: 187668
 - 16
 - Exchange 2003 scripts Does anyone have good site with scripts for Exchange 2003. What I need is the script that will let me select number of user accounts and tell me number of emails in the each mailbox, may be the time email arrived to the mailbox etc.... Thanks a lot. Tag: Delete row from excel Tag: 187667
 - 17
 - List disabled accounts and deletet. Hi all, Has anyone script that will reed all NT4 disabled accounts and then give you choice to delete them.. Thanks a lot. Tag: Delete row from excel Tag: 187666
 - 18
 - 800A0046 error: permission denied in vbscript Hello, I downloaded the "List Web Service Setting Properties" script from Microsoft at: http://www.microsoft.com/technet/scriptcenter/scripts/iis/iis6/web/i6wevb14.mspx. I edit the strComputer variable to indicate the correct hostname. Script errors at the line beginning the For Each loop indicated in the code snip below. Can anyone help me determine what permission I need? (I am a local admin on the server, however, GPO policies removes some local privileges). strComputer = "correcthostname" Set objWMIService = GetObject _ ("winmgmts:{authenticationLevel=pktPrivacy}\\" _ & strComputer & "\root\microsoftiisv2") Set colItems = objWMIService.ExecQuery("Select * from IIsWebServiceSetting") For Each objItem in colItems *********************** Wscript.Echo "Access Execute: " & objItem.AccessExecute Wscript.Echo "Access Flags: " & objItem.AccessFlags Wscript.Echo "Access No Physical Directory: " & _ objItem.AccessNoPhysicalDir Wscript.Echo "Access No Remote Execute: " & _ Thanks in advance, Tag: Delete row from excel Tag: 187664
 - 19
 - File Sharing by VBScripts Is there any way that a VBScript can open a file for appending, without preventing other processes from opening the file for reading? Unfortunately, the OpenTextFile method doesn't seem to provide a parameter for specifying the file sharing mode. Thanks! -- Joseph Morales [To reply directly, remove "deletethispart." from my E-mail address ] Tag: Delete row from excel Tag: 187661
 - 20
 - Inconsistemt Results From ADSI We're using a VBScript as a logon script on a Windows 2003,SP1 server. We want to test Group Memberships and are using the sample code from the Server Help as follows: Const RM_205_G = "cn=rm_205_g" Const RM_212_G = "cn=rm_212_g" Const RM_206_G = "cn=rm_206_g" Set wshNetwork = CreateObject("WScript.Network") wshNetwork.MapNetworkDrive "h:", "\\WS_1\vol1\Users\" & wshNetwork.UserName Set ADSysInfo = CreateObject("ADSystemInfo") Set CurrentUser = GetObject("LDAP://" & ADSysInfo.UserName) strGroups = LCase(Join(CurrentUser.MemberOf)) msgbox(strGroups) If InStr(strGroups, RM_205_G) Then wshNetwork.MapNetworkDrive "j:", "\\10.147.0.2\vol1\shared\rm205g" End If ... and so on. The problem is that the data inserted into strGroups is very inconsistent. For example, with administrator, all applicable groups are displayed in the msgbox command while for almost all other users some group memberships are omitted or no groups are displayed at all. In those cases where group memberships are retrieved properly, the applicable mapping commands complete as expected. We have no other issues with AD. Nothing seems to be broken. Any ideas why we're seeing this? Thanks! Tag: Delete row from excel Tag: 187660
 - 21
 - Rename list of computers in domain Howdy- Is there anyway to script a bulk-rename of computers (it's actually just the first two letters) using a text file and netdom with a vbs? TIA, BM Tag: Delete row from excel Tag: 187659
 - 22
 - Writing to Excel from a script How would you get excel to keep the data being written into the spreadsheet visiable? I have around 400 items and would like the spreadsheet to scroll along with the data. Thanks Tag: Delete row from excel Tag: 187658
 - 23
 - Reconnecting disconnected usb device Hi everyone, I've got a misbehaving USB drive that needs to have its cable unplugged and then replugged in every so often. I want to write a script to check if it is writeable, then if it isn't, virtually disconnect, then reconnect it. Does anyone know if it is possible to disconnect/reconnect a USB device with Vbscript? Any suggestions would be appreciated. -Barry Tag: Delete row from excel Tag: 187657
 - 24
 - -2147463168 errors I keep getting -2147463168 errors when I attempt to run this script. This used to work but when I went back to actually continuing using it these errors keep happening. I saw the microsofty post about this issue but it did not correct my problem. The problem occurs during the GetObject Line. Set oUser = GetObject("WinNT://" & Trim(sComputerName) & "/" &Trim(sOldUser) & ",User") Full code pasted below. Any help would be greatly appreciated. Paul Dim oFSO Dim memberlist Dim cname Dim changefile Dim chngdadmin Dim sComputerName Dim strComputerName Set oWshNet = CreateObject("WScript.Network") Set oFSO = CreateObject("Scripting.FileSystemObject") Set memberlist = oFSO.OpenTextFile("C:\Program Files\DIT Security Center\Administrator Account Change\memberservers.txt", 1, False) Set changefile = oFSO.OpenTextFile("C:\Program Files\DIT Security Center\Administrator Account Change\changefile.txt", 8, True) 'lnchfile.WriteLine "The DIT Security Center Utility to change the Administrator Account and Passwords has been launched" adminResponse = MsgBox("Are you sure that you want to change the Administrator account on the Member Servers?" & vbCrLf & vbCrLf & "If YES, you will be notified upon completion.", vbYesNo, "DIT Security Utility") 'If adminResponse = vbNo Then 'changefile.WriteLine "The task to change the administrtor accounts and passwords has been cancelled." 'lnchfile.WriteLine "The task to change the administrtor accounts and passwords has been cancelled." 'Call CancelMail 'End 'End If WScript.Echo "Opened Change File" changefile.WriteLine "********************************************************" changefile.WriteLine "" changefile.WriteLine Date & vbTab & Time changefile.WriteLine "" Do Until memberlist.AtEndOfStream cname = memberlist.ReadLine WScript.Echo "Pinging: " & cname Pinger (cname) 'MsgBox Pingcnt If Pingcnt > 5 Then changefile.WriteLine "Server Name: " & UCase(cname) changefile.WriteLine UCase(cname) & " is not online" changefile.WriteLine "" Else WScript.Echo cname & " is online" sComputerName = cname changefile.WriteLine "Server Name: " & sComputerName ' obtain current administrator name regardless of name OldUser = GetAdministratorName(sComputerName) WScript.Echo "Old Admin Account " & OldUser changefile.WriteLine "Old Administrator Account: " & sOldUser zz = 0 Do Until zz = 1000 zz = zz + 1 WScript.echo zz Loop ' create new user name, 15 characters long 'It will contains characters from all of the following four categories: 'English upper case characters (A..Z) 'English lower case characters (a..z) 'Base 10 digits (0..9) 'Following non-alphanumeric characters: ()&$%# 'ChangeAdmin (sComputerName) sNewUser = GenRandomName(15) WScript.Echo "New UserName: " & sNewUser sNewPwd = GenRandomName(15) WScript.Echo "New Password: " & sNewPwd 'snewUser = InputBox("What is the new administrator Account") 'MsgBox sNewUser Set oComputer = GetObject("WinNT://" & sComputerName) If Err.Number <> 0 Then MsgBox "Cannot Connect to Server" End If ' Turn off internal error handling On Error Resume Next ' connect to user object Set oUser = GetObject("WinNT://" & Trim(sComputerName) & "/" &Trim(sOldUser) & ",User") If Err.Number <> 0 Then WScript.Echo Err.Number & vbTab & Err.Description Exit Do End If ' rename user zz = 0 Do Until zz = 1000 zz = zz + 1 WScript.Echo "Round 2 " & zz Loop 'MsgBox oComputer 'oNewUser = "" Set oNewUser = oComputer.MoveHere(oUser.AdsPath, sNewUser) 'MsgBox oNewUser & vbCrLf & oUser.AdsPath & vbCrLf & sNewUser If Err.Number <> 0 Then MsgBox Err.Number & vbTab & Err.Description changefile.WriteLine "Failed to rename administrator user " & sOldUser Err.Clear changefile.WriteLine "" Else changefile.WriteLine "Administrator user is renamed to " & sNewUser changefile.WriteLine "" chngdadmin = GetAdministratorName(sComputerName) WScript.Echo sComputerName Wscript.Echo chngdadmin 'strComputer = "MyComputer" Set objuser = GetObject("WinNT://" & sComputerName & "/" & chngdadmin & ", user") 'MsgBox sNewPwd Objuser.SetPassword sNewPwd objuser.SetInfo changefile.WriteLine "New Password: " & sNewPwd changefile.WriteLine "" End If End If 'On Error GoTo 0 Loop 'If Err.Number <> 0 Then ' changefile.writeline Err.Number & vbTab & Err.Description ' Else changefile.WriteLine "" changefile.WriteLine "The admin account change has completed" changefile.WriteLine Date & vbTab & Time changefile.WriteLine "*****************************************************" MsgBox "The Administrator Account update has completed", vbInformation, "DIT Security Utility" changefile.Close 'oFSO.Copyfile "C:\Program Files\DIT Security Center\Administrator Account Change\changefile.csv", "\\file1\d$\wintel\Adminchange.csv" 'End If Function GenRandomName(Ilen) ' Generates a random 15 character string to be used for both the renaming of the administrator account and the new password Randomize 'Do sRS = "" For iPos = 1 To Ilen iChar = Int((69 * Rnd) + 1) sRS = sRS & Mid("AEIUBCDFGHJKLMNPQRSTVWXYZ" _ & "aeioubcdfghjkmnpqrstvwxyz23456789()&!$#%", iChar, 1) Next 'Loop Until REtest("[A-Z]", sRS) And REtest("[a-z]", sRS) _ 'And REtest("\d", sRS) And REtest("[&\$%#]", sRS) GenRandomName = sRS End Function Function GetAdministratorName(sComputerName) ' Connects to the remote member servers and determines the name of the local administrator account based on the SID Dim sUserSID, oWshNetwork, oUserAccount WScript.Echo "Starting to get Administrator Account Name" Set oUserAccounts = GetObject( "winmgmts:{impersonationLevel=impersonate}!//" & sComputerName & "/root/cimv2").ExecQuery( "Select Name, SID from Win32_UserAccount WHERE Domain = '" & sComputerName & "'") 'On Error Resume Next For Each oUserAccount In oUserAccounts If Left(oUserAccount.SID, 9) = "S-1-5-21-" And _ Right(oUserAccount.SID, 4) = "-500" Then GetAdministratorName = oUserAccount.Name Exit For End If Next WScript.Echo "Finished Getting Admin Account NAme" End Function Sub GetsAMAccountName(strCN) Dim objRootDSE, strDNSDomain, objCommand, objConnection Dim strBase, strFilter, strAttributes, strQuery, objRecordSet Dim strDN, strDisplay, strObjectCategory, intIndex, myarray, objuser, strUPN Dim renameResponse ' Determine DNS domain name. Set objRootDSE = GetObject("LDAP://RootDSE") strDNSDomain = objRootDSE.Get("defaultNamingContext") ' Use ADO to search Active Directory. Set objCommand = CreateObject("ADODB.Command") Set objConnection = CreateObject("ADODB.Connection") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" objCommand.ActiveConnection = objConnection strBase = "<LDAP://" & strDNSDomain & ">" strFilter = "(cn=" & strCN & ")" strAttributes = "distinguishedName,objectCategory" strQuery = strBase & ";" & strFilter & ";" & strAttributes & ";subtree" objCommand.CommandText = strQuery objCommand.Properties("Page Size") = 100 objCommand.Properties("Timeout") = 30 objCommand.Properties("Cache Results") = False Set objRecordSet = objCommand.Execute If objRecordSet.EOF Then Wscript.Echo "Object not found with cn=" & strCN Wscript.Quit End If 'strDisplay = "Object(s) found" Do Until objRecordSet.EOF strDN = objRecordSet.Fields("distinguishedName") strDisplay = strDisplay & vbCrLf & strDN & " (" _ & strObjectCategory & ")" objRecordSet.MoveNext Loop myarray = Split(strDisplay, "(", -1) Set objuser = GetObject _ ("LDAP://" & myarray(0)) oldId = objuser.sAMAccountName ' Clean up. objConnection.Close Set objRootDSE = Nothing Set objCommand = Nothing Set objConnection = Nothing Set objRecordSet = Nothing End Sub Sub Pinger(strcomputer) Dim objPing z = 0 Pingcnt = 0 Do Until z = 7 Set objPing = GetObject("winmgmts:{impersonationLevel=impersonate}").ExecQuery("select * from Win32_PingStatus where address = '" & strcomputer & "'") For Each objStatus In objPing If IsNull(objStatus.StatusCode) Or objStatus.StatusCode <> 0 Then Pingcnt = Pingcnt + 1 Else End If Next z = z + 1 'WScript.Echo z Loop If Pingcnt > 5 Then 'rFile.WriteLine strcomputer & " is not Pingable" rescnt = rescnt + 1 End If End Sub Tag: Delete row from excel Tag: 187656
 - 25
 - tracert Bonjour, JE souhaite lancer une commande Tracert depuis un script VB. Existe t il une fonction deja toute faite en VBS (laquelle) ou faut il lancer l'execution d'une commande MSDOS ? Dans ce cas comment faire ? MErci -- Cordialement, Jérôme FOURNET Administrateur Réseaux jerome.fournet@apf.asso.fr Tag: Delete row from excel Tag: 187650

Hi

Is possible to remove a specified row from an excel file using Visual
Basic ActiveX Script in a DTS package? I need to remove row 1 which
contains the title of the columns. Thanks in advance.

Joann

Top

Re:Delete row from excel by Mo

Mo
Mon Feb 20 15:54:38 CST 2006

This is how you'd delete a row using vbscript.

Set objXL = CreateObject("Excel.Application")
set objWB = objXL.Workbooks.Open("c:\temp\book1.xls")
Set objWS = objWB.Worksheets("Sheet1")
objws.Rows("1:1").Delete
objWB.Save
objxl.quit

Top

Re: Delete row from excel by jcma76

jcma76
Tue Feb 21 15:00:27 CST 2006

Thank you for your help. It worked out great! One more question, if I
need to insert the title of the columns instead, is there an insert
command!? Thank you!

jcma76@yahoo.com wrote:
> Hi
>
> Is possible to remove a specified row from an excel file using Visual
> Basic ActiveX Script in a DTS package? I need to remove row 1 which
> contains the title of the columns. Thanks in advance.
>
> Joann

Top