Re: Loading Excel Data into PeopleSoft

From: anok4u2 (anok4u2_at_discussions.microsoft.com)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 08:39:05 -0800

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:

>
> <anonymous@discussions.microsoft.com> wrote in message
> news:174601c50ad2$739f5940$a401280a@phx.gbl...
> > To upload the text file I run a batch process in
> > PeopleSoft. First I do a summary billing upload and then
> > I run a batch voucher request. Both of these functions
> > within PeopleSoft are customizations that my company
> > purchased. The batch process uses COBOL to move the text
> > file into PeopleSoft.
> >
> > Internet Explorer is just the web browser we use to get
> > into PeopleSoft. I'm not really sure if it was necessary
> > for me to include that in the original post.
> > >-----Original Message-----
> > >
>
> This means you are indirectly using PeopleSoft to do the inserts. I have no
> experience with PeopleSoft. however, I have worked for a company that made
> finacial software as a Systems analyst. I know that we had to make extensive
> validation before inserting any values. Some of the data was inserted in 1
> table while other data went to 2 tables. Validation is *very* important. You
> should *not* try to insert the data in such a way that you bypass existing
> code.
>
> Having said that, you may be able to call the Cobol code from excel. If this
> is possible, I guess it wouldn't be very difficult to write a small macro
> that exports your data to a file and then call the cobol code.
>
> I think that wat you are asking for is possiible, even easy, provided that
> the Cobol code can be called from an external program other than PeopleSoft.
> Don't limit yourself to VBA. Ask for sample code in any modern language such
> as VB, C#, C or C++.
>
> Best Regards,
> Fredrik
>
>
>

Relevant Pages

  • Re: .XLS, not .CSV from NETX?
    ... This is a post from a guy who wants to move OFF Excel to Open Office. ... OO COBOL (although I admire your courage and attitude... ... Click the icon to open Visual Basic. ... The Visual Basic Editor opens and ...
    (comp.lang.cobol)
  • Re: .CVS to .XLS
    ... 2009 1:16 PM I have solved my problem by having the COBOL program ... create a .CSV file, then calling a program that reads the .CSV file ... and then you want to decimalize .1234 to become 12.34 in Excel. ... Regardless of storage format calculate, ...
    (comp.lang.cobol)
  • Re: .XLS, not .CSV from NETX?
    ... At least it's all COBOL stuff. ... Try setting up an Excel spreadsheet with the attributes you want (line/col ... Excel directly from your program and set the attributes you want, then load ... under program control. ...
    (comp.lang.cobol)
  • =?ISO-8859-1?Q?Re=3A_I_don=B4t_view_the_value_right_after_six_decimal_?= =?ISO-8859-
    ... That still might have the same effect as COBOL decimal arithmetic. ... They are not identical in Excel 2003. ... You might consider setting the option Tools> Options> Calculation> ... Precision As Displayed. ...
    (microsoft.public.excel.misc)
  • Re: Loading Excel Data into PeopleSoft
    ... by doing a copy and paste from Excel into PeopleSoft. ... PeopleSoft in the field where I am copying the data. ... >> With regard to interfacing Excel with COBOL you can ... >With a regular stand alone Cobol compiler, ...
    (microsoft.public.excel.programming)