RE: Excel Spreadsheets from RPG - if it's possible to add VB to an Excel document from RPG?

Oh, I see. I think/hope I said I wasn't sure of my answer, but so that you
know it wasn't a completely uneducated one: I have developed a few VB
routines that become part of Outlook (my random signature is the product of
one). It is in fact associated with M$ Scripting, but these become an
extension of Outlook itself. I've seen scripts like mine, but associated
with Excel. Years ago, I also wrote macros for Lotus 123 (remember that?),
and they had nothing to do with VB (and, 123 being a Lotus product,
obviously they also had nothing to do with M$ or VB).

Anyway, good to know.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I've been rich and I've been poor; rich is better."
-- Sophie Tucker

There's a little confusion in terms by the OP here - VB scripts can
mean
a couple things - strictly speaking, VBScript will have BAS (or
whatever
extension) files that can be executed by the Windows Scripting Host. It
is also the limited flavor of VB that is used in classic ASP, I think.

Now the OP probably means VBA macros. These are product-specific as to
extensions to support the product. Even iSeries Access macros can be
written in VBA, with its own extensions for the presentation screen
(emulation). Any macros are a part of each workbook in Excel. As we
recommend to our customers and has been mentioned here, you can make a
template that has the macros in it and use that template as the basis
for new workbooks.

Vern

On 7/9/2010 1:38 PM, Dennis Lovelady wrote:

Maybe I have this wrong, but I think VB Scripts are associated with

the

program product (Excel, M$ Office) rather than with the spreadsheets
themselves, right?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"The louder he talked of his honor, the faster we counted the

spoons."

-- Ralph Waldo Emerson

I have some questions regarding Creating VB to an Excel with POI

from

RPG.

1. Can I use POI to write (export) VBScripts macros to an

Excel

spreadsheet (.xls) file?
2. If yes, then what version of POI (HSSF) do I need? Could

you

give
me an example?





Thanks,

Helena Galkin

(905) 212-6344





--
This is the RPG programming on the IBM i / System i (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 IBM i / System i (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.