in reply to Re: Unexpected Excel TypeLib error
in thread Unexpected Excel TypeLib error

Constants are useless without an app (like excel), so use an ole instance to get the constants, the best way to get constants, direct quote from the docs/Win32::OLE::Const

use Win32::OLE; use Win32::OLE::Const; my $Excel = Win32::OLE->new('Excel.Application', 'Quit'); my $xlcon = Win32::OLE::Const->Load($Excel); ... $xlcon->{xlMarkerStyleDot} ...