Pass Array To Batch File



Parameters that are referred to in a batch file, but which are missing on the command line, appear as empty strings inside the batch file. Windows batch: iterate over a static array - copies specified files - deploy. Functions can work with parameters by simply passing them when a call is made to the function. As seen in the above example, ~1 is used to access the first parameter sent to the. sql" file "mybatch=? So How I can pass that values to the SQL file from the BAT file. i thought of using a varia | The UNIX and Linux Forums. In other words, the substitution is made when the script is read into memory by the command processor, not when the script is later run. Problem 6: Write a function to compute the total number of lines of code, ignoring empty and comment lines, in all python files in the specified directory recursively. But you have a point nonetheless. ps1" -data "data1","data2" outputs items in data array: 1. I use this trick in nearly every batch file I write to determine where the script file itself lives. As they have to perform system related tasks such as date-time changes, copy files/folders and other file system related stuff. However, my approach was to use a Data flow task, along with a derived column and a flat file output to create the batch file dynamically. Notice: this is by no means a complete list of functions. New input parsing for scripts in. Static Array. Then, we have second file, the batch file, that is invoked by > RunBathFile config. This pointer points to the same address pointed by the array marks. This is very important that you should keep your Excel Sheet from which you want to execute the Batch file in "C:\" drive only. Why doesn't passing an array as a parameter work when running from a batch file? Let's say for legacy reasons, I need to run a PowerShell script from a batch file. Because you only have the luxury of passing PS objects if you stay inside Powershell. Using Forums > You cannot pass an array to a batch file. In this post, we will see how to pass 2D array as a function parameter in C++ programming language. bat file from my Access VBA module and pass the arguements at the same time?. Do not restart or CALL the original batch file from within the called file as this may cause an infinite loop or a stack overflow. Trying to do this one at a time is NOT happening. Batch Processing Method 1: Command Line or Batch File can be called from a DOS batch (. Passing Array as an argument in batch script. It's a bit different with a combination, for example, of batch and vbscript. Notice: this is by no means a complete list of functions. Hi, Please let me know how to execute batch file using C#. '----- ' Author: ' Mike Berry ' Published on CATIA V5 Automation blog (v5vb. How do I pass parameters to a program inside a batch file? I wrote a program in C++, and it asks for 2 values. You can call it like: shell. XML to JSON and JSON to XML converter online. Because everything has to go as fast a possible I wan't to do everyting in one connection. How to use Dataset in TensorFlow. I’m not sure how to pass the log() parameters in the JSON vars file. Hi, Please let me know how to execute batch file using C#. If passing a relative path as an argument to a batch which itself changes the current folder will fail if the pass isn't relative to the new folder. Anyone with a little knowledge or experie. bat file run, or are you trying to have it. In the meantime, the easiest way to pass an array is in the parameter file. In this tutorial, you'll learn to pass arrays (both one-dimensional and multidimensional arrays) to a function in C programming with the help of examples. bat), you can create 100 of folder (directory) in double click. Passing Array as an argument in batch script. (batch file system)(includes related articles) by Tony Roberts. Passing a Parameter to a. In this tutorial, I’ll show you the steps to create a batch file to run a Python script using a simple example. R to be treated as your outfile. bat parameters and with a little nosing around, was able to find: How can I load the contents of a text file into a batch file variable?. For example, Slurm job arrays can be useful for applying the same or similar computation to a collection of data sets. to reference the command line arguments in your batch file use %1 %2 and so on. This article show how to run a SAS program in batch mode and send parameters into the program by specifying the parameters when you run SAS from a command line interface. Run a batch file. telnetlib-- builtin Python module. json, and execute the following command: curl -X POST \. But you have a point nonetheless. If you developed a script called stats. You can use double quotes to pass spaces, tabs, commas, and other special characters in a batch file parameter; see Parameter Quoting for details. txt file would be passed as an argument (and define the content of the array). Net and also pass the arguments through front end. Hope you figured it out already. Other Methods to Pass Arrays to an SQL Stored Procedure. First of all - it's a nice article, I really like when people demonstrate that Batch files can be awesome too. Hi Thanks but it dint serve my purpose as i need to invoke the batch file from my java code. Any ideas? The 45 would be the parameter I'm trying to supply to the program that the batch file starts (Access Database). Re: Passing a command line parameter to a batch file You can use the WshShell object within TestComplete to execute a command line to run your batch file, much the same way as you would do from the command prompt in windows. Passing a hash will verify the file after download. txt is specified the file will be saved at that location. Edge "Peru will result in articles, warnings, etc. C - Pointers and Structures C - Pointers and Array of Structures C - Passing structure pointer to function Handling Files C - File Handling - Getting Started C - File Handling - Read and Write Characters C - File Handling - Read and Write Integers C - File Handling - Read and Write multiple data C - File Handling - Randomly Access Files. › [Solved] Passing variable from vbscript to batch file using arguments › set a variable from the keyboard, truncate it › batch file to tranfer a file from dos to unix › input 2 variables from 2 text files › Getting a Batch File to Ignore a Variable › Cant pass variable to timer › [Solved] How Do i load batch variables from a file. Re: Opening Excel 2013 xlsm from Batch and pass argument to it. Looks it went well. com/johnhammond010 Learn to code with a TeamTreehouse Discount: treehouse. Each Control-M job will have different values for the two parameters. Symantec helps consumers and organizations secure and manage their information-driven world. 5\bin\mysql. Passing (too) long parameters to a batch file MSFN is made available via donations, subscriptions and advertising revenue. Update: You Could pass a single string and have CopyFiles. batch uses an additional worker to run the function itself. Scripting is a powerful way to automate your systems. I expect the FOR loop to place the full path and filename of each file into an array called SourceFile[x], with x being a number from 1 to 3. C:>plink -batch devdb [complex-linux-command] In the above example, if the complex-linux-command fails, or asking for an input from the user, or hangs, etc, then your Windows Batch script will not be waiting. NIO solution. Given that powershell encapsulates just about every feature of batch (and then some) the best approach would be to convert everything to powershell. can anyone tell me how to make it run directly from the batchfile only. I need to pass the whole string mLoc. Powershell -executionpolicy remotesigned -file %~dp0\YourScript. Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /homepages/0/d24084915/htdocs/ingteam/zt8p/wq35w6. By using call with the Label parameter, you create a new batch file context and pass control to the statement after the specified label. Batch Script - Functions with Parameters. But while the cat's away, the mice will answer questions about passing command-line arguments to a batch file. The following example illustrates the use of the PATH environment variable within a batch file:. So from my java code itself i need to pass all the 3 arguments to the batch file. There is no maximum limit on the size of an array, nor any. Creating and Processing Lists of File Names To get a list of all files of a certain type on your disk, use the DIR command with it's /s option to recursively search all subdirectories. CMD parse that into two variables after the fact with string manipulation but thats more of an advanced topic and I still haven't gotten all the kinks out short of trimming a known part of the string out using set str=%str:~4% to assuming the first four characters need to be trimmed out. This technique has many uses, one of which is to split a long-running SAS computation into a series of less time-intensive computations. Here's what the command line looks like: test. Batch file variables don’t need a declaration, in fact, the value is directly assigned to a variable using SET command. This article show how to run a SAS program in batch mode and send parameters into the program by specifying the parameters when you run SAS from a command line interface. H There's no way to pass an encrypted key via Windows CMD. Any variable may be used as an array; the declare builtin will explicitly declare an array. exe) with a command line, so you're limited to what the command line can deliver. Hi,I am having problem,I have batch file running continuously that will listen and receive data from the connected clients, for example I have 4 clients connected from the socket,. Ex: while creating file in the folder I will give file name as input from front end. If you want to pass the array by name, make array_internally an alias of it: declare -n array_internally=$1. bat file be? The points are: How to include the parameter, How to include the parameter with. I use this trick in nearly every batch file I write to determine where the script file itself lives. passes an array containing two strings as a parameter to the script myscript. Could anybody kindly help on this. I have created an array in batch script as: set arr[1]=a set arr[2]=b set arr[3]=c Now I want to pass this array as an argument to another batch file as follows: call :processArr. Batch files are small files which can run commands via your computer's built-in. Often, I'll need to do the same thing on 10 or more machines, like delete old log files or database backups older than a certain age. Using a Python recipe? Installing ActivePython is the easiest way to run your project. It's used as an input file for the command-line interpreter CMD to run a set of commands. It is getting market files from remote directory /home/Comcast/sample data to local directory d:\landing. › [Solved] Passing variable from vbscript to batch file using arguments › set a variable from the keyboard, truncate it › batch file to tranfer a file from dos to unix › input 2 variables from 2 text files › Getting a Batch File to Ignore a Variable › Cant pass variable to timer › [Solved] How Do i load batch variables from a file. Create your free Platform account to download our ready-to-use ActivePython or customize Python with any packages you require. Each element of the array needs to be defined with the set command. Notepad++ http Call a function or other Batch file using Batch File Programming - Duration: 7:52. You can pass arrays to user-defined functions, and you can return arrays with the Return command. Steps: 1) First you need to set echo off for hide the parent directory. From Jakash3's Blog, Arrays in Batch describes how to emulate arrays in the command prompt. A batch file (. The idea is to have one main batch file which will in turn call some sub batch files. I would like to know if its possible to pass an array of variables to vbscript from a batch file. bat file, receiving a parameter, which executes that sentence. CMD parse that into two variables after the fact with string manipulation but thats more of an advanced topic and I still haven't gotten all the kinks out short of trimming a known part of the string out using set str=%str:~4% to assuming the first four characters need to be trimmed out. I am running a command remotely that requires a Y to confirm the action. txt into an array using mapfile (each line from the file goes in as an array element, in sequence) and then pass the array to the command. In this tutorial we learn how to pass variables from one batch file to another. After making your selections, don't forget to select the last number in the list so the batch file will exit. I thought this is a simple one but I am unable to understand the root cause of this behaviour for not getting desired output! I am attaching data and worflow package for your reference. In this Java tutorial, we thought to come up with an example code to demonstrate batch file execution using Java ProcessBuilder class. Any ideas? The 45 would be the parameter I'm trying to supply to the program that the batch file starts (Access Database). The file is created but it contains no parameter value in %1% variable, this argues that PRTG does not pass any parameters in. Passing entire array to function : Parameter Passing Scheme : Pass by Reference Pass name of array as function parameter. However you can also pass an entire array to a function like this: Note: The array name itself is the address of first element of that array. Right now, if I run the batch file, when it calls the. But due to the parsing of BATCH this will cause --args to be treated as a R option, test1 to be treated as your infile and printargs. You can call it like: shell. Batch Processing Method 1: Command Line or Batch File can be called from a DOS batch (. In this Java tutorial, we thought to come up with an example code to demonstrate batch file execution using Java ProcessBuilder class. I have a batch file which is rather simple: copy %1 %2 A colleague insists this is faster than using VBA to copy. How to call a Powershell script using batch script and pass an object array. Update: You Could pass a single string and have CopyFiles. exe would do it. I’m not sure how to pass the log() parameters in the JSON vars file. For example, what if you are creating a function to send emails. If your code uses a parallel pool, use the 'Pool' name-value pair argument to create a parallel pool with the number of workers that you specify. A process is program (command given by user) to perform specific Job. I would like to know if its possible to pass an array of variables to vbscript from a batch file. tick // Which measurement to consume var. Using a Python recipe? Installing ActivePython is the easiest way to run your project. push "hello from batch file" the %1 takes the first argument we pass after the file name. Trying to do this one at a time is NOT happening. For instance, if the name of the file is mybatch, running mybatch 7 will write 7 lines to the output file. It is possible to create a set of variables that can act similar to an array (although they are not an actual array object) by using spaces in the SET statement:. So from my java code itself i need to pass all the 3 arguments to the batch file. Job arrays¶ Slurm job arrays provide a convenient way to submit a large number of independent processing jobs. You can use. You should see a command prompt window quickly open, then close (as the first line of the batch file forces), then your two applications should launch! Conclusion. can u please help me. Alternatively pass an absolute pass; or don't change the current folder if not absolutely necessary. I am trying to pass installer properties to a batch file as paramters. sh that counts the words in a file, it's best to pass the file name as an argument so that the same script can be used for all the files that will be processed. Is it possible to have an outlook hyperlink that starts a batch file and supplies an argument? I've been trying this with no luck; the database starts but the parameter is not passed. This is only one of many uses for batch files. exe using the following command powershell -file ". pairs which come out as a 2 dimensional array to the robocopy command line. Use %1 for first argument passed to a batch file Use %2 for 2nd argument Use %3 for 3rd argument. I have a batch file that takes two date parameters. PF_INET is mentioned. I have used the Execute Process Task and pointed it at my batch file but I cant seem to get the parameter value to pass correctly. Join the Family: https://discord. Static Array. A batch file may contain any command the interpreter accepts interactively and use constructs that enable conditional branching and looping within the batch file, such as IF, FOR, and GOTO labels. Now I want to schedule copy command for copying one file on a daily basis from workgroup computer to domain member computer. And get rid of the colon in call processArr. Hello, I'm calling a Batch script from PowerShell with Start-Process, however before Start-Process, I need to match up the variables in both PowerShell and Batch so once I change the path to the file once in PowerShell, it changes in both places (PowerShell and batch at the same time). An interesting difference that Batch arrays have versus other programming languages is that the indexes are not restricted to be numerical values, so they may be any string. Batch File that grabs file names from folder to insert into batch file Ok I'm totally at a loss on how to word this so I'm just going to write it out the best that I can First I have a batch file that I'm writing that will convert mp4 files to mp3 files (I have a lot) for a buddies band using ffmpeg. The parameters can then be accessed from within the function by using the tilde (~) character along with the positional number of the parameter. To pass the parameters, I had to change the order of the commands to open the windows/tabs. I presume that your batch file performs other processes as well but you. The best approach is to transform the array into JSON before passing it to the script in question. Below is the entire Document. now my problem is i don't know how to pass the parameter from java class to the batch file, anybody can help? or hava another idea to do that? thanks in. Simplified Code. bat, that will read the contents of config. If passing a relative path as an argument to a batch which itself changes the current folder will fail if the pass isn't relative to the new folder. sas below is the code. Again, this is particularly useful when manage array elements. It is getting market files from remote directory /home/Comcast/sample data to local directory d:\landing. REXX – Reading a sequential file into a STEM (array) The below REXX program gets a PS file my. exe) with a command line, so you're limited to what the command line can deliver. If your question is how to pass parameters to batch file then call the batch file xyz. Often, I'll need to do the same thing on 10 or more machines, like delete old log files or database backups older than a certain age. The above script will print A, B, C in three lines and we treat obj[0], obj[1] and obj[2] as three individual variables (their memory address locations are not continuous). What if there are more than 1 variables in batch file, i. Currently the batch is called and only directory paramters are passed along. If I am using a RunWait command to launch a batch file from within an AutoIt script, how can I pass a variable to said batch file so that the batch file can utilize said variable like in a %var% format?. Below is a sample batch script which gets current date and time. Lets say, I pass some values to a procedure which has to insert rows in the emp table. To convert your PHP array into JSON, you can use the json_encode function, which will return the JSON representation of the value that you have passed it. , not an array element ) as a parameter to a function, the array gets passed "by reference". Example batch file. In the following tutorial explain you to create more directory using DOS command through batch files (. First of all - it's a nice article, I really like when people demonstrate that Batch files can be awesome too. JSON String; Direct array; Direct Array : This one is simplest method to pass the data's from JavaScript to php. And the rest of it about "becomes complicated" and "determine and then remove " applies to irrespective of how you pass the array, so I don't see what's the point of that. A process is program (command given by user) to perform specific Job. exe command line parser parses your command line & parameters and then starts running the batch file The batch file retrieves the parameters, but when you use them, they get parsed again. How to pass an entire array to a function as an argument? In the above example, we have passed the address of each array element one by one using a for loop in C. Quite a number of programmers learned scripting on a PC running DOS. Then, run the file with a long filename. The Ctrl-G character corresponds to the seventh character of the ASCII character set. bat) is used in DOS and Windows, which is an unformatted text file that consists of a series of commands to be executed by the command line interpreter. You can pass arrays to user-defined functions, and you can return arrays with the Return command. However, my approach was to use a Data flow task, along with a derived column and a flat file output to create the batch file dynamically. lets say the destination [gs folder]. The method I will be using is very simple, but unfortunately it is not fool proof. Hello, I have two systems: the first one is a domain member and other is the workgroup computer. You can use double quotes to pass spaces, tabs, commas, and other special characters in a batch file parameter; see Parameter Quoting for details. In this tutorial we learn how to pass variables from one batch file to another. exe command line parser parses your command line & parameters and then starts running the batch file The batch file retrieves the parameters, but when you use them, they get parsed again. This is useful if you have limited space on a HDD and need to delete files on some folders that populated automatically. It runs as a collection of related, yet separate, basic jobs that may be distributed across multiple hosts and may run concurrently. Or at least we’ll answer one question about passing command-line arguments to a batch file. json, and execute the following command: curl -X POST \. That is ugly and unncessary. For the parameter value use: "value": ["value 1", "value 2"]. then the files that pass validation are translated to GML. The below example allows the array to be constructed by a function without the caller having to worry about memory leaks or stack vs. H There's no way to pass an encrypted key via Windows CMD. Problem 7: Write a program split. Click Apply and OK. how i can pass a file directory (path) as parameter to batch file in windows operating system bash file in unix operating system Stack Exchange Network Stack Exchange network consists of 175 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. However, I would like to point out, that your implementation of the sort isn't really perfect. bat file ECHO %1 %2 (1 and 2 are first and second paramter) Use session variables or server varaibles and pass values to the batch file. What happens if you try to pass two arrays to a function as in this example f(@a, @b)? Perl will flatten and unite the contents of the two arrays, and inside the function you won't be able to tell where does the first end, and where does the second start. To auto-run a batch file as administrator, you need to first create the batch file, and then create a shortcut for it. I have a batch file that is doing some processing of these ISO images but I'm having a really hard time figuring out some behaviors. As seen in the above example, ~1 is used to access the first parameter sent to the. It is possible to create a set of variables that can act similar to an array (although they are not an actual array object) by using spaces in the SET statement:. I would like to know if its possible to pass an array of variables to vbscript from a batch file. then the files that pass validation are translated to GML. Passing two scalars to a function, and accepting them inside the function is easy. I would like to pass the name of the file as a parameter from the Task (SSIS) to this batch file. 0 This website is not affiliated with Stack Overflow. For me it's similar, I can do the VBS but not the DOS. txt What I am looking for is the syntax, in RunBatchFile. I called the batchfile in my c# code but got some issues in passing the parameters. Interactive mode means that you see CATIA and its user interface on the screen. If the statement is not true, that is, the VARIABLE variable does exist, program control skips to the next line of the batch file and continues. Batch File Scripting Techniques. Right now, if I run the batch file, when it calls the. Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /homepages/0/d24084915/htdocs/ingteam/zt8p/wq35w6. To pass the parameters, I had to change the order of the commands to open the windows/tabs. Note: Follow the below command and prepare a text file. However, if I ECHO _result in my second batch file test2. AF_INET where socket. But before we dive into the example, here is the batch file template that you can use to run the Python script:. Extract the filename without the extension : ~n. - I suggest you to manage all array elements in the same way. There are many other WIL functions and also over 25 WIL Extenders available that contain lots of additional functions. So here you can find information on batch scripting techniques and development of Dr. Parameters that are referred to in a batch file, but which are missing on the command line, appear as empty strings inside the batch file. I have created an array in batch script as: set arr[1]=a set arr[2]=b set arr[3]=c Now I want to pass this array as an argument to another batch file as follows: call :processArr. Yeah, I'm not sure that the batch file is properly reading the data. How do i do that? Any help is very much appreciated. A Simple test here (test. println and trying to capture the same here. I would like to pass the name of the file as a parameter from the Task (SSIS) to this batch file. e ( Address of 0th element ) Array values are updated in function. The method I will be using is very simple, but unfortunately it is not fool proof. LON drive and directory c:\TEMP\. I will build the different components like below. Currently the batch is called and only directory paramters are passed along. Note: the above code is perfectly acceptable for expository purposes, but remember that in Python 2 firstn () is equivalent to the built-in xrange () function,. One thing the batch language does not use is strongly typed variables. Each time you SHIFT the %1 arg is dumped and each arg is moved one more down the list. HELP, I need to take a variable from a tabel in SQL Server pass to a Batch file and execute the batch file. Time To Run The Batch File. However, my approach was to use a Data flow task, along with a derived column and a flat file output to create the batch file dynamically. At its most basic, Get-ChildItem can be used simply by providing a path, either through the pipeline, using the -Path parameter, or immediately following the cmdlet name. Powershell: Passing an array to a script at command line To get this working use the -Command Parameter instead of the -File parameter and set the Argument. Post subject: Passing parameters from Control-M to a batch job I have a batch job which needs two parameters and I want to be able to have Control-M jobs pass these parameters to the batch job. But we have the Array in JavaScript. The script is below. However, I would like to point out, that your implementation of the sort isn't really perfect. Before you schedule that you want to simply create a batch file and schedule it run with a Windows Scheduler. The one I prefer for SQL Server 2008+ is to use table-valued parameters. The program have multiple limitations because it is focused on the array management part only. bat ,It will take parameter name called componentName. For example, Slurm job arrays can be useful for applying the same or similar computation to a collection of data sets. Looks it went well. To run it, double click on the batch file. then the files that pass validation are translated to GML. One thing the batch language does not use is strongly typed variables. Passing more than 9 parameters to a batch file On December 21, 2008 December 21, 2008 By Munish Bansal In Others It is of a common practice to write a batch file to execute the commands using some command line utilities like OSQL. I'm running a batch file from excel which in turn runs a load of SQL scripts, the SQL scripts generate csv files that are then refreshed in Excel. txt into an array using mapfile (each line from the file goes in as an array element, in sequence) and then pass the array to the command. I'm just using autoit to pass the OS (ex: Win_7) by writing the OS to a text file and then having the batch file open the text file to read the OS. How to return success/failure from a batch file? How to return success/failure from a batch file? (Read 181253 times) B. heap memory allocations. You can try it as your homework to get familiar with passing references to subroutines. - It is faster and clearer to use a FOR to expand the value of the subscript in an array element instead of a CALL. In the BindModel method we are cheking out whether the Request. \array as parameter. txt What I am looking for is the syntax, in RunBatchFile. My problem, I think, comes when I try to start a batch file. A batch file can be run by simply double clicking in Windows explorer, or by typing the name/path at the command line, optionally passing any parameters needed. EXE it just drops all of the command line arguments and fails to import the file. Name contains the base address i. long short filename LONGFI~1 short file extension. If you pass more than 9 arguments you can use the command SHIFT in your batch file to march through the list. DOS Batch is the Windows equivalent of shell scripting and can be used to perform all sorts of different actions. Scripting is a powerful way to automate your systems. The first time the end of the batch file is encountered (that is, after jumping to the label), control returns to the statement after the call statement. If you wish to use a batch file to create a menu which will allow you to do more, read through tutorials on DOS commands and using batch files. Use %1 for first argument passed to a batch file Use %2 for 2nd argument Use %3 for 3rd argument. R to pass custom arguments to script. There are a number of directives (options) that the user can pass to the batch system. And new code in the executable file that PowerShell Studio and PrimalScript builds parses the input string and associates the parameter values with the correct parameters, so you don’t have to. The following things need to be noted when arrays are implemented in Batch Script. Re: Passing a command line parameter to a batch file You can use the WshShell object within TestComplete to execute a command line to run your batch file, much the same way as you would do from the command prompt in windows. How to Run a Batch File and Wait Until It Finishes with VBA How do I run a batch file and wait until it finishes with VBA? Maybe the batch files are from a legacy project, or maybe they’re a short-hand way to accomplish something without needing a scripting language like Python or Ruby — it doesn’t REALLY matter though. The first argument is the name of a file to use, the second argument is the name of a variable in the dataset, and the third argument is a value of the specified variable indicating the subset of the data that we want to load into memory. Hi, I'm not sure if this is possible with batch files but can a set of variables be passed from one batch file to another. You can use the shift command to access the other arguments. R to pass custom arguments to script. I Have this script that allows arguments: ##### # Batch File: @echo off. long short filename LONGFI~1 short file extension. Also, I recommend explicitly specifying PowerShell's -file parameter to make your intentions very clear; e. For example, following the documentation for BATCH you might right R CMD BATCH --args test1 printargs. If you want to pass the array by name, make array_internally an alias of it: declare -n array_internally=$1. Assuming each line of arguments. bat extension, which can include one or multiple commands that Command Prompt can understand and run in sequence. I dont know how to pass these arguments from my java code to the batch file. Save to Windows directory and call from start/run. If you have a VBScript program which would be better utilized if you can pass one or more parameters at run time, you can easily do so by accepting them as arguments. Could anybody kindly help on this. Because everything has to go as fast a possible I wan't to do everyting in one connection. I have it all working but am running into one issue.