Referring to dlls from within post-processing
My HP ALM excel report needs to look up som data in JIRA, so I am using these DLLs:
Private JiraService As New MSXML2.XMLHTTP60
Private JiraAuth As New MSXML2.XMLHTTP60
Of course, I have set theese up in my References section in Excel.
This works well from within an Excel sheet on my PC, but when I try to do the same within postprocessing in HP ALM, then It fails.
The basic question is: how can I use dll's from within my postprocessing?
BW Peter B. Hansen
What is the message you are receiving?
(Posts and opinions made here are my own and do not reflect the opinions of my employer)
If the remark about 32-bit vs 64-bit is true, there is little you can do about it.
But my understanding is that your VBA code does work when it is in a workbook of your own and does not work when it is in the workbook created by ALM.
In that case, you have to define all variables related to the MSXML2 library as Object, instead of As MSXML2.xxxx. For the objects that you declare or set as New, you need to use the CreateObject function. You can remove the references to the DLLs and debug that in the workbook that you use for debugging purpose. I recommand that you keep your old declaration and set statements as comments for your code to be more understandable.