Re: Skipping Cells

If you had a product like Showcase you could insert rows which in effect
push the existing rows down.  That would be pulling the data from the 400
instead of updating the spreadsheet from RPG.  I imagine that you could
accomplish the same with just ODBC.


Dave Parnin
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxxxxxx




                                                                                
                               
                      "Bob O."                                                  
                               
                      <otis_the_cat@hotm        To:       
rpg400-l@xxxxxxxxxxxx@SMTP@CTB                       
                      ail.com>                  cc:       (bcc: David A 
Parnin/Topeka/NISCO/SPCO)              
                      Sent by:                  Subject:  Skipping Cells        
                               
                      rpg400-l-bounces@m                                        
                               
                      idrange.com                                               
                               
                                                                                
                               
                                                                                
                               
                      03/01/2005 11:34                                          
                               
                      AM                                                        
                               
                      Please respond to                                         
                               
                      RPG programming on                                        
                               
                      the AS400 /                                               
                               
                      iSeries                                                   
                               
                      <rpg400-l@midrange                                        
                               
                      .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.