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.
------------------------------
Donny Swanson
Graphic Designer, Broadcast
TVO (TVOntario)
Toronto Canada
------------------------------
Original Message:
Sent: 10-21-2024 19:10
From: Takuya Hoshikaya
Subject: Looking for a way not to use Excel's legacy sharing.
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?.
------------------------------
Takuya Hoshikaya
Original Message:
Sent: 10-21-2024 12:02
From: Garner Millward
Subject: Looking for a way not to use Excel's legacy sharing.
Are you using the ADODB data source and the ACE driver?
Original Message:
Sent: 10-17-2024 07:21
From: Takuya Hoshikaya
Subject: Looking for a way not to use Excel's legacy sharing.
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?.
------------------------------
Takuya Hoshikaya
------------------------------