ChrisJRutter
Member
Hi
I am building a 2d line chart in Excel 2007.
Can anyone explain why the following code generates the message "an error occurred while accessing property/method 'line' - unknown name".
chExcel:ActiveChart:SeriesCollection(1):Line:Color = 7.
(I have also tried replacing the 7 with a color descriptor like "Green")
whereas the following works fine.
chExcel:ActiveChart:SeriesCollection(1):Smooth = True.
I have searched as many VB forums/websites as I can find, many of which refer to the exact syntax I am having trouble with. VB help in Excel 2007 doesn't shed any light either. Any assistance would be greatly appreciated. Thanks in advance
I am building a 2d line chart in Excel 2007.
Can anyone explain why the following code generates the message "an error occurred while accessing property/method 'line' - unknown name".
chExcel:ActiveChart:SeriesCollection(1):Line:Color = 7.
(I have also tried replacing the 7 with a color descriptor like "Green")
whereas the following works fine.
chExcel:ActiveChart:SeriesCollection(1):Smooth = True.
I have searched as many VB forums/websites as I can find, many of which refer to the exact syntax I am having trouble with. VB help in Excel 2007 doesn't shed any light either. Any assistance would be greatly appreciated. Thanks in advance