I have a script that will freeze panes and a few other things like turn auto filter on etc.
What I am needing it to do is what it does now AND apply it to all workbooks in the same file,
loo...
I am trying access a shared network drive through JAVA. If I am logged in to Windows XP, it works fine. I am using Eclipse. When I create jar file and automate the process for the times that m...
I am trying access a shared network drive through JAVA. I am using Eclipse. Pycron for automation. I registered pycron as a service. If I am logged in to Windows XP, it works fine. When I cre...
Can anyone explain or point us to a book, a website or other discussion that might help us understand why most of the TechNet scripts that loop through the collection of adapters on a machine ...
All,
I am running a batch script to install and delete some out of date programs and new programs on computers at the office.
no matter if the machine has the correct software or not, I ...
How to modify the attached code to turn services on / off on another PC in a different domain? The 4 variables I think that need to be used are are servername, servicename, username, password...
Netdom 2.0 for w2k do not allow workstation renaming, is there another version or another way to automate w2k computer renaming in a domain?
First I would like to thank Shift-3 for his code that I am pasting into this question.
Yesterday a question was posted needing a VB script that can take a bunch of excel files and merge the...
I have a client whose previous tech person was using xcopy for their backups. He had a variety of .bat files for each day of the week, and they claim that it performed the backups automatical...
I am usng a VB script to create an Outlook email taking the message body from an open Word Document..
the current code is..
Set oItem = oOutlookApp.CreateItem(olMailItem)
With o...
Hi, I have a VB6 app which intentionally creates several instances of the Word.Application class. These instances are hidden away from users to prevent them from interacting with it. The prob...
Hi Experts!
I am working on a project where a lot of the development is done using .Net. The work is split up in many Visual Studio solutions, each containing many projects.
The solution...
Hi I have currently got a VBscript im using to execute a few kix scripts, I would all so like to copy a few particular files from a network resource and register these files with regserv32.exe...
Attached is a simple script that that lists rasters in database whose name start with "xW" and then uses them in MapAlgebra equations that finds the square of the difference between two raster...
Does anyone know of a good C# (.NET) Automation Library. Basically some pre-written code I can use to automate some tasks similar to a Macro, but with some logic as opposed to dumb commands. ...
Hi all
Using Auto IT i have a list box with x number of rows and an input box. I want to use the input box to filter the data in the list box as the user types data. Is this possible?
An...
Jim thanks so much for your help. I have modified the code that you've given me to accomodate what I am working on, but when I make a selection only from the grouping column, it still does no...
I've a large number of *.txt files, all compressed in zip and rar containers.
The containers reside in a directory structure with 2-3 levels.
I need to recursively extract JUST the *.txt fil...
I've got a database that only exports in tab delimited and comma delimited .txt files. Right now we're going through the awful process of importing these .txt files into excel, changing the re...
how to if a variable is null in windows
I am pretty new to VB Script but have a problem. I am exporting several crystal reports from several data sources, each export to excel will create a file that opens in excel 2003. What I wou...
I am trying to filter an excel form that I created. The form is populated by list boxes from a worksheet within the Excel workbook. When I click on the command button, the form displays, but...
Hi, I have a question regarding the Dictionary Object and unique values. I'm aware of the standard exist function as this site has been very helpful in educating me on the matter.
I have a...
Alright, so I'm in a little bit of a fix here and I need some help.
I just received an excel file my client that ends up being locked. (I'm sure they must have spent atleast 5 months on thi...
I need a script in VB (.VBS) that when run will populate the 1st row and each column going left to right on every worksheet in a single excel file such as this:
ColA ColB ...
