Quickbooks Excel Macros

[aryontep]

I’m trying to transition my team to LibreOffice, but we’ve a showstopper. We need to run certain reports in quickbooks, where quickbooks actually opens an Excel XLT template loaded with macros. The macros in the XLT file are pullling the data from Quickbooks and generating the report in excel. This is not as simple “export to CSV”.

With LibreOffice calc set as default, Quickbooks will open Calc when the quickbooks command is entered. Once Macros are Enabled, I then encounter numerous errors. Libreoffice is set to use Libre Basic. The errors include:

• syntax-err-1 — ImgBB
• syntax-err-2 — ImgBB
• syntax-err-3 — ImgBB

Any suggestions how to over come these errors? Is there perhaps a configuration setting in libreoffice that might address this? If its a simple fix in the code, I could probably resolve that also. My concern with modifing the macros is that Quickbooks may periodically update the XLT sheets.

[mikekaganski]

Your “syntax-err-3” shows a Variant variable that you try to ReDim Preserve to array of strings. It tries to change the type of the variable (from Variant, optionally holding an array, to explicit array of strings) - which is not permitted for Preserve.

With the other two screenshots, the problem is with the first type’s member name, which is Name - a (partially) reserved word, which seems illegal in this context. Changing it to, say, Naame, allows the struct.

Anyway, it’s extremely difficult to say something useful without the actual macros and data - the screenshots is the worst one can give when a program needs debugging. Generally, VBA support in LibreOffice is only partial; so no guarantee that it would work actually.