at line Charts.addNewByName("MyChart", Rect, RangeAddress, False, False).
this is the code
Code: Select all
Dim Doc As Object
Dim Charts As Object
Dim Chart As Object
Dim Rect As New unoidl.com.sun.star.awt.Rectangle
Dim RangeAddress(0) As Object
Url = "private:factory/scalc"
oSM = CreateObject("com.sun.star.ServiceManager")
odp = oSM.createInstance("com.sun.star.frame.Desktop")
odc = odp.loadComponentFromURL(Url, "_blank", 0, aNoArgs)
oss = odc.Sheets(0)
os = oss.getByIndex(0)
Dim OpenPar(1) As Object
dispatch = oSM.createInstance("com.sun.star.frame.DispatchHelper")
'RangeAddress(0) = New unoidl.com.sun.star.table.CellRangeAddress
RangeAddress(0) = oSM.Bridge_GetStruct("com.sun.star.table.CellRangeAddress")
Charts = os.charts
Rect.X = 8000
Rect.Y = 1000
Rect.Width = 10000
Rect.Height = 7000
RangeAddress(0).Sheet = 0
RangeAddress(0).StartColumn = 1
RangeAddress(0).StartRow = 3
RangeAddress(0).EndColumn = 1
RangeAddress(0).EndRow = 13
Dim oMRI As Object
oMRI = oSM.createInstance("mytools.Mri")
oMRI.inspect(Charts)
Charts.addNewByName("MyChart", Rect, RangeAddress, False, False)