Felix Zumstein

Then this coud be a conflict of the two libraries (the error msg comes from xlwings). In your spreadsheet, do you have both the xlpython and xlwings VBA modules?

for the record, this was fixed here: https://github.com/tafia/calamine/commit/152b21e24929a5ec0e91499baeafd1585a72649b#diff-8e2b774210d6a54bbf1cec6c835f28b924e3f94684c0cd546e3a691505a22799R883-R885

Welcome back :) I'll take a look when I get a chance

Now that we have [app.alert()](https://docs.xlwings.org/en/stable/api.html#xlwings.App.alert), I guess you can just do: ```python try: ... except Exception as e: myapp.alert("User-friendly message") ``` which works across all platforms.

Hi Patrick, would it be possible that you post a minimal code sample to replicate this? Or alternatively, could you send me a sample workbook (email is on my profile).

Set `OPTIMIZED_CONNECTION = False` and you will be fine again. For long running processes, setting this value to `True` won't have a real impact: With `False` there is an overhead...

@ilrico can you add a minimal sample that allows us to replicate the issue please, thanks.

For long running tasks, you should use `RunPython` in VBA instead of using an `xw.sub` decorator and importing it.

I agree, it's a great idea, but I'd call it `xw.cache` to be in line with `functools.cache`. Also, you don't need C++ to change the VBA wrapper code, that's done...

Few thoughts: > I don't have access to the vba model I guess you mean you can auto-insert the VBA module? In theory, you can paste the wrapper code also...