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-----

"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...nterface/messa
ges/18.html

How does Internet Explorer come into the picture??

Regards,
Fredrik


.