Hello,
Looking for a script to search in a particular folder (which has many subfolders) for media file types such as mp3, wmv etc.. and store the result on a text file.
Thank you.
We have been running Word 2000 and have built a number of macros to streamline users access to our document storage location. The macro in 2000 simply changes the file open directory based on ...
I've created the vbscript below to map a network drive for my users. What I need to do is create a script hat maps a drive based on certian drive membership. For example if the user is a mem...
I want to change all of computers local administrator account. There is a VBS about this situation in The Portable Script Center :
strComputer = "atl-ws-01"
Set objUser = GetObject("WinNT:...
Hi,
I am looking to have a simple script which will move files over 24 hours since modified date into a different directory.
The only other thing is that the file name mask will determ...
Basically I have a script that analyses a serious of log files.
I want to check if a log file is in by the system (i.e. if it is still logging/writing to it) before I start searching through ...
Found a lovely bit of code that will combine all of the worksheets in all of the workbooks in a directory onto a single sheet.
However, what I'd really like to do is to create a single wo...
Need create a vbScript to to the following steps:
1) To verify if the following key already exist. If it is, then a message pops up " The key already exist." Otherwires, go to step 2.
\\HK...
Hi Experts,
What is wrong in my code? Why I can't use a variable in the query line? If I put the path directly it works fine.
See my code attached....
Thank You
The final step to my script is to set the proper permissions on the user's home folder. The following VBScript syntax unchecks the box "inherit permissions from parent folder" after copying th...
Hello all,
I am trying to figure out a way to close all open excel workbooks with VB. The code I have selects the first instance of Excel and closes all workbooks within that, but if there is...
I have a series of data in rows as below which started at row 17A
x
1
2
3
4
5
6
7
8
9
10
y
1
2
3
.
.
I WANT TO MAKE IT LOOK LIKE,
x 1 2 3 4 5 6 7 8 9 10
y 1 2 3 4 5 6...
I am trying to attach a file when I send an email. The email sends fine unless I add the attachment line, then it breaks. All of the examples I've seen require a hard path except the line I ...
I am extracting the formula fieds from crystal reports. The following is an example : I need to extract only the string constants from the entire FormulaFields.item(x).Text field and write the...
Hi I am new to experts exchange and dont really have much scripting experience.
I need a script to check the size of a folder and send an email if the folder reaches 12 Gb, i was planning ...
This small script is only used to clean up a installation.
Once the installation is done and the computer restarts, a run once registry entry will execute the "cleanup.vbs" script.
The probl...
On my desktop PC I created a folder called "C:\Temp" which I point all applicable user and system "Environment Varables" (e.g.: TEMP, TMP) to. I want to run a VBScript with my nightly schedule...
Hi, I'm still new to VBA and I have to use VBA to determine of a weekly list, the top 20 unique counterparties failing for trades over 30 days.
I read the Dictionary object is the most ef...
I have these reports that come in and I have to filter them by site and by building, then send a trouble ticket to the appropriate groups. Is there any way that I could have a script read the...
Hey everyone.
I am in need of a vb script that I can run on a computer which is not part of the domain and map a printer and set it as default printer. I will add the path in to the regist...
Looking for a VBscript that will disable a group of user accounts in a W2K3 AD from a list of sAMAccountNames in a .csv file.
-The CSV file will only have 1 column with the first cell title...
I am running an Access Database program that is using Excel for some functions, however, if Excel is open, the program will not work properlly. I need some VB Script that will check to see if...
Hi,
I use the code below to convert CSV files into XLS files, I call this using a batch file.
I have two problems,
1) One of my columns contains 13 digit numbers and in Excel these di...
Hi Experts,
Is it possible to have a script reading a text file with computer names, ping computer name and return the IP address?
I've seen script that compear column in Excel, ping IP ad...
Hi,
I am looking for a WMI query to poll ethernet driver version. I have the following below, but it assumes that the location/name of the driver is known. I will not have all of this info fo...
