Advertisement

02.04.2008 at 05:31PM PST, ID: 23136926
[x]
Attachment Details

SeriesCollection, VB.NET, Excel 2003 vs. 2007

Asked by sporenza in .NET, Microsoft Visual Basic.Net

Tags: VB.NET, Excel 2003 vs. 2007, Unhandled Exception: System.Runtime.InteropServices.COMException (0x800A03EC): U

My quesion is mostly basic, I have the following line of code:
            chartWorkbook.SeriesCollection(1).Interior.Color = RGB(0, 255, 0)

When this line of code is added I get this error:
Unhandled Exception: System.Runtime.InteropServices.COMException (0x800A03EC): U
nable to set the Color property of the Interior class
   at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateSet(Object
o, Type& objType, String name, Object[] args, String[] paramnames, Boolean Optim
isticSet, CallType UseCallType)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateSet(Object Insta
nce, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, T
ype[] TypeArguments, Boolean OptimisticSet, Boolean RValueBase, CallType CallTyp
e)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateSetComplex(Objec
t Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentN
ames, Type[] TypeArguments, Boolean OptimisticSet, Boolean RValueBase)
   at ConsoleApplication1.Module1.MakeGraph(Int32 ArrayWidth, Int32 ArrayLength,
 String MetricType, Int32 jstart, Object WorksheetName, String ChartViewportName
)
   at ConsoleApplication1.Module1.SetupGraph(String MetricType, Object XLSXWorkb
ook)
   at ConsoleApplication1.Module1.Main()


I have a pretty good idea on why this is a problem, well if you look at the end of the error you see "XLSXWOrkbook", 2003 does not support XLSX files!!!

But I am saving the file as "excelWorkbook.SaveAs(FileInput & ".xls")", so I would not think that the file is an xlsx file, but it must be???

Maybe the problem is that I am compling on a machine with Office 2007??

HELP!Start Free Trial
[+][-]02.05.2008 at 06:28AM PST, ID: 20823066

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.05.2008 at 12:47PM PST, ID: 20826745

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.05.2008 at 01:02PM PST, ID: 20826901

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.05.2008 at 02:54PM PST, ID: 20828012

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.06.2008 at 05:59AM PST, ID: 20831885

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.06.2008 at 11:28AM PST, ID: 20834880

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.06.2008 at 12:33PM PST, ID: 20835460

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.06.2008 at 01:45PM PST, ID: 20836063

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: .NET, Microsoft Visual Basic.Net
Tags: VB.NET, Excel 2003 vs. 2007, Unhandled Exception: System.Runtime.InteropServices.COMException (0x800A03EC): U
Sign Up Now!
Solution Provided By: TheLearnedOne
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628