Find code from mainframe system to get values

[Alpacino]

Hi,

My work uses a mainframe to for all it's figures which is on the computer along with normal Microsoft programmes. What I would like to do is create a macro that will get values from mainframe programme and paste them into excel. I can do this normally but when I record a macro all it has in the code is the paste bit.

Is there a way of developing this??

 

[Kenneth Hobson]

There are many questions to be answered before a solution can be attempted.
1. What type of mainframe>
2. What does figures mean, graphic images or flat file text data?
3. How do you get "figures" from mainframe to pc?
4. Is pasting what you really want?

If I was getting a flat file from TSO/MVS, I would use FTP in a BAT file to import the file. I would then get the data from the text file and do what I needed.

 

[Alpacino]

Hi
I like to paste values from mainframe it's a database system for sales etc

I can crtl C to copy text from mainframe and
Crtl V to paste into excel file.