Re: Skipping Cells

I think I'm with Mark on this, although I'd like to know better what you
mean by "grab some data from the AS/400 via  an RPG program and dump it
into an existing Excel spreadsheet". Will the data be dumped as a block,
or can you monitor/control the flow with VBA? Does the existing
spreadsheet have other data in it that you don't want to disturb?

You can certainly write a VBA macro to do whatever you want to do to the
spreadsheet once the data is there (and if the macro is intercepting the
data on the way through then you can also do it on the fly). You could
even set up a connection to the AS/400 in VBA and grab the data using SQL
(if that's possible); alternatively, you could write a VB program to do
that and manipulate the spreadsheet from there.

Ya, you have lots of choices. . . :-)

RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> writes:
>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.



Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx