RE: Calling Excel & Access from inside a CL.

Mike,
That's what I needed.
Thanks a lot,

William Moore
California Fine Wire
805-489-5144

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Naughton
Sent: Monday, March 15, 2010 10:59 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Calling Excel & Access from inside a CL.

Something like that WILL work - we do it all the time, although sometimes it takes a little experimentation to get it working just right. For example, we open PDFs using Acrobat Reader, and the challenge there is that each new version of Reader gets installed in a new directory, so we actually had to write a VB program to look around for it before opening it.

But the CL piece on the iSeries was simple.You don't even always need to call a BAT file -- sometimes you can just call the program you want directly (as I remember, the main issue is parameter length on PCCMD).

hth,

Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:

Something like this might work:

PGM
STRPCO
MONMSG MSGID(CPF0000)

STRPCCMD PCCMD('call +
c:\open_excels.bat') +
PAUSE(*NO)

ENDPGM


Where c:\open_excels.bat is a DOS batch file that opens the Excel

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-676-3144
Internal: x 444
mnaughton@xxxxxxxxxxxx
****************************************
NOTICE: This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that any use is
strictly prohibited. If you have received this e-mail in error, please notify us immediately by replying to it and then delete it from your computer.