Re: Skipping Cells

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