itsmevic
asked on
VBScript: Form Input
Hello Experts!
Quick question. I have a script that I'm running that basically goes out and populates the username to each netbios name in a spreadsheet. When you execute the script now you are prompted with separate input fields.
For example, when you click the script to initiate, it prompts you to enter a path to the file, you then click go and it grabs that spreadsheet and opens it.
Next, it then prompts you which line you would like to start processing data on, and the person would then just simply enter the row they would want the data to start processing on.
My quesiton(s) is basically this; rather than being prompted separately, is it possible to have it prompt both input boxes at the same time and is it possible to add a "browse" function to the "browse file" field?
Thanks for your help.
Capture.JPG
Quick question. I have a script that I'm running that basically goes out and populates the username to each netbios name in a spreadsheet. When you execute the script now you are prompted with separate input fields.
For example, when you click the script to initiate, it prompts you to enter a path to the file, you then click go and it grabs that spreadsheet and opens it.
Next, it then prompts you which line you would like to start processing data on, and the person would then just simply enter the row they would want the data to start processing on.
My quesiton(s) is basically this; rather than being prompted separately, is it possible to have it prompt both input boxes at the same time and is it possible to add a "browse" function to the "browse file" field?
Thanks for your help.
Capture.JPG
ASKER
Hi Bill,
It's a standard .vbs script that is ran outside of excel. Once you specifiy the location as where the Excel file is, and which row you'd like to begin processing on, it then opens that Excel file and begins to do it's thing.
It's a standard .vbs script that is ran outside of excel. Once you specifiy the location as where the Excel file is, and which row you'd like to begin processing on, it then opens that Excel file and begins to do it's thing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
~bp