There's more than one way to do things | |
PerlMonks |
Re: Problem Writing macros in an Excel Fileby Mr. Muskrat (Canon) |
on Feb 03, 2014 at 16:03 UTC ( [id://1073226]=note: print w/replies, xml ) | Need Help?? |
Have you considered exporting the macros and including them in a new spreadsheet? I haven't used it yet but Excel::Writer::XLSX has a tool, extract_vba, to extract a binary macro file and then you use the add_vba_project method to add your macro file to a spreadsheet.
In Section
Seekers of Perl Wisdom
|
|