Now I’m trying to use an xlsm file, with VBA Macro, to establish Datalinq connection between XPression and Excel. Once I have completed it but can’t save the file so often with “sharing violation” errors, it’s a nightmare.
Any another solution to this?. Anyone use xml or json outputted from Excel instead of the Excel’s legacy sharing?.
I have heard of people doing it but it cam be a little bit of a pain from a file management point of view.
Yes, I choose Excel (XLSX) in the ADODB, and push the “Select Excel file…” button. And I choose “All Files” to find my xlsm file in the dialog box.
I think Microsoft.ACE.OLEDB 12.0 supports not only xlsx but also xlsm (https://www.connectionstrings.com/ace-oledb-12-0/xlsm-files/). Am I correct?.
Hi Takuya,
Not sure if you’ve figured this out and I’m late to the game or I’m over explaining but here’s what I had to do…
Where the Datasource says [ExcelFile] map that to you excel spreadsheet. I have mine saved locally on my D drive but it can be anywhere as long as your PC has permissions. I’ve added a screen shot of my set up. Sorry if this is info you already know though or if it’s not what you’re going for.
