7 Messages
Digest #4112
Messages
Sat Aug 5, 2017 11:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what's going on for you. When I initially released the add-in,
many years ago, it used XML 6. However, a lot of people were on older
operating systems and didn't have XML 6, so I dialed it back to XML 3 and
it's been there since.
I just checked my version of the add-in and the reference is for the XML
version 3 library.
I'm pretty sure no version of DOMDocument is used in the add-in.
On Fri, Aug 4, 2017 at 6:44 AM, MRothaus@
...
wrote:
>
> 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
>
>
>
many years ago, it used XML 6. However, a lot of people were on older
operating systems and didn't have XML 6, so I dialed it back to XML 3 and
it's been there since.
I just checked my version of the add-in and the reference is for the XML
version 3 library.
I'm pretty sure no version of DOMDocument is used in the add-in.
On Fri, Aug 4, 2017 at 6:44 AM, MRothaus@
...
wrote:
>
> 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/
>
>
>
Sat Aug 5, 2017 2:10 pm (PDT) . Posted by:
mrothaus
On a vanilla Windows 10 with Excel 2013, when I install smf add-in and open my spreadsheet, I get a "compile error" because I have it go get the quotes when I open the spreadsheet.
Specifically, in module modUtilies, Function RCHGetURLData1
"Dim oHTTP As New XMLHTTP"
I then have to use task manager to kill the process since I couldn't cancel my way out of it.
Adding a reference to Microsoft XML v3 solves the problem. Take a look at the URL at social.technet.microsoft that I included in my previous post.
Specifically, in module modUtilies, Function RCHGetURLData1
"Dim oHTTP As New XMLHTTP"
I then have to use task manager to kill the process since I couldn't cancel my way out of it.
Adding a reference to Microsoft XML v3 solves the problem. Take a look at the URL at social.technet.
Sat Aug 5, 2017 3:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What I'm saying is that I CANNOT add a reference to XML v3 -- because one
already exists.
I have no idea why it doesn't exist when you install it.
And you shouldn't need to use Task Manager to cancel out of EXCEL because
you get a message about a compile error.
Sorry, but none of the symptoms you're giving me make any sense to me.
I don't see how the URL you cited is meaningful, since the add-in doesn't
use XML v6 or DOMDocument.
On Sat, Aug 5, 2017 at 2:10 PM, MRothaus@
...
wrote:
>
> On a vanilla Windows 10 with Excel 2013, when I install smf add-in and
> open my spreadsheet, I get a "compile error" because I have it go get the
> quotes when I open the spreadsheet.
>
> Specifically, in module modUtilies, Function RCHGetURLData1
>
> "Dim oHTTP As New XMLHTTP"
>
> I then have to use task manager to kill the process since I couldn't
> cancel my way out of it.
>
> Adding a reference to Microsoft XML v3 solves the problem. Take a look at
> the URL at social.technet.microsoft that I included in my previous post.
>
already exists.
I have no idea why it doesn't exist when you install it.
And you shouldn'
you get a message about a compile error.
Sorry, but none of the symptoms you're giving me make any sense to me.
I don't see how the URL you cited is meaningful, since the add-in doesn't
use XML v6 or DOMDocument.
On Sat, Aug 5, 2017 at 2:10 PM, MRothaus@
...
wrote:
>
> On a vanilla Windows 10 with Excel 2013, when I install smf add-in and
> open my spreadsheet, I get a "compile error" because I have it go get the
> quotes when I open the spreadsheet.
>
> Specifically, in module modUtilies, Function RCHGetURLData1
>
> "Dim oHTTP As New XMLHTTP"
>
> I then have to use task manager to kill the process since I couldn't
> cancel my way out of it.
>
> Adding a reference to Microsoft XML v3 solves the problem. Take a look at
> the URL at social.technet.
>
Sat Aug 5, 2017 11:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Have you tried the "By HTML Tag" or "By Cascading Value" worksheets of
the SMF-Quick-Webpage-Examination.xls workbook? You may see patterns that
help find the problem.
On Fri, Aug 4, 2017 at 12:11 PM, buckleca@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> 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.
>
>
the SMF-Quick-Webpage-Examination.xls workbook? You may see patterns that
help find the problem.
On Fri, Aug 4, 2017 at 12:11 PM, buckleca@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> 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.
>
>
Sat Aug 5, 2017 5:05 pm (PDT) . Posted by:
buckleca
I don't think I can use the Cascading Value one because the only way it's working is with I/E.
However, "By HTML Tag" works because I can add the "1" at the end of the formula. The results are basically the same: works sometimes and returns all errors on other recalcs.
I was watching the cookie folder and I noticed that it creates different cookie files on each calculation (opens/deletes), so I'm wondering if there's something happening with the cookies.
It's probably time to throw in the towel. I think I can get most of what I want from MorningStar. That question is for another thread.
Thanks for all the suggestions.
However, "By HTML Tag" works because I can add the "1" at the end of the formula. The results are basically the same: works sometimes and returns all errors on other recalcs.
I was watching the cookie folder and I noticed that it creates different cookie files on each calculation (opens/deletes)
It's probably time to throw in the towel. I think I can get most of what I want from MorningStar. That question is for another thread.
Thanks for all the suggestions.
Sat Aug 5, 2017 2:37 pm (PDT) . Posted by:
lefthand43
I'm having trouble with the add-in. The excel file no longer returns values and I get #VALUE! instead.
I think I've followed all the steps..
1. I have the latest xla in C: SMF Add-in
2. There was no blocking on the xla file properties
3. =RCHGetElementNumber("Version") is replaced with...
Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in; Windows (32-bit) NT 6.01; 12.0; ; ; 1)
Other than checking the version, is there some command string that I can insert that will tell if this is working?
These don't do anything; no error, nothing: (it's an example from RCHGetYahooHistory-Function.html)
=RCHGetYahooHistory("IBM")
=smfPricesByDates("IBM", "1/1/2007";)
I think I've followed all the steps..
1. I have the latest xla in C: SMF Add-in
2. There was no blocking on the xla file properties
3. =RCHGetElementNumbe
Stock Market Functions add-in, Version 2.1.2017.05.
Other than checking the version, is there some command string that I can insert that will tell if this is working?
These don't do anything; no error, nothing: (it's an example from RCHGetYahooHistory-
=RCHGetYahooHistory
=smfPricesByDates(
Sat Aug 5, 2017 3:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The 2017.05.03 version of the add-in doesn't have updates for the changes
Yahoo made to their Historical quotes. You'd need the 2017.07.13 beta
version to get that data. Those Yahoo changes have been a major source of
messages on the Yahoo group for the past few months.
On Sat, Aug 5, 2017 at 2:37 PM, lefthand43@
...
wrote:
>
> I'm having trouble with the add-in. The excel file no longer returns
> values and I get #VALUE! instead.
>
> I think I've followed all the steps..
> 1. I have the latest xla in C: SMF Add-in
> 2. There was no blocking on the xla file properties
> 3. =RCHGetElementNumber("Version") is replaced with...
> Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in;
> Windows (32-bit) NT 6.01; 12.0; ; ; 1)
>
> Other than checking the version, is there some command string that I can
> insert that will tell if this is working?
> These don't do anything; no error, nothing: (it's an example from
> *RCHGetYahooHistory-Function.html)*
> =RCHGetYahooHistory("IBM")
> =smfPricesByDates("IBM", "1/1/2007";)
>
>
>
Yahoo made to their Historical quotes. You'd need the 2017.07.13 beta
version to get that data. Those Yahoo changes have been a major source of
messages on the Yahoo group for the past few months.
On Sat, Aug 5, 2017 at 2:37 PM, lefthand43@
...
wrote:
>
> I'm having trouble with the add-in. The excel file no longer returns
> values and I get #VALUE! instead.
>
> I think I've followed all the steps..
> 1. I have the latest xla in C: SMF Add-in
> 2. There was no blocking on the xla file properties
> 3. =RCHGetElementNumbe
> Stock Market Functions add-in, Version 2.1.2017.05.
> Windows (32-bit) NT 6.01; 12.0; ; ; 1)
>
> Other than checking the version, is there some command string that I can
> insert that will tell if this is working?
> These don't do anything; no error, nothing: (it's an example from
> *RCHGetYahooHistory
> =RCHGetYahooHistory
> =smfPricesByDates(
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar