![]() ![]() RE: Insert cells in OpenOffice Calc from VB peterd51 (TechnicalUser) This is expected behaviour, not an error. for the OpenOffice documentation.Īnd VB intellisense (autocase and command completion, for example) doesn't work with latebound objects (which all the OpenOffice objects are), nor can you inspect the objects in the object browser or the Locals window. The Controller (in this case the active controller) returns an extended interface that does. GetSheets (and Sheets) return to VB an interface to a lightweight generic object that doesn't support most of the functionality you require (hence the errors you saw). The issue is related to which interface (of multiple ones) is returned. You should also ignore the comments that the " the brige is broken and cannot be trusted" it is nothing to do with case (and both the statements referred to work). Also, not quite sure what the comment you added means. ![]() ![]() Note that the first two lines of that are no longer necessary. Peter RE: Insert cells in OpenOffice Calc from VB strongm (MIS) 6 Jan 18 18:19 I've tried (".CellInsertMode.DOWN"), still fails. 'gives error 438 Object doesn't support this property or methodĭoes anyone know how to 'Dim' and 'set' anything that can hold ".CellInsertMode.DOWN" so I can pass it to the Open Office Calc worksheet? 'fails below on ".CellInsertMode.DOWN"Ĭall oSheet.insertCells(oCRAddr, ".CellInsertMode.DOWN") Set oCRAddr = oSM.Bridge_GetStruct(".CellRangeAddress") 'Set Cell Range Set oSheet = oDoc.sheets(0) 'point to 1st WorkSheet Set oSheets = oDoc.getSheets() 'get available WorkSheets Set oDoc = oDesk.loadComponentFromURL(URL, "_blank", 0, OpenParam) 'Open the Doc Set oDesk = oSM.createInstance(".Desktop") Set oSM = CreateObject("") 'initial set-up Dim oSM As Object 'Root object for accessing OpenOffice from VBĭim OpenParam(1) As Object 'Parameters to open the doc ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |