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

Vinoth Kumar
Vinoth Kumar Member
edited October 15 in General Questions #1

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

Answers

This discussion has been closed.