in reply to Borders of a single cell in Excel

I think it's the eval($edge), which won't make much sense, depending on what's in $edge and not even return any occurring errors either. In any case, I recommend the approach detailed in Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks), that is, using the Excel Macro Recorder to find out the things to do.

Replies are listed 'Best First'.
Re^2: Borders of a single cell in Excel
by Bintuch (Acolyte) on Sep 15, 2008 at 07:53 UTC
    I'll try that, thanks.
[reply]
      Hi, it didn't work. Eventually, I've tried some differnet code that worked: 
                  my @Edges = qw(xlEdgeBottom xlEdgeLeft xlEdgeRight xlEdgeT
+op xlDiagonalUp xlDiagonalDown);
            foreach my $edge (@Edges) {
                $SheetWaferMap->Range("$Excel_LUT{$ValueX}$ValueY")->B
+orders(eval($edge))->{LineStyle} = 7;
}

      [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom