Re: Open Office Calc In VB?

Den 2010-12-28 09:25:54 skrev Jürgen Schmidt <[email protected]>:

> Hi,
>
> first of all you should subscribe to this mailing list under
> http://api.openoffice.org/servlets/ProjectMailingListList with a valid
> OOo account.
>
> You can use the OOo API to manipulate a spreadsheet document and insert
> any kind of data, create charts, apply formulas etc. Or you can work on
> the xml format directly, means you can create a report as template,
> unpack the ods and work directly on the content.xml and zip later the
> xml streams again to *.ods. The content.xml can be manipulate with
> normal xml processing mechanisms like xslt. Or check the odfdom API
> (www.odfdom.org), a Java based API to manipulate ODF documents directly
> without office.
>
> Juergen
>
> On 12/27/10 7:19 PM, veerapandian wrote:
>> Dear Dev,
>>
>>
>> I have developed many reports using excel in VB6. Now we want to  
>> convert it
>> using open office calc. How could we do it?
>>
>> Thanks & Regards,
>>
>> Veerapandian.K
>>

Somehow I thought that the question was something like ”how can I convert  
VB6 for Excel to OpenOffice.org Basic for OpenOffice.org Calc?”
I did some searching and found this (probably useless) site:
http://www.business-spreadsheets.com/vba2oo.asp

If your macros are advanced I guess you need to rewrite them for  
OpenOffice.org Calc from scratch, unfortunately, but hopefully I am wrong  
there…

-- 
Kind regards

Johnny Rosenberg