"Mike" wrote in message
...
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

What do you do to upload the text file? Is there a command in PeopleSoft
that you run? Or do you use the SQL Server Query analyzer thru which you run
some command. I'm not sure it's a good idea to access the database directly
from Excel in order to insert data. When you do, you bypass any kind of
validation that PeopleSoft should do.

This is something that only should be done if you have some kind of
PeopleSoft API that you can call from Excel. Such an API, if it exists, may
have to be purchased separately.
http://www.peoplesoftfans.com/psfans...ssages/18.html

How does Internet Explorer come into the picture??

Regards,
Fredrik