Page 2 of 3

Re: Hyptuss Run time error

Posted: July 3rd, 2019, 5:25 pm
by Itsallaguess
robbelg wrote:
I'm testing with a newly downloaded version with just BP


Now you've got access to the VBA editor, can you please do this bit -

Can you also list your ticked references in the VBA section of Excel 2003 (Tools / References)

https://www.lemonfool.co.uk/viewtopic.php?f=27&t=18337#p233476

Cheers,

Itsallaguess

Re: Hyptuss Run time error

Posted: July 3rd, 2019, 7:33 pm
by robbelg
VB for applications
MS Excel 11.0 Object Lib
OLE automation
MS office 11.0 Object library
MS Forms 2.0 Object library
MS HTML OL
MS Internet Controls
MS XML v6.0

Rob

Re: Hyptuss Run time error

Posted: July 4th, 2019, 12:07 pm
by robbelg
This is insane!!

I've just started up my spare laptop, downloaded the latest HYPTUSS and I'm getting the same error !

Rob

Re: Hyptuss Run time error

Posted: July 4th, 2019, 12:39 pm
by kiloran
robbelg wrote:This is insane!!

I've just started up my spare laptop, downloaded the latest HYPTUSS and I'm getting the same error !

Rob


Perhaps it's this piece of code causing the problem:

if user = 'robbelg' and subscriptionPaid = false then
collapseInAnUngainlyHeap
endif

--kiloran

Re: Hyptuss Run time error

Posted: July 4th, 2019, 12:45 pm
by ReformedCharacter
robbelg wrote:This is insane!!

I've just started up my spare laptop, downloaded the latest HYPTUSS and I'm getting the same error !

Rob

Try rebooting your router, it's a bit of a long-shot but won't take long :)

RC

Re: Hyptuss Run time error

Posted: July 4th, 2019, 1:10 pm
by robbelg
ReformedCharacter wrote:Try rebooting your router, it's a bit of a long-shot but won't take long :)

RC


I have, twice since this started

Rob

Re: Hyptuss Run time error

Posted: July 4th, 2019, 1:14 pm
by robbelg
kiloran wrote:
Perhaps it's this piece of code causing the problem:

if user = 'robbelg' and subscriptionPaid = false then
collapseInAnUngainlyHeap
endif

--kiloran


I did subscribe - thinking about it its long since expired.
Maybe there should be a renewal notice.

Rob

Re: Hyptuss Run time error

Posted: July 4th, 2019, 1:22 pm
by kiloran
robbelg wrote:
kiloran wrote:
Perhaps it's this piece of code causing the problem:

if user = 'robbelg' and subscriptionPaid = false then
collapseInAnUngainlyHeap
endif

--kiloran

I did subscribe - thinking about it its long since expired.
Maybe there should be a renewal notice.

Rob

Renewals are now VERY expensive....... at least 5 thanks for Itsallaguess posts.

Any progress running HYPTUSS with the VB editor open so that we can find the bit of code that's causing the problem?

By the way, your VB references seem OK. Two (hopefully minor) differences...

MS Excel 11.0 Object Lib...... I have 14.0
MS office 11.0 Object library...I have 14.0

I suspect this is because I have Excel 2010.

--kiloran

Re: Hyptuss Run time error

Posted: July 4th, 2019, 1:26 pm
by robbelg
I posted the code

its here

viewtopic.php?f=27&t=18337#p233723

Rob

Re: Hyptuss Run time error

Posted: July 4th, 2019, 4:52 pm
by kiloran
robbelg wrote:I posted the code

its here

viewtopic.php?f=27&t=18337#p233723

Rob

Oops! Sorry Rob, I missed that.

That bit of code is pretty much what we use elsewhere, to get prices from Yahoo, for example, which I believe works for you, so it's a bit odd that it's failing for you on the forecast yields

I'll go and scratch my head a bit. I've got one or two ideas

--kiloran

Re: Hyptuss Run time error

Posted: July 4th, 2019, 5:23 pm
by robbelg
I had wondered if Digital Look/Sharecast have changed something as part of fixing their forecast problems,its exactly the right timing, but nobody else has said "Me Too"
But maybe no one else has such old software?

Rob

Re: Hyptuss Run time error

Posted: July 4th, 2019, 5:49 pm
by Itsallaguess
robbelg wrote:
This is the code with the error

The precise error line is .send

' Open the Digital Look website for the relevant share, and then scrape the data
myUrl = "https://uk.webfg.com" + CStr(csi)
With oXMLHTTP
.Open "GET", myUrl, False
.send
End With

html.body.innerHTML = oXMLHTTP.responseText


Can you try changing the myURL line to this -

myUrl = "https://www.sharecast.com" + CStr(csi)

and give that a go to see if it helps?

I've just tried it on the vanilla download and it works fine for me with the above modification.

Cheers,

Itsallaguess

Re: Hyptuss Run time error

Posted: July 4th, 2019, 6:46 pm
by robbelg
Yes Yes Yes

It works


Thank you, Thank you

Rob

Re: Hyptuss Run time error

Posted: July 4th, 2019, 7:41 pm
by Itsallaguess
robbelg wrote:
Yes Yes Yes

It works

Thank you, Thank you


Great news, thanks for perservering with this Rob - these are niggly little buggers to pin down sometimes.

It looks like the old webfg re-direct isn't working as well as it's done until now, and the sharecast URL that you've now got working can probably be maintained in the vanilla versions from now on, but we'll have to do some further testing first, I imagine.

A good start to the weekend, at least...

Cheers,

Itsallaguess

Re: Hyptuss Run time error

Posted: July 4th, 2019, 7:56 pm
by ReformedCharacter
I think Itsallaguess and Kiloran deserve thanks and probably some kind of award for providing HYPTUSS, keeping it going and providing the support they do. I can imagine the time and effort it takes is not inconsiderable. Thank you both.

RC

Re: Hyptuss Run time error

Posted: July 4th, 2019, 8:12 pm
by kiloran
Itsallaguess wrote:
robbelg wrote:
Yes Yes Yes

It works

Thank you, Thank you


Great news, thanks for perservering with this Rob - these are niggly little buggers to pin down sometimes.

It looks like the old webfg re-direct isn't working as well as it's done until now, and the sharecast URL that you've now got working can probably be maintained in the vanilla versions from now on, but we'll have to do some further testing first, I imagine.

A good start to the weekend, at least...

Cheers,

Itsallaguess

Good news indeed, but I'm still somewhat mystified why the redirect used to work for Rob and now doesn't, even though the redirect works with a web browser. Very odd.

Rob, I assume you are happy with this change you made, rather than need an updated official copy?

Anyway, I've added it to my to-do list to ensure it's included on the next update.

--kiloran

Re: Hyptuss Run time error

Posted: July 5th, 2019, 11:13 am
by robbelg
kiloran wrote:
Good news indeed, but I'm still somewhat mystified why the redirect used to work for Rob and now doesn't, even though the redirect works with a web browser. Very odd.

Rob, I assume you are happy with this change you made, rather than need an updated official copy?

Anyway, I've added it to my to-do list to ensure it's included on the next update.

--kiloran


Yes I'm happy (very)

I'm still totally baffled that I seem to be the only one with this problem !!

Once again thank you to kiloran and Itsallaguess.


Rob

Re: Hyptuss Run time error

Posted: July 5th, 2019, 11:33 am
by seagles
robbelg wrote:
kiloran wrote:
Good news indeed, but I'm still somewhat mystified why the redirect used to work for Rob and now doesn't, even though the redirect works with a web browser. Very odd.

Rob, I assume you are happy with this change you made, rather than need an updated official copy?

Anyway, I've added it to my to-do list to ensure it's included on the next update.

--kiloran


Yes I'm happy (very)

I'm still totally baffled that I seem to be the only one with this problem !!

Once again thank you to kiloran and Itsallaguess.


Rob


I had a "unique" problem with HYPTUSS a while back. Mine was that the browser I was using did not support the latest SSL that was used by a site that HYPTUSS used for dividend source, we tried loads of things to try to get around it but eventually gave up and used a different source. Now problem resolved as new laptop running windows 10. I bet it is something unique with your set-up, nice to be different occasinally. :lol:

Re: Hyptuss Run time error

Posted: July 10th, 2019, 9:12 am
by Ma1co1m
Just to let you know, Rob isn't the only one with this problem - I tried to get the Forecast Yields this morning for the first time this month and got the same error, so there may be others out there too.
( I'm using v11_54 on Windows 7 )

ma1co1m

Re: Hyptuss Run time error

Posted: July 10th, 2019, 10:09 am
by kiloran
Ma1co1m wrote:Just to let you know, Rob isn't the only one with this problem - I tried to get the Forecast Yields this morning for the first time this month and got the same error, so there may be others out there too.
( I'm using v11_54 on Windows 7 )

ma1co1m

What version of Excel do you have?

Did you manage to fix it with the solution provided by Itsallaguess: viewtopic.php?p=235460#p234002

--kiloran