excel macro for mainframe



Post anything related to mainframes (IBM & UNISYS) if not fit in any of the above categories

excel macro for mainframe

Postby mfgeta » Fri Oct 07, 2011 9:06 pm

hi all,

i am not sure whether this is the right place to post this question. If not please transfer this post to the right topic.

please provide me the guides and links to write excel macro for mainframe.

In our shop, we don't have facility for moving data' s to excel and vice verse.

i m quiet interested to know how it works?. i m googled about this topic, not able to find good result.

please help me !!!!!!!

Regards,
Geta.
mfgeta
 
Posts: 12
Joined: Thu Oct 28, 2010 12:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: excel macro for mainframe

Postby enrico-sorichetti » Fri Oct 07, 2011 9:25 pm

clear as mud!
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: excel macro for mainframe

Postby Robert Sample » Fri Oct 07, 2011 10:43 pm

please provide me the guides and links to write excel macro for mainframe.
Since Excel does not run on a mainframe, just where is your macro going to execute and what do you think it will do, especially since mainframe data is almost always EBCDIC and PC data is almost always ASCII? What problem are you attempting to solve? What have you tried so far?
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: excel macro for mainframe

Postby dick scherrer » Fri Oct 07, 2011 10:56 pm

Hello,

If you create a tab-delimited (x'05') file on the mainframe and ftp this to a win-based environment, it will be directly loadable (import) into Excel.

Not sure what/why you mentoin a "macro" but we send dozens of these a day with no problems. . .

It will be better to "pull" the data to the pc rather than trying to "push" from the mainframe.

If you need more info, post a more complete definition of where you are stuck.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to All other Mainframe Topics

 


  • Related topics
    Replies
    Views
    Last post