Access to Excel, Borders + Alignments =(

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey,
I'm formatting excel via Access.
Most of the code (from klatuu) works.

Some stuff returns error messages though.

For instance,
xlSheet.Range("C3:E10").Borders.LineStyle = xlContinuous
works

while,
xlSheet.Range("C3:E10").Borders.Weight = Thin
returns
"Error #1004: Unable to set the Weight property of the Borders class"
.Columns(1).HorizontalAlignment = xlCenter
returns
"Error #1004: Unable to set the Horizontal Alignment property of the Range
class"


Any Help/Advice would be really Really Appreciated.
Thanks~
 
xlSheet.Range("C3:E10").Borders.Weight = xlThin
xlSheet.Columns(1).HorizontalAlignment = xlCenter
 
Error #1004: Unable to set the Weight property of the Borders class

Error #1004: Unable to set the HorizontalAlignment property of the Range class
 
Back
Top