I'm trying to get the latest version of xlwings to work with Access, but it's not working.

[Atsushi888]

OS (e.g. Windows 10 or macOS Sierra)

Windows 2019 server

Versions of xlwings, Excel and Python (e.g. 0.11.8, Office 365, Python 3.7)

0.24.9, Access Office 365, Python 3.9.7

Describe your issue (incl. Traceback!)

I'm trying to get the latest version of xlwings to work with Access, but it's not working.

Your traceback here

I'm thinking of using xlwings to run Python from Access.
However, even though the manual says that Access is supported, I could not get it to work properly by following the steps.

After some research, I found out that one of the causes was due to Workbook-related instructions that are supported by Excel VBA but not by Access VBA.

So, I modified xlwings.bas to solve the problem as I posted (sorry for the length), but now I get the following error and cannot solve the problem.

After investigation, it seems to be caused by xlwings64-0.24.9.dll, so there is nothing I can do to fix the source.

Is there anything I can do?

[fzumstein]

My guess is that I broke this feature in 0.22, so have a try with 0.21.4 to see if you can make it work that way.

[Atsushi888]

My guess is that I broke this feature in 0.22, so have a try with 0.21.4 to see if you can make it work that way.

Thank you very much for your quick answer.
I'm going to try it soon.

[Atsushi888]

As advised, I was able to get it to work with 0.21.4.
Thank you very much.

However, I still want to run the latest version of xlwings.

Can you please bring back this feature in the latest version and update the xlwings.bas that needs to be fixed?

[fzumstein]

This will be fixed in the next release, but it's super messy so I wouldn't hold my breath that this feature survives a potential 1.0 release...