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