VbScript

How to do something in an VBS script for all worksheets of an Exce
hi something like this might work... Sub claudia() For i = 1 To Worksheets.Count Worksheets(i).Range("A1").Interior.ColorIndex = 6 'above is for test only Next i End Sub regards FSt1 "Claudia d'Amato" wrote: I would like to do something in a *.vbs script and all the operations should be app... 26 Jun 2008 18:45

How to do something in an VBS script for all worksheets of an Excel file?
I would like to do something in a *.vbs script and all the operations should be applied on each worksheet within an Excel file. How do I do this? It must be something like: for i in (1 .. lastworksheetnumber) do ...operations end Claudia ... 25 Jun 2008 09:51

vbscript error 70 - permission denied
I am new to VBScripting but have done some development in VBA. I have a procedure that I have written to run on Windows-XP systems connected to Windows-2000 server. Whole point of script is to do some intelligent file copying with msgboxes to user to confirm intentions, file sizes, dates, times, etc. All works ... 24 Jun 2008 15:25

VBS reading all groups from OU and there members
Hello, Iam a vbs beginner and I want to write all distribution groups and there members from one ou in a textfile. I want to write each group and there associated members in one row, separated with semikolon. The next group with there members in an second row, and so on. But in my script, the groups and each ... 24 Jun 2008 18:31

800A0007 Out of memory retrieving AD object
Hi, I have some users in AD that are in 150+ Domain groups. I also have a login script that uses: -- dim usr,ad, arrMemberOf set ad = createObject ("ADSystemInfo") set usr = getObject ("LDAP://" & ad.username) set arrMemberOf = usr.Groups .... --- On the getObject line, the user is getting "Error: Ou... 24 Jun 2008 14:23

DirectX Version
Is there a way to find out the version of DirectX on a system from VBScript? Currently, we determine the version of DirectX via a VBScript by looking at the registry entry of HKLM\Software\Microsoft\DirectX\Version This worked OK with Windows XP and Windows Server 2003, however for Windows Vista and for Ser... 29 Jun 2008 21:22

File search
i wrote this vbscript to search office files in the PC hard drive. but it returns more than 37xxx files result. it only has 2 office files anything i missed? file attributes? i find the 1st variable (QWord) sum up itself many times. thanks for your help. tony **************************************... 24 Jun 2008 05:08

Run setup.exe from netshare
Hello I am having a tough time figuring this one out. I need to run the setup.ese for Office 2007 from a network share and then apply updates via a msp file. I have the following scirpt below and it will not execute under logon startup. 'InstallStartupScriptBegin on error resume next set wshShell=WScript.Crea... 26 Jun 2008 20:48

VBS Script to Run Macro in Access 2003
I want to nightly run a VBS Script in Scheduled tasks to open an Access 2003 database and execute a macro. The problem is that the database opens to a switchboard screen. I need to open this database with a VBS script that mimicks opening the database with {shift} open. My code: dim accessApp set accessApp ... 23 Jun 2008 14:48

<SCRIPT LANGUAGE="VBScript"> and <%%>
Which are the differences between "<SCRIPT LANGUAGE='VBScript'>" and "< %%>"?? thanks! :) ... 23 Jun 2008 14:48