Macro in excel 2010 to feed data in Mainframe CICS online screen

[nimishseraphim]

Hi,

I need help in creating a macro in excel 2010 which would take inputs from excel sheet and dump data in Mainframe online CICS screen.

Requirement:

User will feed values for certain fields in an excel sheet and after hitting a button, all these values should be fed in mainframe CICS screen one by one.

Field Name CUSTOMER# TYPE SEGMENT FROZEN POLICY GBS SITE
Value 12345 B B N 12345 1 G


User will feed manually in excel 2010 "n" number of values for above fields and after clicking a button in excel, these values should be fed one by one in Mainframe online screen which has the field name specified above.

*********************************************************************************

I am completely new to excel macro.If anybody would help me in writing code , It would be great.If anybody is interested to help me please let me know so that I could explain the requirement in detail.My email ID is nimishseraphim@gmail.com

 

[nimishseraphim]

Can somebody look into this question and help me?