On Thu, 29 Dec 2005, Lyndon Rickards wrote: > I'm looking to add some controls to a workbook, not possible using > Spreadsheet::WriteExcel, with which I create the workbook. > > Advice, pointers anyone? Specifically Activate and deActivate routines > to be written to ThisWorkbook and each of it's worksheets. > > Recording a macro adding code, just gives an empty sub :-(
I once wrote some code to add a macro to the normal.dot template in Word. I assume the code for Excel is pretty similar, given that both use VBA to manage the macros. I remember that it took a lot of trial and error to figure out how to use the VBA object model as not everything works as you would expect it to work. Anyways, here is the code from a talk I gave at The Perl Conference 3 in 1999 (link will probably get wrapped): http://opensource.activestate.com/authors/jandubois/Perl/TPC3/fun.html#Using_PerlCOM_Babelfish_for_Mic If you manage to get it to work with contemporary versions of Excel, please post some working code back to the mailing list. :) Cheers, -Jan _______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
