search

janholstjensen / rdkit4excel

Excel add-in written in Python that gives access to RDKit functions in Excel.
Other
5 stars 0 forks source link

Problem installing #3

Open stephencarino opened 4 years ago

stephencarino commented 4 years ago

Hi,

I followed the installation instruction, set up the path, installed it in registry with no error and was able to register the addin in Excel. However, I still get #NAME? in Excel. What's the best way to troubleshoot this?

--Stephen

janholstjensen commented 4 years ago

Hi Stephen,

First of all, thanks for trying RDKit for Excel!

I would start by checking if the COM object can be loaded from Excel VBA. Try the following Sub:

Sub Test()
   Dim AddIn As Variant
   Set AddIn = CreateObject("Python.RDKitXL")

   Dim VerString As String
   VerString = AddIn.rdkit_info_version()
   MsgBox VerString
End Sub

It ought to fail with "ActiveX component can't create object", since you get #NAME? in Excel. If it succeeds, then things are interesting.

Is your Excel 32-bit or 64-bit - and likewise, is your Python 32- or 64-bit ?

Cheers -- Jan

On 2020-05-22 04:42, stephencarino wrote:

Hi,

I followed the installation instruction, set up the path, installed it in registry with no error and was able to register the addin in Excel. However, I still get #NAME? in Excel. What's the best way to troubleshoot this?

--Stephen

stephencarino commented 4 years ago

Hi Jan,

I appreciate you following up. I did actually tried VBA but wasn’t sure exactly how the object is initiated. Anyway, tried to run the code you suggested and it resulted to an error message as expected. Interestingly, I get the first error when the cursor is inside the sub and the 2nd error message when the cursor is outside and I get prompted which macro to run. Can you tell where the issue is based on these error messages?

I also captured the Miniconda installation. As you can see I have a 64bit Python. Excel is 32-bit so made the registry added per the instruction.

Thanks,

Stephen

[cid:image003.png@01D63227.E2270650]

[cid:image004.png@01D63226.292B7BF0]

[cid:image005.png@01D63226.4A6F1BF0]

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Jan Holst Jensenmailto:notifications@github.com Sent: Sunday, May 24, 2020 1:03 PM To: janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: stephencarinomailto:stephen.carino@outlook.com; Authormailto:author@noreply.github.com Subject: Re: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Stephen,

First of all, thanks for trying RDKit for Excel!

I would start by checking if the COM object can be loaded from Excel VBA. Try the following Sub:

Sub Test() Dim AddIn As Variant Set AddIn = CreateObject("Python.RDKitXL")

Dim VerString As String VerString = AddIn.rdkit_info_version() MsgBox VerString End Sub

It ought to fail with "ActiveX component can't create object", since you get #NAME? in Excel. If it succeeds, then things are interesting.

Is your Excel 32-bit or 64-bit - and likewise, is your Python 32- or 64-bit ?

Cheers -- Jan

On 2020-05-22 04:42, stephencarino wrote:

Hi,

I followed the installation instruction, set up the path, installed it in registry with no error and was able to register the addin in Excel. However, I still get #NAME? in Excel. What's the best way to troubleshoot this?

--Stephen

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fjanholstjensen%2Frdkit4excel%2Fissues%2F3%23issuecomment-633260669&data=02%7C01%7C%7Cda4ed8484b2449fd7ea508d800045079%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637259365807586565&sdata=Szcjhhp3z4mNf8pd9ZrTku87%2BCXRH4vZEI8KIxslvJQ%3D&reserved=0, or unsubscribehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAPVT3X6GQ47SRRFXCINIS4LRTFHMJANCNFSM4NHNMUTQ&data=02%7C01%7C%7Cda4ed8484b2449fd7ea508d800045079%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637259365807586565&sdata=Q%2B7Qie2L7HKzzvbxPzsVbTgM%2BgSi2aOm1WgFRN1iPR0%3D&reserved=0.

stephencarino commented 4 years ago

Jan,

Correction – Excel is 64-bit and I made the registry changes.

Stephen

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Stephen Carino stephen.carino@outlook.com Sent: Monday, May 25, 2020 12:03:13 AM To: janholstjensen/rdkit4excel reply@reply.github.com; janholstjensen/rdkit4excel rdkit4excel@noreply.github.com Cc: Author author@noreply.github.com Subject: RE: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Jan,

I appreciate you following up. I did actually tried VBA but wasn’t sure exactly how the object is initiated. Anyway, tried to run the code you suggested and it resulted to an error message as expected. Interestingly, I get the first error when the cursor is inside the sub and the 2nd error message when the cursor is outside and I get prompted which macro to run. Can you tell where the issue is based on these error messages?

I also captured the Miniconda installation. As you can see I have a 64bit Python. Excel is 32-bit so made the registry added per the instruction.

Thanks,

Stephen

[cid:image003.png@01D63227.E2270650]

[cid:image004.png@01D63226.292B7BF0]

[cid:image005.png@01D63226.4A6F1BF0]

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Jan Holst Jensenmailto:notifications@github.com Sent: Sunday, May 24, 2020 1:03 PM To: janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: stephencarinomailto:stephen.carino@outlook.com; Authormailto:author@noreply.github.com Subject: Re: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Stephen,

First of all, thanks for trying RDKit for Excel!

I would start by checking if the COM object can be loaded from Excel VBA. Try the following Sub:

Sub Test() Dim AddIn As Variant Set AddIn = CreateObject("Python.RDKitXL")

Dim VerString As String VerString = AddIn.rdkit_info_version() MsgBox VerString End Sub

It ought to fail with "ActiveX component can't create object", since you get #NAME? in Excel. If it succeeds, then things are interesting.

Is your Excel 32-bit or 64-bit - and likewise, is your Python 32- or 64-bit ?

Cheers -- Jan

On 2020-05-22 04:42, stephencarino wrote:

Hi,

I followed the installation instruction, set up the path, installed it in registry with no error and was able to register the addin in Excel. However, I still get #NAME? in Excel. What's the best way to troubleshoot this?

--Stephen

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fjanholstjensen%2Frdkit4excel%2Fissues%2F3%23issuecomment-633260669&data=02%7C01%7C%7Cda4ed8484b2449fd7ea508d800045079%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637259365807586565&sdata=Szcjhhp3z4mNf8pd9ZrTku87%2BCXRH4vZEI8KIxslvJQ%3D&reserved=0, or unsubscribehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAPVT3X6GQ47SRRFXCINIS4LRTFHMJANCNFSM4NHNMUTQ&data=02%7C01%7C%7Cda4ed8484b2449fd7ea508d800045079%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637259365807586565&sdata=Q%2B7Qie2L7HKzzvbxPzsVbTgM%2BgSi2aOm1WgFRN1iPR0%3D&reserved=0.

janholstjensen commented 4 years ago

Hi Stephen,

OK, the 64-bit Excel could be the issue here. It is not very common to have 64-bit Office, but of course we want it to work in 64-bit Office too!

Unfortunately I don't have an installation with 64-bit Excel at the moment. I am going to need it for other purposes soon anyway, so let me get that setup. It may be a couple of days before I can get back to you with more details - sorry.

Cheers -- Jan

On 2020-05-25 15:58, stephencarino wrote:

Jan,

Correction – Excel is 64-bit and I made the registry changes.

Stephen

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Stephen Carino stephen.carino@outlook.com Sent: Monday, May 25, 2020 12:03:13 AM To: janholstjensen/rdkit4excel reply@reply.github.com; janholstjensen/rdkit4excel rdkit4excel@noreply.github.com Cc: Author author@noreply.github.com Subject: RE: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Jan,

I appreciate you following up. I did actually tried VBA but wasn’t sure exactly how the object is initiated. Anyway, tried to run the code you suggested and it resulted to an error message as expected. Interestingly, I get the first error when the cursor is inside the sub and the 2nd error message when the cursor is outside and I get prompted which macro to run. Can you tell where the issue is based on these error messages?

I also captured the Miniconda installation. As you can see I have a 64bit Python. Excel is 32-bit so made the registry added per the instruction.

Thanks,

Stephen

[cid:image003.png@01D63227.E2270650]

[cid:image004.png@01D63226.292B7BF0]

[cid:image005.png@01D63226.4A6F1BF0]

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Jan Holst Jensenmailto:notifications@github.com Sent: Sunday, May 24, 2020 1:03 PM To: janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: stephencarinomailto:stephen.carino@outlook.com; Authormailto:author@noreply.github.com Subject: Re: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Stephen,

First of all, thanks for trying RDKit for Excel!

I would start by checking if the COM object can be loaded from Excel VBA. Try the following Sub:

Sub Test() Dim AddIn As Variant Set AddIn = CreateObject("Python.RDKitXL")

Dim VerString As String VerString = AddIn.rdkit_info_version() MsgBox VerString End Sub

It ought to fail with "ActiveX component can't create object", since you get #NAME? in Excel. If it succeeds, then things are interesting.

Is your Excel 32-bit or 64-bit - and likewise, is your Python 32- or 64-bit ?

Cheers -- Jan

On 2020-05-22 04:42, stephencarino wrote:

Hi,

I followed the installation instruction, set up the path, installed it in registry with no error and was able to register the addin in Excel. However, I still get #NAME? in Excel. What's the best way to troubleshoot this?

--Stephen

stephencarino commented 4 years ago

Jan,

Thanks again for trying to sort this out. For what it’s worth, I have attached the debug log from PythonWin.

