Spreadsheet creation

Hey guys,

I'm trying to create a spreadsheet with Ruby using the spreadsheet gem.
I'm able to create a new sheet and add data and everything but I'm
wondering, is there any way to preserve macros and vb projects in an
existing xls file then add data to it in a new sheet? Currently, I'm
opening a spreadsheet with macros and vb projects, adding a new sheet to
it with my created data...but when I open it, the VB projects, macros
and conditional formatting is all lost.

Any help would be greatly appreciated!

Thanks!

Spec Ex wrote:

Hey guys,

I'm trying to create a spreadsheet with Ruby using the spreadsheet gem.
I'm able to create a new sheet and add data and everything but I'm
wondering, is there any way to preserve macros and vb projects in an
existing xls file then add data to it in a new sheet? Currently, I'm
opening a spreadsheet with macros and vb projects, adding a new sheet to
it with my created data...but when I open it, the VB projects, macros
and conditional formatting is all lost.

Any help would be greatly appreciated!

Thanks!

Anyone?