Problem: I need to open an XLSX file from within another program. That is, I need to access an XLSX file via Windows Automation Server. I cannot use a macro inside Calc.
Programatically, I can easily create a LibreOffice object using:
loLibreOffice = CreateObject( “com.sun.star.ServiceManager” )
Unfortunately, after this I am quite unsure how to proceed in opening the particular XLSX file.
Question: Would anyone be willing to help me with a code sample or general guidance?
Since this is a “one-time” project I honestly do not want to extensively study OpenOffice Basic and re-invent the wheel!
Any help would be extremely appreciated! Thank you!