2 Messages
Digest #4111
Messages
Fri Aug 4, 2017 6:44 am (PDT) . Posted by:
mrothaus
I just upgraded to a new computer with Windows 10 and Office 2013. I was using Windows 7 with Office 2010, and the add-in worked perfectly there.
When I first fired up my spreadsheet, after installing the add-in successfully, I got the exact same error message as the user who first posted above: "Compile Error: User Defined type not defined in the modUtilities module, RCHGetURLData1 function on the line Dim oHTTP As New XMLHTTP"
After some googling, and before I came to this group, I found that I needed to add a reference to Microsoft XML (v3.0) (in the add-in editor, clicking on "Tools -> Reference" and choosing it). I tried XML v6 first, but that didn't work. Once I added XML v3, everything worked (I didn't need Object Library or Internet Controls).
Some users suggested changing DOMDocument to DOMDocument60 explicitly, but I don't know where to make the change. The reason this would be preferable is that XML v3 is getting old and may have security issues. Has anybody done that and can walk me through the steps to get the add-in to work without XML v3?
An excellent thread on the topic is here (explains the history of the problem):
https://social.technet.microsoft.com/Forums/en-US/f9180e5c-7c2f-44be-8415-d0d2b76e3f7f/microsoft-xml-v60-msxml6dll-and-vba https://social.technet.microsoft.com/Forums/en-US/f9180e5c-7c2f-44be-8415-d0d2b76e3f7f/microsoft-xml-v60-msxml6dll-and-vba
When I first fired up my spreadsheet, after installing the add-in successfully, I got the exact same error message as the user who first posted above: "Compile Error: User Defined type not defined in the modUtilities module, RCHGetURLData1 function on the line Dim oHTTP As New XMLHTTP"
After some googling, and before I came to this group, I found that I needed to add a reference to Microsoft XML (v3.0) (in the add-in editor, clicking on "Tools -> Reference" and choosing it). I tried XML v6 first, but that didn't work. Once I added XML v3, everything worked (I didn't need Object Library or Internet Controls).
Some users suggested changing DOMDocument to DOMDocument60 explicitly, but I don't know where to make the change. The reason this would be preferable is that XML v3 is getting old and may have security issues. Has anybody done that and can walk me through the steps to get the add-in to work without XML v3?
An excellent thread on the topic is here (explains the history of the problem):
https://social.technet.microsoft.com/Forums/en-US/f9180e5c-7c2f-44be-8415-d0d2b76e3f7f/microsoft-xml-v60-msxml6dll-and-vba https://social.technet.microsoft.com/Forums/en-US/f9180e5c-7c2f-44be-8415-d0d2b76e3f7f/microsoft-xml-v60-msxml6dll-and-vba
Fri Aug 4, 2017 12:11 pm (PDT) . Posted by:
buckleca
Trying to debug and see why I sometimes get the error.
In smfGetTagContent :
ipos1 = InStr(ipos1 + 1, sData2, UCase(pFind1))
Sometimes ipos1 returns 0 and this is when I get an error.
In debug I'm leaving the IE window open and it's always a good page.
When it works or fails - sData1 and sData2 always return the same string. This is part of the code I don't really understand and don't see how ipos1 can be equal to a positive number through numerous loops and suddenly fail on one loop and equal 0.
Each time the activation is through the force recalc macro.
I can understand that it's probably hard for you to support this issue through the group forum and I can try writing something outside of your add-in.
I appreciate you providing all the code and it's not only a great tool, it's also a fantastic learning tool.
Many thanks.
In smfGetTagContent :
ipos1 = InStr(ipos1 + 1, sData2, UCase(pFind1)
Sometimes ipos1 returns 0 and this is when I get an error.
In debug I'm leaving the IE window open and it's always a good page.
When it works or fails - sData1 and sData2 always return the same string. This is part of the code I don't really understand and don't see how ipos1 can be equal to a positive number through numerous loops and suddenly fail on one loop and equal 0.
Each time the activation is through the force recalc macro.
I can understand that it's probably hard for you to support this issue through the group forum and I can try writing something outside of your add-in.
I appreciate you providing all the code and it's not only a great tool, it's also a fantastic learning tool.
Many thanks.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar