Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to Get around Hard Coding the Host Session ID in vbScript or VBA code
Thanks to a brilliant AS400 developer I was able to resolve my problem with how to get around Hard Coding the Host Session ID in vbScript or VBA code... The PCCOMM code below solved my problem: 'This section is test to avoid identifying the SetConnectionName ("D") Dim SessObj As Object Dim... -
Need Advise from Anyone Converting AS400 Macro to HAScript and HAScript Compatibility with Excel VBA
I recently developed Automation between the AS400 and Excel VBA scripts, which calls several AS400 Macros, which were developed in vbScript. Now I have learned that a new Windows PC will be install, running a Windows 10 emulator, which utilizes HAScript language, which is very different from... -
How to Get around Hard Coding the Host Session ID in vbScript or VBA code
I have novice knowledge working with PCOMM on the AS400. I have written 15 VBA scripts in Excel which calls AS400 Macros. To get the programs to work the AS400 has to be at the Login Screen and the Active Host Session MUST be set at "D". It is the Host Session that is giving me the blues. As... -
AS400 CPYTOIMPF forces me to enter the latest Job Number
Hello All: HELP!!! I have developed a very slick VBA script in Excel which automates copying AS400 spool files to a Shared Folder in Windows using the CPYTOIMPF function. The CPYTOIMPF required several key values, which have all be captured in an AS400 Macro. I can manipulate the key values...
