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?