• 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...

    carlosdl69,065 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:
  • 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:
  • 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...

    carlosdl69,065 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...

    carlosdl69,065 pointsBadges:
  • vb script to fetch data frm sql into a sheet

    can any one post the vb script to fetch the data frm sql database into a sheet..

    Mademoiselle5 pointsBadges:
  • Vb Script to get the selected(focussed) file names in a windows folder.

    I am trying to get the file names of all the files that has been selected in a folder into an array. Please help

    Sidaga5 pointsBadges:
  • IT Scripts compilation

    This is just a small compilation of questions in which a script was provided as part of the answer. Having them under the IT Scripts tag could help others find them when needed. A small Windows' bat script to dinamically construct a SQL Talk backup script according to the current system date: Embed...

    thongtarget21485 pointsBadges:
  • Delete contents of a folder tree with a kill statement

    Would anyone know of a code, or be able to point me to one, that will delete all files and folders under a given location.  I am looking to schedule the empting of temp folders and would like it to be all inclusive.  If a kill statement is needed also to force delete folders and there content...

    ConFlicker210 pointsBadges:
  • Visual Basic script to get Sysinfo

    Hello I am having problems with a VB Script this is what I want to achieve: 1) Check a machine if is active on the network 2) Find the current logged in user 3) Gather the Service Pack Version 4) Display all information into Excel 5) Highlight in redf which machines are online or offline 6)...

    Oh2abq5 pointsBadges:
  • How to remove spaces from text lines in Visual Basic script

    I have a script that reads a text file and replaces a character string with a new string. The problem is that the data following the new string has spaces that are causing a problem. For example, here is how my data looks prior to running the script Joe Manager Bob Eric Manager Freddy What I am...

    Ilneval5 pointsBadges:
  • How to create a progress screen for use with a VB Script Logon script?

    Hi I have recently created a VB Script to replace the existing Kix logon script. The VB Script Disconnects the network drives and then maps the drives depending on the users security group membership via active directory. The Printers are then mapped and the default set depending on the user group....

    Sharlene55 pointsBadges:
  • Help running a CmdEXEC from the SQL Server

    I am trying to run a CmdEXEC from the SQL Server- script c:userspublicdocuments The process could not be created for step 1 of job 0xAA781DCB64C4D84392B6730923A77C3D (reason: The system cannot find the file specified). The step failed any help?

    Tocken10 pointsBadges:
  • Visual Basic scripting

    how can i run batch files using vb scripting

    W125 pointsBadges:
  • DSO file wrong pagecount

    Hi, (1st post so be gentle :) ) I am using dsofile.dll to get pagecount from word documents, all i need at this point is pagecount and only word documents at this time. for some documents the pagecount returns as 0 (or invalid in general maybe?) and therefore i'm in need of a solution or a...

    Legion5 pointsBadges:
  • Need VBScript to locate and export ACL of a Exchange Public folder

    Hi, I'm looking for a VBScript that will search and display complete path of an exchange Public Folder (either using Outlook or other tools) and then export ACL (all members with their permissions". For first part, since Outlook search is very slow, it would be nice if the script can do a better...

    Fullyfandoo5 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