• Rename Printers in logon for Windows Server 2003, with VBScript

    Hi peeps!Another question! This has been buggin me for a while. Right, I have a Windows Server 2003 SP2 domain (Not R2) and i have about 90 Windows XP professional SP3 clients. Now I have at least 3 printers that are being shared. The printer share names are: printer2 printer3 printer4 when staff...

    Philcrox160 pointsBadges:
  • Can I find an Excel merged cell size in VBScript?

    I have a set of Excel spreadsheets which all have similar properties and I'm trying to automate a set of processes on them. I'm a compelte VB beginner, but it's going ok - I've just hit a stumbling block with the internet isn't being very helpful with. Once I have found a certain cell, is it...

    Bengreen15 pointsBadges:
  • How to connect to quick 3270 secure screen through VBA macro?

    Hi, I use the following code to connect to quick 3270 macro and it also connect to the screen. But when I run the macro for the first time it works, but does not work when I run the same macro for second time. If I restart the mainframe then the macro runs. Below is the code. Sub getdata() Set...

    Anirudha0075 pointsBadges:
  • VB Script to Create a Scheduled Task on a Remote Machine Using Alternate Credentials

    This is a small VB script I created to remotely schedule a task on another machine, using a different user account from the one logged in the local computer. It was needed because PsExec (a sysinternals' tool we use a lot) didn't always work well in some situations where we needed to execute remote...

    carlosdl70,200 pointsBadges:
  • How can I use mscal.ocx on a Windows 7 64-bit machine?

    Hi there, I have some VBA code that works in Excel 2003. It references the calendar in mscal.ocx. Typically, when I've moved it to a new machine (XP, 32-bit), I've had to copy mscal.ocx there and run regsvr32 mscal.ocx and then everything works. But on a new, 64-bit windows 7 machine, with Excel...

    Dbecker20 pointsBadges:
  • Getting error

    Hi, I wrote a code in VB Script to query on database and result gets write in file, but there is one problem with on column in query, if I remove that column from query then code working very fine and runs but with that column it’s giving error “invalid procedure call or argument” That column...

    Prakashnd25 pointsBadges:
  • Running a VBScript from a batch file

    Hi, I have a VB script that I want ran from a batch file. How do I go about this? See the VBscript below:Dim oFS : Set oFS = CreateObject( "Scripting.FileSystemObject" ) Dim sSrcDir : sSrcDir = "//serverNameFBSurvey" ' Source directory (remote server) Dim sDstDir : sDstDir = "c:SampleDir" & ""...

    Waizkode5 pointsBadges:
  • Reading a value from HKLM registry and writing it HKLM registry

    I require a VBScript which will read a value from HKLM and then after reading that value That VBScript should write that value to HKLM. Any help is much appreciated

    raf123410 pointsBadges:
  • VBscript to send email on service failure

    VBscript to send email on service failure

    vzvzxvcx160 pointsBadges:
  • Select Statement & Where Clause ….

    On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called 'BUSINESS_UNIT'. On the same page i have created a Combo Box...

    JKJK45 pointsBadges:
  • Instring function using vbscript

    how to extract the comma till the last and display only the last value suppose if i insert 100000 rows it should show 100000 not like from 1,2,3, till 100000 it should extract till last comma please help me

    Muniraja5 pointsBadges:
  • Automatically insert Date and Time

    Hey there, stupid question but I am having a complete brain fart.  One of my Win7 users wants to create a keyboard shortcut to automatically insert the date and time within Office 2007 programs.  I know there is a easier way to do this than creating a vb script, can anyone refress me on the...

    RamseyB2,115 pointsBadges:
  • Extract Data from SAP using VBScript

    Hi,   I am trying to extract data out of SAP using VBScript. I remember this worked earlier, but ever since we upgraded to VB7, I am getting an error. Can you please look into this?   code: Dim R3, MyFunc, App, objFileSystemObject, filOutput, objmessage As Object Dim nTotalRecords As Long '...

    Torontog15 pointsBadges:
  • VBScript and Key down syntax

    I am trying to run this program below. The portion that is commented out (the if statement) is not working. Obviously I've got the wrong syntax or it's not possible. What I'm trying to do is to click F10 every 12 seconds until I hit the escape key, or until it has gone through it the number of...

    PatMT5 pointsBadges:
  • Escaping special characters in run with administrator privileges script

    Hello, reviving an old one on this forum: http://itknowledgeexchange.techtarget.com/vbscript-systems-administrator/special-characters-in-vbscript-strings/ I used this script: Here is a VB Script Vall Script that will get around the Password Prompt when "RunAs" is called... 'Start...

    Devnullius5 pointsBadges:
  • Remove character from number VBscript

    how do i remove from 1.5.600 the .600 part? i just need 1.5 I tried left but it seems only works with strings

    Ssergio2545 pointsBadges:
  • Log file copy time

    Is it possible to log how long it takes for a file to copy from one location to another? I am using Windows and wanted to output to a text file how long a file transfer took. Can anyone help with this process?

    ConFlicker210 pointsBadges:
  • VBS to Remotely Make a copy of a File on Multiple Systems

    Hello, I'm trying to edit a vbs script that I found online to help me remotely connect to a few servers (using a servers.txt file) and make a copy of a specific file called test.txt (it’s the same file name and path on all servers but with different configuration for each server) and add the date...

    Blackbird21115 pointsBadges:
  • VB Script to monitor files on Windows machines from a Zenoss server

    This is a script I created last year to monitor some files from a Zenoss server. These files are created by an application that receives CDRs from an Asterisk server in another country, and sometimes these files have stopped getting updated even though no network errors seem to exist, so, the...

    carlosdl70,200 pointsBadges:
  • VB Script to delete old files fom the local and/or remote computer(s)

    We have many applications running on many different servers, which log their operations to text files. We learned how problematic this could be when one of our servers crashed because the hard disk was completely full.  Someone was supposed to be monitoring disk usage on this server, but that...

    carlosdl70,200 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following