Using Win32::OLE with Excel. This has something to do with sheet protection. It works after a manual unprotect (the program version works sometimes, sometimes not)
$wb->Worksheets("Sheet1")->UnProtect("admin"); But the real question is, how do I chase this error message down? It doesn't mean a thing to me. Help :-) This message is generated by a range 'touch' if (!$wb->Worksheets("Sheet1")->Range("A1")) { my $oleMsg = Win32::OLE->LastError(); ... then print it BEGIN_OLE_MESSAGE--> Win32::OLE(0.1702) error 0x800a8029 in METHOD/PROPERTYGET "" <--END_OLE_MESSAGE __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs