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

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


.

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


This means you are indirectly using PeopleSoft to do the inserts. I have no
experience with PeopleSoft. however, I have worked for a company that made
finacial software as a Systems analyst. I know that we had to make extensive
validation before inserting any values. Some of the data was inserted in 1
table while other data went to 2 tables. Validation is *very* important. You
should *not* try to insert the data in such a way that you bypass existing
code.

Having said that, you may be able to call the Cobol code from excel. If this
is possible, I guess it wouldn't be very difficult to write a small macro
that exports your data to a file and then call the cobol code.

I think that wat you are asking for is possiible, even easy, provided that
the Cobol code can be called from an external program other than PeopleSoft.
Don't limit yourself to VBA. Ask for sample code in any modern language such
as VB, C#, C or C++.

Best Regards,
Fredrik

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:


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


This means you are indirectly using PeopleSoft to do the inserts. I have no
experience with PeopleSoft. however, I have worked for a company that made
finacial software as a Systems analyst. I know that we had to make extensive
validation before inserting any values. Some of the data was inserted in 1
table while other data went to 2 tables. Validation is *very* important. You
should *not* try to insert the data in such a way that you bypass existing
code.

Having said that, you may be able to call the Cobol code from excel. If this
is possible, I guess it wouldn't be very difficult to write a small macro
that exports your data to a file and then call the cobol code.

I think that wat you are asking for is possiible, even easy, provided that
the Cobol code can be called from an external program other than PeopleSoft.
Don't limit yourself to VBA. Ask for sample code in any modern language such
as VB, C#, C or C++.

Best Regards,
Fredrik

"anok4u2" wrote in message
...

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

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

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


.

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