LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Problem with the Excel 10.0 Object Library

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:=
as follows:

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

and errors stating DateTime is not a parameter of the
DataSeries function. Could someone give me a bug fix for
this problem?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Word and Excel 11.0 Object Library ekreider Excel Discussion (Misc queries) 4 January 8th 08 04:01 PM
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library [email protected] Excel Discussion (Misc queries) 3 May 1st 07 06:57 PM
Microsoft Excel 11.0 Object Library documentation? Just-a-COG-in-the-works Charts and Charting in Excel 0 April 25th 07 05:22 PM
Microsoft Word Object Library in Excel Gaetan Excel Discussion (Misc queries) 4 March 14th 07 06:34 PM
Printing through the Excel Object Library Shay Friedman Excel Programming 1 September 23rd 03 03:22 AM


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"