Remove ads

Introducing the LemonFools Personal Finance Calculators

Hyptuss Run time error

Discussions regarding financial software
Itsallaguess
Lemon Quarter
Posts: 3672
Joined: November 4th, 2016, 1:16 pm
Has thanked: 1209 times
Been thanked: 2239 times

Re: Hyptuss Run time error

#233734

Postby Itsallaguess » July 3rd, 2019, 5:25 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#233762

Postby robbelg » July 3rd, 2019, 7:33 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#233907

Postby robbelg » July 4th, 2019, 12:07 pm

This is insane!!

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

Rob

kiloran
Lemon Quarter
Posts: 1907
Joined: November 4th, 2016, 9:24 am
Has thanked: 531 times
Been thanked: 849 times

Re: Hyptuss Run time error

#233913

Postby kiloran » July 4th, 2019, 12:39 pm

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

ReformedCharacter
Lemon Slice
Posts: 840
Joined: November 4th, 2016, 11:12 am
Has thanked: 374 times
Been thanked: 196 times

Re: Hyptuss Run time error

#233917

Postby ReformedCharacter » July 4th, 2019, 12:45 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#233929

Postby robbelg » July 4th, 2019, 1:10 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#233932

Postby robbelg » July 4th, 2019, 1:14 pm

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

kiloran
Lemon Quarter
Posts: 1907
Joined: November 4th, 2016, 9:24 am
Has thanked: 531 times
Been thanked: 849 times

Re: Hyptuss Run time error

#233937

Postby kiloran » July 4th, 2019, 1:22 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#233940

Postby robbelg » July 4th, 2019, 1:26 pm

I posted the code

its here

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

Rob

kiloran
Lemon Quarter
Posts: 1907
Joined: November 4th, 2016, 9:24 am
Has thanked: 531 times
Been thanked: 849 times

Re: Hyptuss Run time error

#233988

Postby kiloran » July 4th, 2019, 4:52 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#233996

Postby robbelg » July 4th, 2019, 5:23 pm

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

Itsallaguess
Lemon Quarter
Posts: 3672
Joined: November 4th, 2016, 1:16 pm
Has thanked: 1209 times
Been thanked: 2239 times

Re: Hyptuss Run time error

#234002

Postby Itsallaguess » July 4th, 2019, 5:49 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#234014

Postby robbelg » July 4th, 2019, 6:46 pm

Yes Yes Yes

It works


Thank you, Thank you

Rob

Itsallaguess
Lemon Quarter
Posts: 3672
Joined: November 4th, 2016, 1:16 pm
Has thanked: 1209 times
Been thanked: 2239 times

Re: Hyptuss Run time error

#234022

Postby Itsallaguess » July 4th, 2019, 7:41 pm

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

ReformedCharacter
Lemon Slice
Posts: 840
Joined: November 4th, 2016, 11:12 am
Has thanked: 374 times
Been thanked: 196 times

Re: Hyptuss Run time error

#234024

Postby ReformedCharacter » July 4th, 2019, 7:56 pm

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

kiloran
Lemon Quarter
Posts: 1907
Joined: November 4th, 2016, 9:24 am
Has thanked: 531 times
Been thanked: 849 times

Re: Hyptuss Run time error

#234030

Postby kiloran » July 4th, 2019, 8:12 pm

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

robbelg
2 Lemon pips
Posts: 243
Joined: November 4th, 2016, 10:43 am
Has thanked: 78 times
Been thanked: 70 times

Re: Hyptuss Run time error

#234148

Postby robbelg » July 5th, 2019, 11:13 am

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

seagles
Lemon Pip
Posts: 54
Joined: August 19th, 2017, 8:37 am
Has thanked: 32 times
Been thanked: 20 times

Re: Hyptuss Run time error

#234152

Postby seagles » July 5th, 2019, 11:33 am

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:

Ma1co1m
Posts: 6
Joined: November 5th, 2016, 11:14 pm
Been thanked: 2 times

Re: Hyptuss Run time error

#235460

Postby Ma1co1m » July 10th, 2019, 9:12 am

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

kiloran
Lemon Quarter
Posts: 1907
Joined: November 4th, 2016, 9:24 am
Has thanked: 531 times
Been thanked: 849 times

Re: Hyptuss Run time error

#235479

Postby kiloran » July 10th, 2019, 10:09 am

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


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests