Re: Output from PF to Excel XLS file in IFS

[MWalter@xxxxxxxxxxxxxxx]

He's mentioned a bunch of times that the use of a PC is VERBOTEN!!.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \



                                                                                
                                                                      
                    "Booth Martin"                                              
                                                                      
                    <Booth@MartinVT.com>         To:     
<midrange-l@midrange.com>                                                       
             
                    Sent by:                     cc:                            
                                                                      
                    midrange-l-bounces@mi        Subject:     Re: Output from 
PF to Excel XLS file in IFS                                             
                    drange.com                                                  
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      
                    02/10/2003 01:08 PM                                         
                                                                      
                    Please respond to                                           
                                                                      
                    Midrange Systems                                            
                                                                      
                    Technical Discussion                                        
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      




What is the appeal of locking into a Windows solution like VB?  If you want
MS Solutions wouldn't you be better off to just use MS in the first place?



Mike E, VARPG will write directly to Excel spreadsheets on any drive on the
LAN.  It uses RPGIV.  Heck, it will even open Excel on the user's desktop.





---------------------------------------------------------

Booth Martin   http://www.MartinVT.com

Booth@MartinVT.com

---------------------------------------------------------



-------Original Message-------



From: Midrange Systems Technical Discussion

Date: Monday, February 10, 2003 12:26:48

To: midrange-l@midrange.com

Subject: Re: Output from PF to Excel XLS file in IFS



Anything you can do with a macro from inside an Excel workbook you can do

from the outside using a VB program. I don't know if this could be done,

but maybe you can write your file to the IFS and then invoke a VB program

(also on the IFS) to do what you need?



midrange-l@midrange.com writes:

>1. No, I don't want macros in the spreadsheet in any way, shape or form.

>2. I want this running on schedule, in batch, on an AS/400 / iSeries with

>no human intervention and no PC. My boss won't allow it.

>

>Mike E.







Mike Naughton

Senior Programmer/Analyst

Judd Wire, Inc.

124 Turnpike Road

Turners Falls, MA 01376

413-863-4357 x444

mnaughton@juddwire.com_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.