Thread: Problem with the Excel 10.0 Object Library
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen Stephen Bullen is offline
external usenet poster
  
Posts: 67
Default Problem with the Excel 10.0 Object Library
Hi Bill,

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?

Yes you can.

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

Because the first parameter is 'rowcol' <g, so we need an extra comma:

NewRange.DataSeries
(, Excel.XlDataSeriesType.xlChronological,
Excel.XlDataSeriesDate.xlWeekday)

Regards

Stephen Bullen


Reply With QuoteReply With Quote