I would like to pass my username and password as a global variable being read in from an Excel spreadsheet so it is not hard-coded in programs.
Can someone tell me how to do this? When hardcoding the variable I use this:
%Let USR = MYNAME;
%Let ORAPW = 'MYNAME#7';
How can I code this so I can read "MYNAME" and "MYNAME#7" from an input file and assign it to the global variable?