Avatar of drezner7
drezner7

asked on 

Capturing Input from a Input Box

I would like to collect input from a user and place the value in the name of the output file. Here is the input box code:

i = inputBox("Please enter UID Number?") = 5467

I want to take the value of that question and add it to the name of the outputfile... For example:

Const sXML = "C:\XML_Testing_Room\GrabbingI_Input_5467_.xml"
VB Script

Avatar of undefined
Last Comment
drezner7
Avatar of Mike Tomlinson
Mike Tomlinson
Flag of United States of America image

That would be:

    i = inputBox("Please enter UID Number?")
    sXML = "C:\XML_Testing_Room\GrabbingI_Input_" & i & "_.xml"
Avatar of drezner7
drezner7

ASKER

Here is what I added based on your recommendation and I am getting an ERROR:

"C:\XML_Testing_Room\FINAL_"& i &"_55998_-_001.xml"

Error: Expected literal constand
Code:800A0415
ASKER CERTIFIED SOLUTION
Avatar of Mike Tomlinson
Mike Tomlinson
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of drezner7
drezner7

ASKER

You are absolutley correct, I removed the Const and work like a charm... That is so awesome! I have another question on the Input Box do I place it here or create a new question?
Avatar of drezner7
drezner7

ASKER

Fantastic ! Than you
VB Script
VB Script

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

39K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo