Welcome Guest. Please Login or Register. Apr 5th, 2018, 10:17pm
ATTENTION MEMBERS: Conforums will be closing it doors and discontinuing its service on April 15, 2018. Ad-Free has been deactivated. Outstanding Ad-Free credits will be reimbursed to respective payment methods.
If you require a dump of the post on your message board, please come to the support board and request it.
Re: LibreOffice Calc
« Reply #2 on: Nov 23rd, 2014, 06:05am »
Not really.
What I have in mind is replicating an Excel VBA app I wrote some time ago, but now want to rewrite for LibreOffice to make the functionality available for people who don't have Excel.
In essence, the app displays a spreadsheet, and has several buttons, including a CONNECT and a READ button. After CONNECTing to the external device, the program READs data and plugs it into individual spreadsheet cells in real time.
To do this, I need to know how to make BB4W identify and write into individual Calc cells. As Calc and BB4W executables are separate entities (as opposed to Excel which is tightly integrated with VBA), it may not be practical to do what I want. At this time I am just wondering if anyone here has done anything broadly similar.
You will find the answers there. Sounds like an interesting challenge, but it shouldn't be too difficult. If you've not used COMLIB before I would recommend studying the relevant section of the main Help docs and working through the examples on the wiki:
Logged
