Importing several modules

[alassauzet]

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

Windows 10

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

The last one (0.14.1) - Excel 16.0

Describe your issue (incl. Traceback!)

Hi guys,

When importing two modules, I have an « Excel automation error 440 », while it perfectly works when I import each one separately. And I use « ; » as explained in the doc to import them simultaneously in the field « UDF_MODULES » (confirmed in the conf file). Any idea ?

Thanks for your help,
Alix

[fzumstein]

this error was introduced in v0.12. For now you can work around it by hacking the xlwings_udfs VBA module and remove the duplicate line

#Const App = "Microsoft Excel" 'Adjust when using outside of Excel

[alassauzet]

Indeed, this makes it working. If I'm right, this should be fixed inside the function generate_vba_wrapper

https://github.com/ZoomerAnalytics/xlwings/blob/98a0a6b2a15b390f5ba78057b5e817bf84e73be9/xlwings/udfs.py#L299-L307

which is called for each imported module

https://github.com/ZoomerAnalytics/xlwings/blob/98a0a6b2a15b390f5ba78057b5e817bf84e73be9/xlwings/udfs.py#L414-L416

Thanks again
Alix