how to open mainframe session in VBA

[laks143]

I want to open mainframe session through VBA.Can any one tell me how to do this.
PCSWS.EXE is placed on Desktop.


Thanks In Advance !!!
Lakshmi.

 

[markdmac]

Set WSHSHell = CreateObject("Wscript.Shell")
pathToDesktop = WSHShell.SpecialFolders("Desktop")
WSHShell.Run (pathToDesktop & "PCSWS.EXE")

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[laks143]

Hi Mark ,

Set WSHShell = CreateObject("Wscript.Shell")
pathToDesktop = WSHShell.SpecialFolders("C:\Documents and Settings\1055214\Desktop")
WSHShell.Run (pathToDesktop & "PCSWS.exe")


the code that you gave is working fine
I have given the ip address in the link parameters and i have saved PCSWS.EXE as mainframe.After executing this code it is creating new session and it is asking link parameters . i dont wat this to be happened.

 

[laks143]

Hi Mark ,

Set WSHShell = CreateObject("Wscript.Shell")
pathToDesktop = WSHShell.SpecialFolders("C:\Documents and Settings\1055214\Desktop")
WSHShell.Run (pathToDesktop & "PCSWS.exe")


the code that you gave is working fine
I have given the ip address in the link parameters and i have saved PCSWS.EXE as mainframe.After executing this code it is creating new session and it is asking link parameters . i dont want this to be happened.

 

[markdmac]

What the heck did yo do to the desktop path? The code I provided FINDS the desktop dynamically.

What command can you execute from a command prompt to launch the program the way you want? That is what you need to code.

Try executing PCSWS /? to see what the parameters are for it.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.