Kondro Posted March 7, 2011 Posted March 7, 2011 Hi, I'm writeing a script to automate the install of a program. It requires creating several ODBC's. I had the whole thing automated but then my boss told me he does not want the user id and password part automated dureing the ODBC creation, so now i have it scripted to stop on those screens and wait for user input. the thing is that I have to create many ODBC's with the same user id and password during this particular instalation. im wondering if there is a way to script a msgbox for the user to input the credentials once and then send send them as a variable when needed inside the script for the rest of the session.
water Posted March 7, 2011 Posted March 7, 2011 (edited) Sure. Use InputBox to let the user enter the credentials, save the input in variables and use them wherever needed. Edited March 7, 2011 by water My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Kondro Posted March 8, 2011 Author Posted March 8, 2011 Sure. Use InputBox to let the user enter the credentials, save the input in variables and use them wherever needed.Thanks for the tip! That works perfect, dont mind me Im new, LOL.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now