I am using an Excel file as a database for a point of sales system.
I only need to view the database using Office on one computer. All others only need to read/write to the file.
Is there a way to read and write to XLS or XLSM files without installing Office? Changing the file type is okay as long as it can be opened in Excel and has all the same features as an XLS or XLSM file.
Thanks in advance.
Hunter
Edit: Solution found
I got it to work. Finally.
It's 3 AM.
I made the change from XLS to XLSX which brought some extra, frustrating problems related to cell writing.
I also had to install the 32-bit version of Microsoft Access Database Engine 2010 (I originally had the 64-bit version).
Here's what I've done:
#include <ADO_CONSTANTS.au3>
$oMyError = ObjEvent("AutoIt.Error","MyErrFunc")
Func MyErrFunc()
Msgbox(0,"AutoItCOM Test","We intercepted a COM Error !"