Hi All,
I am experiencing similar issues as faced by samdotnetprogrammer. Please could anyone tell the .dll that we need to use so that we could work on OpenOffice Excel / Word. Few hours back I saw a website that mentions the following dll:
1. OOWRITVB.DLL - For Text Docs. (OpenOffice)
2. OOCALCVB.DLL - For Excel. (OpenOffice)
I presume that once we add these two files in the references, we will be able to work just as we can work on Microsoft Excel after adding Microsoft Excel 11.0 Object Library.
Am I right? Please let me know.
Quote:
Originally Posted by samdotnetprogrammer
Hello All,
I am trying to code using Visual Basic to open OpenOffice calc application and manipulate with the cells. I am successful to a certain extent, however I am facing a problem formatting the cell..... for example, I want to draw borders to a cell. How can this be achieved??
Following is the code that I have written :
-
Function MakeCellBorderLine(nColor, nInnerLineWidth, nOuterLineWidth, nLineDistance) As Object
-
oBorderLine = createUnoStruct("com.sun.star.table.BorderLine")
-
With oBorderLine
-
.Color = nColor
-
.innerlinewidth = nInnerLineWidth
-
.outerlinewidth = nOuterLineWidth
-
.linedistance = nLineDistance
-
End With
-
-
MakeCellBorderLine = oBorderLine
-
End Function
-
Whenever I compile my code it gives me an error that says : "User-defined type not defined". I have absolutely NO CLUE how to proceed. Can someone be of help???
Thanks a ton in advance..
Rgds,
SAM
