Facing "object required" issue while using UDF in xlwings in some excel files while at other files there is no issue at all

Asked Sep 12 '22 at 16:36

Active Sep 12 '22 at 16:36

Viewed 137 times

I have created an UDF in python and trying to use it in excel. I am facing "object required" issue while using this UDF in xlwings in some excel files while at other excel files there is no issue at all.

I am taking all the measures as suggested in xlwings documentation such as:

xlwings add-in is installed successfully
Excel in which I am working is saved as XLSM (Macro Enabled Workbook) file
xlwings is referenced to a VBA Project (alt + F11--> Tools--> References )
Trust Center Logging enabled

What must be reason for this mysterious behavior?

asked Sep 12 '22 at 16:36

sagardbhangale

I think you might be missing the reference to xlwings under VBA Editor > References ... – Felix Zumstein Sep 12 '22 at 19:11
1

Thanks Felix. However I have referenced that in VBA editor. Please refer point no 3 above. Anything else I might be missing? – sagardbhangale Sep 13 '22 at 04:01

Facing "object required" issue while using UDF in xlwings in some excel files while at other files there is no issue at all

0 Answers0