Got a credit card? use our Credit Card & Finance Calculators
Thanks to niord,gvonge,Shelford,GrahamPlatt,gpadsa, for Donating to support the site
Hyptuss Run time error
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Hyptuss Run time error
I've just tried to update dividend yields and got an error
Run time error ( lots of numbers)
An error occurred in the secure channel support.
I've tried it several times with same error.
Not sure which version ( not the very latest) ( how do i find the version number ?) but within the last 6 months or so
Was working before the digital look problems
Windows 7, Excel 2003
Rob
Run time error ( lots of numbers)
An error occurred in the secure channel support.
I've tried it several times with same error.
Not sure which version ( not the very latest) ( how do i find the version number ?) but within the last 6 months or so
Was working before the digital look problems
Windows 7, Excel 2003
Rob
-
- Lemon Quarter
- Posts: 4120
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3272 times
- Been thanked: 2859 times
Re: Hyptuss Run time error
robbelg wrote:I've just tried to update dividend yields and got an error
Run time error ( lots of numbers)
An error occurred in the secure channel support.
I've tried it several times with same error.
Not sure which version ( not the very latest) ( how do i find the version number ?) but within the last 6 months or so
Was working before the digital look problems
Windows 7, Excel 2003
Rob
When you say "update dividend yields", I guess you mean "update forecast yields"?
The runtime error.....what is the code in the error window (lots of numbers)
The version.... you can get this on the "Version History" sheet.
What happens if you download a fresh copy of HYPTUSS and run that without making any changes? If that works, it suggests that your copy has somehow got corrupted. Do you have a previous version of your copy in backup (you do make backups, don't you ) and does that work?
--kiloran
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Re: Hyptuss Run time error
yes i meant update forecast yields
error -2147012739 (80072fd)
Version 11.55
An earlier version gives the same error
It was working on Friday ( but with silly numbers as discussed elsewhere )
Rob
error -2147012739 (80072fd)
Version 11.55
An earlier version gives the same error
It was working on Friday ( but with silly numbers as discussed elsewhere )
Rob
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Hyptuss Run time error
robbelg wrote:
error -2147012739 (80072fd)
Version 11.55
An earlier version gives the same error
It was working on Friday
Can you try downloading the latest vanilla Excel version (11.69) using the link below, and try the yield-scrape with that version as it stands -
http://lemonfoolfinancialsoftware.weebly.com/hyp-top-up.html
This eliminates any potential local issue that you might have, as the above 11.69 vanilla release is working correctly to scrape the BP yield as at 2pm today.
In the above v11.69, the yield figure can be set to scrape the forecast (default) or the latest, and both work with no issues in the tests I've just carried out.
I'm on Windows 10, Office 2007.
Cheers,
Itsallaguess
-
- Lemon Quarter
- Posts: 4120
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3272 times
- Been thanked: 2859 times
Re: Hyptuss Run time error
robbelg wrote:V11.69 Same error so obviously its at my end.
Rob
Time to start clutching at straws...... have you rebooted your PC since you had the problem?
--kiloran
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Re: Hyptuss Run time error
Yes
Have just run CCleaner and am currently running AV scan ( and scratching my head - nothing has been updated recently )
Rob
Have just run CCleaner and am currently running AV scan ( and scratching my head - nothing has been updated recently )
Rob
-
- Lemon Quarter
- Posts: 3152
- Joined: November 4th, 2016, 11:12 am
- Has thanked: 3686 times
- Been thanked: 1529 times
Re: Hyptuss Run time error
robbelg wrote:Yes
Have just run CCleaner and am currently running AV scan ( and scratching my head - nothing has been updated recently )
Rob
Similar error reported here:
https://stackoverflow.com/questions/440 ... el-support
Goto Control Panel,
Click Network and Internet,
Click Network and Sharing Center, (at the Bottom Left CLICK Internet Options)
Internet Properties Dialog Box will come up, Click the Advanced Tab
Scroll to bottom and turn on "Use TLS1.2" (Mine was already Set Prior to receiving the Error) Click Apply
HTH
RC
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Re: Hyptuss Run time error
TLS1.2 was ticked
I've unticked it, ticked it again and applied
No change
My Googling took me to stackoverflow but I didn't spot that - well done even if it didn't help
My main problem is that i'm absolutely certain I haven't changed anything remotely like that ( or for that matter anything at all ) or updated anything since it was working
Rob
I've unticked it, ticked it again and applied
No change
My Googling took me to stackoverflow but I didn't spot that - well done even if it didn't help
My main problem is that i'm absolutely certain I haven't changed anything remotely like that ( or for that matter anything at all ) or updated anything since it was working
Rob
-
- Lemon Quarter
- Posts: 3152
- Joined: November 4th, 2016, 11:12 am
- Has thanked: 3686 times
- Been thanked: 1529 times
Re: Hyptuss Run time error
robbelg wrote:TLS1.2 was ticked
I've unticked it, ticked it again and applied
No change
My Googling took me to stackoverflow but I didn't spot that - well done even if it didn't help
My main problem is that i'm absolutely certain I haven't changed anything remotely like that ( or for that matter anything at all ) or updated anything since it was working
Rob
Can I suggest a system file check, just in case.
https://www.microcenter.com/tech_center ... -windows-7
RC
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Hyptuss Run time error
robbelg wrote:
V11.69 Same error so obviously its at my end.
Any recent Windows updates?
Can you also list your ticked references in the VBA section of Excel 2003 (Tools / References) - the password is 'pleaseletmein' if you're asked for it.
Cheers,
Itsallaguess
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Re: Hyptuss Run time error
No recent updates of any thing.
I'm now testing with the very latest V11.69 downloaded today and just as issued.
Rob
I'm now testing with the very latest V11.69 downloaded today and just as issued.
Rob
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Re: Hyptuss Run time error
I've got to go for the night
I may be back tomorrow
thanks for the help so far
I may be back tomorrow
thanks for the help so far
-
- Lemon Quarter
- Posts: 4120
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3272 times
- Been thanked: 2859 times
Re: Hyptuss Run time error
robbelg wrote:No recent updates of any thing.
I'm now testing with the very latest V11.69 downloaded today and just as issued.
Rob
Another couple of thoughts, Rob....
Open your HYPTUSS, then open the Visual Basic editor. Click on the + symbol to the left of the VBAProject(hyp_topup_spreadsheet) and enter the password pleasletmein.
Now try to update the forecast yields and when the error occurs, you should get a debug button. Click on that and you should see a line of code highlighted in yellow. Copy that line (and maybe a few above and below it) and post it to us.
Also try selecting a ticker in column C of the "High Yield Portfolio" sheet and click on the "Open DL Site" button. Does that take you to the relevant Sharecast page in your web browser?
--kiloran
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Re: Hyptuss Run time error
kiloran wrote:
Another couple of thoughts, Rob....
Open your HYPTUSS, then open the Visual Basic editor. Click on the + symbol to the left of the VBAProject(hyp_topup_spreadsheet) and enter the password pleasletmein.
Now try to update the forecast yields and when the error occurs, you should get a debug button. Click on that and you should see a line of code highlighted in yellow. Copy that line (and maybe a few above and below it) and post it to us.
Also try selecting a ticker in column C of the "High Yield Portfolio" sheet and click on the "Open DL Site" button. Does that take you to the relevant Sharecast page in your web browser?
--kiloran
How do I open the VB editor?
Open DL Site works OK.
Rob
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Hyptuss Run time error
robbelg wrote:
How do I open the VB editor?
Hi Rob,
Have a read of this -
You can access the VBA environment in Excel 2003 by opening the Microsoft Visual Basic window.
To open the Microsoft Visual Basic window, select Macro > Visual Basic Editor under the Tools menu. Or you can use Alt+F11 as the shortcut to quickly open the Visual Basic Editor.
https://www.techonthenet.com/excel/macros/visual_basic_editor2003.php
Cheers,
Itsallaguess
-
- Lemon Slice
- Posts: 410
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 188 times
- Been thanked: 157 times
Re: Hyptuss Run time error
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
Rob
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
Rob
-
- Lemon Quarter
- Posts: 4120
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3272 times
- Been thanked: 2859 times
Re: Hyptuss Run time error
robbelg wrote:kiloran wrote:
Open your HYPTUSS, then open the Visual Basic editor. Click on the + symbol to the left of the VBAProject(hyp_topup_spreadsheet) and enter the password pleasletmein.
--kiloran
How do I open the VB editor?
Open DL Site works OK.
Rob
OOPS!!!! Typo warning!
The password is pleaseletmein, not pleasletmein.
And I double-checked it before I submitted the post. Senility is clearly setting in
--kiloran
-
- 2 Lemon pips
- Posts: 162
- Joined: November 4th, 2016, 4:52 pm
- Has thanked: 179 times
- Been thanked: 15 times
Re: Hyptuss Run time error
Is Mucklow on your list?
It has been taken over and no longer appears in Digital Look.
Just a thought.
InStep
Edit: Sorry. Probably irrelevant if you're testing with BP only.
It has been taken over and no longer appears in Digital Look.
Just a thought.
InStep
Edit: Sorry. Probably irrelevant if you're testing with BP only.
Last edited by Instep on July 3rd, 2019, 5:13 pm, edited 1 time in total.
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 5 guests