Re: Skipping Cells

["Richard ECUYER" <recuyer@xxxxxxx>]

you have some java tool that can do it for you.
The only thing to do is parse the data and for each type of data to process,
add a template (name of spreadsheet, target cell...)

----- Original Message ----- 
From: <MWalter@xxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, March 01, 2005 5:42 PM
Subject: Re: Skipping Cells


> 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.
>
>
>
> -- 
> 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.
>
>