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