TransBar
Printing
   barcode
        solution

Excel, OpenOffice and LibreOffice clients examples

Two examples are provided, with minimal differences:

These two Basic languages have syntaxes that are very similar and largely compatible, and it is sometimes possible to use an Excel spreadsheet under LibreOffice or OpenOffice and then re-save it in Excel format without losing the functionality of an attached macro. But this is not the case with the examples provided, which each use a Basic function called "Shell" whose operation is different on two essential points:

Also, on Windows, this "Shell" function requires Excel or LibreOffice-OpenOffice to be run with administrative rights. Several solutions are possible: these settings can be permanent or limited to the current launch.

Last difficulty, downloading a spreadsheet incorporating a macro will often be prevented by anti-virus software. The two spreadsheets that TransBar proposes have been grouped together in a ZIP archive, but usually this elementary protection will not be enough to overcome the difficulty. This is why you will find below two links:

These spreadsheets are currently only available in French.


Excel is the spreadsheet of the business offer "Microsoft Office".

OpenOffice is free software released by the Apache Foundation. It can be downloaded in English from the page opened by this first link.

LibreOffice is free software, based on the same sources as OpenOffice, published by The Document Foundation. It can be downloaded in English from the page opened by this second link.