How to copy the screenshot from Hummingbird Host explorer and paste into MS Word ?

Vinoth Kumar

Hi Team,

Good day. I am using Host explorer version 15.0.7 and creating a VBA Macro to take the Mainframe screenshot and paste it in MSWord Document. As I am a newbie to this VBA Macro, sorry if my question is so lame.

I have overall idea to achieve this either by issuing print screen key or copy/paste screen in clipboard and paste in MS Word document. As per the help document, it shows that I can use the equivalent print screen key as "@P@t" and might be include the DLL file ehlapi32.dll or ehllap32.dll.

When I coded my VBA scripts and checked for error, it just stops in the very first line as shown below.

Private Declare Function WD_ConnectPS Lib "ehlapi32.dll" (ByVal hInstance As Long, ByVal ShortName As String) As Integer

If I comment the above line and debug animate it, it is stopping in the following line " HostExplre.ActiveSessions.SendKeys "@P@t" '* Printscreen key "

Could anyone advise how to proceed or provide some insight on this problem?

Appreciate your time.

Regards,

Vinoth

Karen Weir

Thank you for posting. Please refer questions regarding Hummingbird software to https://www.rocketsoftware.com/products/host-connectivity/host-explorer . More information is available here.

Vinoth Kumar

@Karen Weir Thanks for the response. Will certainly do it.