Re: Skipping Cells

[MWalter@xxxxxxxxxxxxxxx]

I'd use a combination of RPG and VBA for this. Trigger the RPG from your
VBA macro and then populate the spreadsheet using VBA.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                           
             "Bob O."                                                      
             <otis_the_cat@hot                                             
             mail.com>                                                  To 
             Sent by:                  rpg400-l@xxxxxxxxxxxx               
             rpg400-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       Skipping Cells                      
             03/01/2005 11:34                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




I have a project where I need to grab data from the as400 via an RPG
program
and dump it into an existing excel spreadsheet.  There are cells on the
spreadsheet that perfrom calculations.  I need to "skip" over these cells
so
as not to overwrite the formulas.  Is there a way to accomplish this?


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.