Stephen

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Jan Holst Jensenmailto:notifications@github.com Sent: Monday, May 25, 2020 10:29 AM To: janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: stephencarinomailto:stephen.carino@outlook.com; Authormailto:author@noreply.github.com Subject: Re: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Stephen,

OK, the 64-bit Excel could be the issue here. It is not very common to have 64-bit Office, but of course we want it to work in 64-bit Office too!

Unfortunately I don't have an installation with 64-bit Excel at the moment. I am going to need it for other purposes soon anyway, so let me get that setup. It may be a couple of days before I can get back to you with more details - sorry.

Cheers -- Jan

On 2020-05-25 15:58, stephencarino wrote:

Jan,

Correction – Excel is 64-bit and I made the registry changes.

Stephen

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Stephen Carino stephen.carino@outlook.com Sent: Monday, May 25, 2020 12:03:13 AM To: janholstjensen/rdkit4excel reply@reply.github.com; janholstjensen/rdkit4excel rdkit4excel@noreply.github.com Cc: Author author@noreply.github.com Subject: RE: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Jan,

I appreciate you following up. I did actually tried VBA but wasn’t sure exactly how the object is initiated. Anyway, tried to run the code you suggested and it resulted to an error message as expected. Interestingly, I get the first error when the cursor is inside the sub and the 2nd error message when the cursor is outside and I get prompted which macro to run. Can you tell where the issue is based on these error messages?

I also captured the Miniconda installation. As you can see I have a 64bit Python. Excel is 32-bit so made the registry added per the instruction.

Thanks,

Stephen

[cid:image003.png@01D63227.E2270650]

[cid:image004.png@01D63226.292B7BF0]

[cid:image005.png@01D63226.4A6F1BF0]

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Jan Holst Jensenmailto:notifications@github.com Sent: Sunday, May 24, 2020 1:03 PM To: janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: stephencarinomailto:stephen.carino@outlook.com; Authormailto:author@noreply.github.com Subject: Re: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Stephen,

First of all, thanks for trying RDKit for Excel!

I would start by checking if the COM object can be loaded from Excel VBA. Try the following Sub:

Sub Test() Dim AddIn As Variant Set AddIn = CreateObject("Python.RDKitXL")

Dim VerString As String VerString = AddIn.rdkit_info_version() MsgBox VerString End Sub

It ought to fail with "ActiveX component can't create object", since you get #NAME? in Excel. If it succeeds, then things are interesting.

Is your Excel 32-bit or 64-bit - and likewise, is your Python 32- or 64-bit ?

Cheers -- Jan

On 2020-05-22 04:42, stephencarino wrote:

Hi,

I followed the installation instruction, set up the path, installed it in registry with no error and was able to register the addin in Excel. However, I still get #NAME? in Excel. What's the best way to troubleshoot this?

--Stephen

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fjanholstjensen%2Frdkit4excel%2Fissues%2F3%23issuecomment-633598944&data=02%7C01%7C%7C00c7f56e3d8e4d81147608d800b81825%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637260137957636776&sdata=kuYmIN03i7j9ElPlKVoBpBqnzK8mGCJRQwFu5kbFBqw%3D&reserved=0, or unsubscribehttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAPVT3X6MBESSEQIA6W44LGLRTJ6GFANCNFSM4NHNMUTQ&data=02%7C01%7C%7C00c7f56e3d8e4d81147608d800b81825%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637260137957636776&sdata=B5GeZRYFT8HG923uPgyHVSSBy1fYMqI%2BNdNtR3DGuUU%3D&reserved=0.

This window will display output from any programs that import win32traceutil

win32com servers registered with '--debug' are in this category.

