Loading Excel Data into PeopleSoft

[Mike]

Thanks in advance for any help.

I work in a group responsible for entering invoices into
PeopleSoft. For some invoices we have 20 distribution
lines we need to input from an Excel spreadsheet.
Currently we can save the Excel spreadsheet as a text
file and upload it into PeopleSoft.

What I would like to do is be able to copy the data
straight from Excel into PeopleSoft without saving as a
text file and doing an upload. Is there a way to control
Internet Explorer with an Excel macro that would load the
data straight into PeopleSoft? Let me know if this is in
any way possible. If not possible with VBA would it be
possible with another programming language?

I am using Excel 2000. Thanks again for any help.

Mike

 

[Mike]

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

 

[Fredrik Wahlgren]

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

This makes perfect sense to me. The question is wheteher PS supoorts the
necessary code to do so. I have no idea whether PS has a COM interface that
would make this possible.

/Fredrik.