MattEdwards wrote:
I believe there is a bug when using the Excel 10.0 Object
Library DataSeries function in VB.Net 2003. I want to set
the Date parameter in the DataSeries function as follows
(the following variable NewRange is of type Excel.Range):

NewRange.DataSeries
(Type:=Excel.XlDataSeriesType.xlChronological,
Date:=Excel.XlDataSeriesDate.xlWeekday)

but VB.Net 2003 automatically changes Date:= to DateTime:=


I know nothing of VB.Net, but can you specify arguments by position as
well as by name in the way that you can in VBA?

If so why not
NewRange.DataSeries
(Excel.XlDataSeriesType.xlChronological,
Excel.XlDataSeriesDate.xlWeekday)


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup