I have a PC with Windows 10, running Micro Focus Visual COBOL for Visual Studio 2010, and running Excel 2010.
I want extract data from Excel workbooks and write it to an Ascii file. I've got a few questions.
Program would read through a folder full of Excel workbooks, like
. . . etc.
Each workbook has ten sheets, two of which contain five items that I want to extract.
CEO sheet, which contains
CEO's name in cell B6
CEO's salary in cell B7
Company sheet, which contains
Number of staff in cell C22
City in cell C23
State in cell C24
QUESTIONS. Can this be done with my existing Micro Focus setup?
If not, what other Micro Focus software would I need? How much would it cost?
Where can I find sample Micro Focus COBOL code that performs a similar task as that described above?