Object with win32trace dispatcher created (object=None) Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(*args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: ERROR: server.policy could not create an instance.

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(*args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: Unexpected gateway error

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: CPyFactory::CreateInstance failed to create instance. (80004005) Object with win32trace dispatcher created (object=None) Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: ERROR: server.policy could not create an instance.

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(*args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: Unexpected gateway error

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: CPyFactory::CreateInstance failed to create instance. (80004005) Object with win32trace dispatcher created (object=None) Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: ERROR: server.policy could not create an instance.

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(*args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: Unexpected gateway error

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: CPyFactory::CreateInstance failed to create instance. (80004005) Object with win32trace dispatcher created (object=None) Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: ERROR: server.policy could not create an instance.

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(*args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: Unexpected gateway error

Traceback (most recent call last): File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 136, in CreateInstance return retObj.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 37, in CreateInstance return self.HandleException() File "C:\bin\MINICO~1\lib\site-packages\win32com\server\dispatcher.py", line 34, in CreateInstance self.policy.CreateInstance(clsid, reqIID) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 194, in CreateInstance myob = call_func(classSpec) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 728, in call_func return resolve_func(spec)(*args) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 717, in resolve_func module = _import_module(mname) File "C:\bin\MINICO~1\lib\site-packages\win32com\server\policy.py", line 736, in _import_module import(mname) File "C:\bin\rdkit4excel-master\src\RDKitXL_server.py", line 12, in import rdkit File "C:\bin\MINICO~1\lib\site-packages\rdkit__init.py", line 2, in from .rdBase import rdkitVersion as version__ ImportError: DLL load failed: The specified module could not be found. pythoncom error: CPyFactory::CreateInstance failed to create instance. (80004005)

stephencarino commented 4 years ago

Jan,

It’s the path settings. I basically copied the path in the Conda environment to the system path and got the addin to finally work.

Stephen

From: Stephen Carinomailto:stephen.carino@outlook.com Sent: Monday, May 25, 2020 10:56 AM To: janholstjensen/rdkit4excelmailto:reply@reply.github.com; janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: Authormailto:author@noreply.github.com Subject: RE: [janholstjensen/rdkit4excel] Problem installing (#3)

Jan,

Thanks again for trying to sort this out. For what it’s worth, I have attached the debug log from PythonWin.

Stephen

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Jan Holst Jensenmailto:notifications@github.com Sent: Monday, May 25, 2020 10:29 AM To: janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: stephencarinomailto:stephen.carino@outlook.com; Authormailto:author@noreply.github.com Subject: Re: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Stephen,

OK, the 64-bit Excel could be the issue here. It is not very common to have 64-bit Office, but of course we want it to work in 64-bit Office too!

Unfortunately I don't have an installation with 64-bit Excel at the moment. I am going to need it for other purposes soon anyway, so let me get that setup. It may be a couple of days before I can get back to you with more details - sorry.

Cheers -- Jan

On 2020-05-25 15:58, stephencarino wrote:

Jan,

Correction – Excel is 64-bit and I made the registry changes.

Stephen

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Stephen Carino stephen.carino@outlook.com Sent: Monday, May 25, 2020 12:03:13 AM To: janholstjensen/rdkit4excel reply@reply.github.com; janholstjensen/rdkit4excel rdkit4excel@noreply.github.com Cc: Author author@noreply.github.com Subject: RE: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Jan,

I appreciate you following up. I did actually tried VBA but wasn’t sure exactly how the object is initiated. Anyway, tried to run the code you suggested and it resulted to an error message as expected. Interestingly, I get the first error when the cursor is inside the sub and the 2nd error message when the cursor is outside and I get prompted which macro to run. Can you tell where the issue is based on these error messages?

I also captured the Miniconda installation. As you can see I have a 64bit Python. Excel is 32-bit so made the registry added per the instruction.

Thanks,

Stephen

[cid:image003.png@01D63227.E2270650]

[cid:image004.png@01D63226.292B7BF0]

[cid:image005.png@01D63226.4A6F1BF0]

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Jan Holst Jensenmailto:notifications@github.com Sent: Sunday, May 24, 2020 1:03 PM To: janholstjensen/rdkit4excelmailto:rdkit4excel@noreply.github.com Cc: stephencarinomailto:stephen.carino@outlook.com; Authormailto:author@noreply.github.com Subject: Re: [janholstjensen/rdkit4excel] Problem installing (#3)

Hi Stephen,

First of all, thanks for trying RDKit for Excel!

I would start by checking if the COM object can be loaded from Excel VBA. Try the following Sub:

Sub Test() Dim AddIn As Variant Set AddIn = CreateObject("Python.RDKitXL")

Dim VerString As String VerString = AddIn.rdkit_info_version() MsgBox VerString End Sub

It ought to fail with "ActiveX component can't create object", since you get #NAME? in Excel. If it succeeds, then things are interesting.

Is your Excel 32-bit or 64-bit - and likewise, is your Python 32- or 64-bit ?

Cheers -- Jan

On 2020-05-22 04:42, stephencarino wrote:

Hi,

I followed the installation instruction, set up the path, installed it in registry with no error and was able to register the addin in Excel. However, I still get #NAME? in Excel. What's the best way to troubleshoot this?

--Stephen

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fjanholstjensen%2Frdkit4excel%2Fissues%2F3%23issuecomment-633598944&data=02%7C01%7C%7C00c7f56e3d8e4d81147608d800b81825%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637260137957636776&sdata=kuYmIN03i7j9ElPlKVoBpBqnzK8mGCJRQwFu5kbFBqw%3D&reserved=0, or unsubscribehttps://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAPVT3X6MBESSEQIA6W44LGLRTJ6GFANCNFSM4NHNMUTQ&data=02%7C01%7C%7C00c7f56e3d8e4d81147608d800b81825%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637260137957636776&sdata=B5GeZRYFT8HG923uPgyHVSSBy1fYMqI%2BNdNtR3DGuUU%3D&reserved=0.