Re: Loading Excel Data into PeopleSoft

From: Fredrik Wahlgren (fredrik.p.wahlgren_at_mailbox.swipnet.se)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 18:08:31 +0100

"anok4u2" <anok4u2@discussions.microsoft.com> wrote in message
news:C65CBDBE-0784-4E9F-9DBB-194504FA43B2@microsoft.com...
>
> With regard to interfacing Excel with COBOL you can certainly do this. I
> have used Micro Focus Net Express (COBOL Compiler) with Excel.
>
> With Net Express you can expose COBOL as a COM Object that can be called
> from VBA or you can use COM Automation to control Excel using COBOL as a
> client app. There is a sample with Net Express that shows using COBOL with
> Word and Excel apps.
>
> A while ago I even wrote a COBOL Smarttag in COBOL so that you can
integrate
> COBOL via the SmartTag interface into Excel.
>
> Regards
> David.
>
>
> "Fredrik Wahlgren" wrote:
>

A Cobol SmartTag? Wow!!! I'm impressed!!!! I'm currently learning how to
make Automation add-ins in C++ that can take things like a range as an
argument. It would be interesting to get an idea how Cobol is used. I
remember reading that someone has made a .NET Cobol compiler. Is that what
you used?

With a regular stand alone Cobol compiler, yes. But is that the way
PeopleSoft works? I think it's possible that PeopleSoft is a Cobol compiler
or interpreter by itself. I imagine you have to use special PS compiler and
that it will produce something else than a regular exe or dll, instead it
may produce some kind of digital "soup" that can only be called from PS.

Best Regards,
Fredrik