View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sergio sergio is offline
external usenet poster
 
Posts: 2
Default Error accessing external object property XVALUES

Using Powerbuilder, I get an the following error:

Error accessing external object property xvalues at line 88......

My code is very simple:


ole_excel.Worksheets(l_engine).Activate //Ok
ole_excel.ActiveSheet.ChartObjects(1).Activate //Ok
ole_excel.ActiveChart.ChartTitle.Characters.Text = "Engine " +
string(l_engine) //Ok
ole_excel.ActiveChart.SeriesCollection(1).XValues = "=Engine"+
string(l_engine) + "!R2C1:R2C" + string(l_values) //Error!!!

I have Microsoft Office 2003 Installed in my machine.

Why I could not access XValues of SeriesCollection.

Have tried doing it running a macro in Excel directly with no luck.

Any help would be gladly apreciated.