Jan Dubois wrote:
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. :)
Thanks - that's a whole lot of steps in the right direction, but brings
up the question what is perlCOM? I have the PDK but no sign there, and
all the refs seem to indicate that is where it should be.
Set PerlCOM = CreateObject("PerlCOM.Script") throws an activex error,
cannot create object. The few other perl references I found, indicate
this should work?
- Lynn.
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
