Run-time error '9' Subscript out of range with sheet xlwings.conf added after workbook creation

[ilrico]

I created a new sheet then renamed it to "xlwings.conf" (in VBA editor properties it appears with (name) set to Sheet6 and name set to xlwings.conf
Then if I try click on addin "Restart UDFs server" or "Import functions" I have the error Subscript out of range on line(in function GetConfigFromSheet() ):
Set sht = ThisWorkbook.Sheets("xlwings.conf")

[fzumstein]

what's the content of your xlwings.conf sheet?

[ilrico]

Exactly the exemple found on https://github.com/ZoomerAnalytics/xlwings/blob/master/docs/addin.rst
Keys on column A and values on B, 6 lines. Same keys/values.

[fzumstein]

please try with a spreadsheet produced by xlwings quickstart command line

[andreicrisan11]

I have the same issue as @ilrico even though I installed it via xlwings quickstart. Any idea as to what the problem might be?

At first I had the "xlwings32.dll not found" error however after changing the name of the last sheet from "_xlwings.conf" to "xlwings.conf" (as instructed in the sheet) the error switched to this one.

xlwings.conf sheet is the same as the default one. Been struggling for the past two days to make this work, and have no idea what else there is to do.

Would really appreciate a fix, as it seems like an amazing tool, and I want to do all the statistics and data manipulation even from the database in python as opposed to VBA.

[andreicrisan11]

Rate_hike_probability.zip

These are the ones, they are just the templates created directly from calling the command xlwings quickstart.

[fzumstein]

thx I found the issue in the meantime, will release a fix tomorrow Am 13.07.2017 11:57 nachm. schrieb "andreicrisan11" < notifications@github.com>:

…

Rate_hike_probability.zip <https://github.com/ZoomerAnalytics/xlwings/files/1146772/Rate_hike_probability.zip> These are the ones, they are just the templates created directly from calling the command xlwings quickstart. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://github.com/ZoomerAnalytics/xlwings/issues/708#issuecomment-315213581>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACKRoPAIlJrfqdr0wgEk64zeBzXpxhILks5sNpK4gaJpZM4OUag1> .

[andreicrisan11]

Perfect, thank you. Would you please be able to let us know when the fix has been released so that we can try it out?

[fzumstein]

please try with 0.11.3, make sure to update the addin.