Re: Loading Excel Data into PeopleSoft

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 13:05:17 -0800

Thanks in Advance for any help

I got a little off track. I wanted to do this insert just
by doing a copy and paste from Excel into PeopleSoft. I
have tried a real simple version. I just hit CTRL + C in
Excel over the cell I want to copy, then I hit CTRL + V in
PeopleSoft in the field where I am copying the data. This
doesn't bypass any kind of PeopleSoft data validation
because before I save the voucher PeopleSoft checks the
data. This would not involve running the batch process.
I just need some way for Excel to tell PeopleSoft to move
to the next field in PeopleSoft before copying. Then I
could write a macro to copy a series of excell cells into
PeopleSoft. Does this make sense? Sorry for all the
questioning but if I could find some way to make this work
it would increase efficiency greatly.

Thanks again,
Mike
>-----Original Message-----
>
>"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
>
>
>.
>

Relevant Pages

  • Re: Loading Excel Data into PeopleSoft
    ... With regard to interfacing Excel with COBOL you can certainly do this. ... >> within PeopleSoft are customizations that my company ... you may be able to call the Cobol code from excel. ...
    (microsoft.public.excel.programming)
  • Re: Loading Excel Data into PeopleSoft
    ... > With regard to interfacing Excel with COBOL you can certainly do this. ... > have used Micro Focus Net Express (COBOL Compiler) with Excel. ... Best Regards, ...
    (microsoft.public.excel.programming)
  • 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: Chairman of National Assembly Ranariddh has some words for the US (mp3)
    ... I am glad to hear that you have started moving the IT to Cambodia. ... environment that allows application written in Cobol, C, C++, Java. ... It is a little sad that the PeopleSoft was sold to the Oracle. ...
    (soc.culture.cambodia)
  • 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)