M
Mark Roberts
Hi
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as integer=1 to dtsales.Rows.Count
Submitted via EggHeadCafe - Software Developer Portal of Choice
"Windows Defender" Beta 2 available (formerly "Microsoft Antispyware")
http://www.eggheadcafe.com/tutorial...27e-0c14ac717a80/windows-defender-beta-2.aspx
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as integer=1 to dtsales.Rows.Count
Submitted via EggHeadCafe - Software Developer Portal of Choice
"Windows Defender" Beta 2 available (formerly "Microsoft Antispyware")
http://www.eggheadcafe.com/tutorial...27e-0c14ac717a80/windows-defender-beta-2.aspx