Macro for Host on Demand

bipinpeter · Posted: Thu Aug 04, 2011 6:30 pm

Hi,

I am working in mainframe using Host on Demand. I want to create a macro to take screenshot of mainframe screens and paste in to excel.
Is any able to give some idea to do this.

I tried 'record macro' option and pressed on 'printscreen' command.But i am not able to see that command in macro which have been saved

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

Not sure if this will help (I can't get my HOD up and running right now), but there is a sample code from IBM for talking between HOD and Excel:

publib.boulder.ibm.com/infocenter/hodhelp/v9r0/index.jsp?topic=%2Fcom.ibm.hod9.doc%2Fdoc%2Fmacro%2Fmacro.html

Escapa · Posted: Thu Aug 04, 2011 9:18 pm

Well.. HOD macro has limitations and am doubtfull that you will be able to take screenshot and store\paste somewhere..

However .. You can write VBA or .net script such a that on ever hit of Return key or function key (based on your requirement) it can take screen shot and append\paste in some document. (I remember my testing team done so for capturing test results of online screen testing)

bipinpeter · Posted: Fri Aug 05, 2011 3:18 pm

Hi Sambhaji ,

Is it possible that execute VBA or .net script from HOD enviornment?

Escapa · Posted: Fri Aug 05, 2011 3:39 pm

Not on hod ... you need to execute it on your local machine and capture screenshot on event of keystrokes of functional keys\return key etc...

bipinpeter · Posted: Fri Aug 05, 2011 4:25 pm

Hi Ed Goodman,

I checked the sample code which is given in HOD programing guide.As per manual there should be some sample code present in location <install>\HOD\xx\doc\macro\samples\amnu.But i am not able to find these sample macros in my system.

Is any one able to share these sample macros?

enrico-sorichetti · Posted: Fri Aug 05, 2011 5:33 pm

why not talk to Your support, to find out about them
the sources might be copyrighted, so sharing them might be improper

dick scherrer · Posted: Sat Aug 06, 2011 9:34 am

Hello,

Is there some reason you cannot ask HOD support?