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

Dennis

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.