HYPTUSS: which versions of Windows and Excel
-
- Lemon Slice
- Posts: 424
- Joined: November 4th, 2016, 1:56 pm
HYPTUSS: which versions of Windows and Excel
Older versions of HYPTUSS (11-4) worked for me on XP and Excel 2000, but I'm struggling with version 11-53*. Has anybody else managed this successfully or am I now obsolete?
*Error message:
Run-time error '-2146893018 (80090326)':
The message received was unexpected or badly formatted.
*Error message:
Run-time error '-2146893018 (80090326)':
The message received was unexpected or badly formatted.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUSS: which versions of Windows and Excel
I've no ability to test XP or Excel 2000, but it would help enormously if you told us what you were doing when you got this error.MyNameIsUrl wrote:Older versions of HYPTUSS (11-4) worked for me on XP and Excel 2000, but I'm struggling with version 11-53*. Has anybody else managed this successfully or am I now obsolete?
*Error message:
Run-time error '-2146893018 (80090326)':
The message received was unexpected or badly formatted.
Do you get the error with a fresh download of 11.53 before you add any shares?
--kiloran
-
- Lemon Slice
- Posts: 424
- Joined: November 4th, 2016, 1:56 pm
Re: HYPTUSS: which versions of Windows and Excel
Yes it was a fresh download - I did the minimum amount of fiddling: saved a copy of the spreadsheet, clicked 'Get Yahoo Prices', then got the error message.kiloran wrote: I've no ability to test XP or Excel 2000, but it would help enormously if you told us what you were doing when you got this error.
Do you get the error with a fresh download of 11.53 before you add any shares?
--kiloran
I should mention that 'Single Chart', 'Add Share', and 'Delete Share' all work, so the macro is working.
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
I have, but it will take a while to get the system running again. It's an old XP laptop with a broken socket for the charger, so I'll have to charge its battery in another laptop before I can run it - I'll get back to you in an hour or so.kiloran wrote:I've no ability to test XP or Excel 2000...
In the mean time, I can confirm that for a fresh download of 11.53 there are no errors for 'Get Yahoo Prices' with Windows 7 / Excel 2000.
-
- Lemon Quarter
- Posts: 1186
- Joined: November 8th, 2016, 2:20 am
Re: HYPTUSS: which versions of Windows and Excel
I just checked for you in Excel 2000 and no error message but the machine OS is Windows 10. Also Money AM charts work OK.MyNameIsUrl wrote:Yes it was a fresh download - I did the minimum amount of fiddling: saved a copy of the spreadsheet, clicked 'Get Yahoo Prices', then got the error message.kiloran wrote: I've no ability to test XP or Excel 2000, but it would help enormously if you told us what you were doing when you got this error.
Do you get the error with a fresh download of 11.53 before you add any shares?
--kiloran
I should mention that 'Single Chart', 'Add Share', and 'Delete Share' all work, so the macro is working.
My Excel 2000 version showing in help menu-about is 9.0.6926 SP-3.
-
- Lemon Slice
- Posts: 424
- Joined: November 4th, 2016, 1:56 pm
Re: HYPTUSS: which versions of Windows and Excel
Thanks for that confirmation. I would like to say that if HYPTUSS does not work with my configuration, I wouldn't expect any development to be done to make it work. I would accept that my old machine doesn't cope with it - but of course I would like to check that the errors aren't unrelated, hence my question.supremetwo wrote: I just checked for you in Excel 2000 and no error message but the machine OS is Windows 10. Also Money AM charts work OK.
My Excel 2000 version showing in help menu-about is 9.0.6926 SP-3.
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
25% charged now, just enough for a quick test. For a fresh download of 11.53 'Get Yahoo Prices' with Windows XP / Excel 2000 gives:Breelander wrote:... I'll have to charge its battery in another laptop before I can run it - I'll get back to you in an hour or so.
Microsoft Visual Basic
Compile error in hidden module: Sheet 1
(battery back on charge now)
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUSS: which versions of Windows and Excel
Thanks Bree.Breelander wrote:Breelander wrote:... I'll have to charge its battery in another laptop before I can run it - I'll get back to you in an hour or so.
What happens if you enable the VB password (pleaseletmein) and then run Get Yahoo Prices?
Which bit if the VBA code is highlighted?
--kiloran
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
Tried it and got in, but battery was flat before I had a chance to note down the code, will get back to you after recharging...kiloran wrote: What happens if you enable the VB password (pleaseletmein) and then run Get Yahoo Prices?
Which bit if the VBA code is highlighted?
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
While we wait for the battery to recharge, it's probably worth noting that the XP machine is running the initial release of Office 2000 with no updates installed while the (working) Office 2000 on the Win7 machine has been updated to Office 2000 SP3.
Updating Office 2000 is problematic. While the service packs for O2k are still available from Microsoft, a prerequisite is that Service Release 1 is first installed (O2KSR1aDL.EXE). This is no longer available from Microsoft, I had to search for a 3rd-party site that still held a copy (do so at your own risk).
Updating Office 2000 is problematic. While the service packs for O2k are still available from Microsoft, a prerequisite is that Service Release 1 is first installed (O2KSR1aDL.EXE). This is no longer available from Microsoft, I had to search for a 3rd-party site that still held a copy (do so at your own risk).
-
- Lemon Quarter
- Posts: 1186
- Joined: November 8th, 2016, 2:20 am
Re: HYPTUSS: which versions of Windows and Excel
From Bree's last post, I reckon we will find that you need the 2000 update to SP3 and that the OS is probably not the issue.MyNameIsUrl wrote:Thanks for that confirmation. I would like to say that if HYPTUSS does not work with my configuration, I wouldn't expect any development to be done to make it work. I would accept that my old machine doesn't cope with it - but of course I would like to check that the errors aren't unrelated, hence my question.supremetwo wrote: I just checked for you in Excel 2000 and no error message but the machine OS is Windows 10. Also Money AM charts work OK.
My Excel 2000 version showing in help menu-about is 9.0.6926 SP-3.
Which Excel version is showing on yours?
-
- Lemon Slice
- Posts: 424
- Joined: November 4th, 2016, 1:56 pm
Re: HYPTUSS: which versions of Windows and Excel
Help - About:supremetwo wrote: From Bree's last post, I reckon we will find that you need the 2000 update to SP3 and that the OS is probably not the issue.
Which Excel version is showing on yours?
Excel 2000 9.0.2720
System Information:
Application name Microsoft Excel
Version 9.0
Build 2719
My Computer - Properties:
Microsoft Windows XP
Home Edition
Version 2002
Service Pack 3
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
Compare your version number with this archived Microsoft Support page, it will help you determine which (if any) updates are installed.supremetwo wrote:Which Excel version is showing on yours?
https://web.archive.org/web/20041020144 ... /kb/255275
Edit: I see you have posted...
That is the initial release with no updates installed.Help - About:
Excel 2000 9.0.2720
-
- Lemon Half
- Posts: 8675
- Joined: November 4th, 2016, 1:16 pm
Re: HYPTUSS: which versions of Windows and Excel
Just logged on and seen this thread, so apologies for being a bit late to the party.MyNameIsUrl wrote:
Older versions of HYPTUSS (11-4) worked for me on XP and Excel 2000, but I'm struggling with version 11-53*. Has anybody else managed this successfully or am I now obsolete?
*Error message:
Run-time error '-2146893018 (80090326)':
The message received was unexpected or badly formatted.
There's been an issue for some weeks with the XP functionality, and I don't think we're likely to get it back. I saw this issue just after Christmas on my XP box, and it was also reported here in this thread by smokey01 -
https://www.lemonfool.co.uk/viewtopic.p ... 2&p=111353
As discussed in that thread, I spent some time trying to get it to work with no luck, and came to the conclusion that it's something to do with the XP HTTP/HTTPS calls from Excel, and I suspect we'd have to get into some dirty butchering of DLL's if we thought it was a worthwhile exercise.
Unfortunately, I don't think it is, especially given the really small number of posters that seem to still be using XP. I should say that I was one of them until shortly after Christmas, and this episode alone was enough for me to finally migrate myself from my old XP workhorse to my new shiny I5 DeskMini (https://www.amazon.co.uk/Rock-Desk-110- ... B01GSWJ3JM) running first Windows 7, and then a swift skip into Windows 10.
I hope you understand that there comes a period where it's uneconomical to spend a huge amount of time trying to patch things up and keep the XP support going, but I think it's time that we concentrated our efforts on maintaining the more mainstream user-base.
Cheers,
Itsallaguess
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
Battery has a full charge now. While I was waiting I tested the base-level install of Excel 2000 9.0.2720 on Windows 7. It works without error.kiloran wrote:What happens if you enable the VB password (pleaseletmein) and then run Get Yahoo Prices?
Which bit if the VBA code is highlighted?
Back to XP - signed in with the password, I now get:
"Compile error: Can't find project or library"
It stops at 'CommandButton1, Click, Ln133, Col 27'. The line...
share_price = Left(dict(ticker), InStr(1, dict(ticker), "|") - 1)
...has the word 'Left' highlighted.
-
- Lemon Slice
- Posts: 424
- Joined: November 4th, 2016, 1:56 pm
Re: HYPTUSS: which versions of Windows and Excel
Yes, of course, I agree completely, and I made the point earlier that I wouldn't want to trigger any development work for this issue. My question was always about confirming the issue really was related to the old systems rather than something I'd done wrong.Itsallaguess wrote: I hope you understand that there comes a period where it's uneconomical to spend a huge amount of time trying to patch things up and keep the XP support going, but I think it's time that we concentrated our efforts on maintaining the more mainstream user-base.
Like many others, I'm grateful for the effort that's been put in to provide this tool, and I have found it very useful. Maybe I too should ditch XP!
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
...or if you have to keep using XP, try LibreOffice 5 (or earlier) and the OpenOffice/LibreOffice version of the spreadsheet.MyNameIsUrl wrote:...Maybe I too should ditch XP!
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: HYPTUSS: which versions of Windows and Excel
As a side note, if you want to update Office 2000, I've found a more trustworthy source for the SR-1 update. This is about as close to an official Microsoft download of SR-1 as you can get now, it's been archived direct from Microsoft in the Wayback Machine. Go to...Breelander wrote:Updating Office 2000 is problematic. While the service packs for O2k are still available from Microsoft, a prerequisite is that Service Release 1 is first installed (O2KSR1aDL.EXE). This is no longer available from Microsoft, I had to search for a 3rd-party site that still held a copy (do so at your own risk).
https://web.archive.org/web/20070203054 ... tm#o2sr1au
...and download:
Office 2000 SR-1 administrator updates — updated May 12, 2000 - O2ksr1adl.exe
You will download O2KSR1aDL.EXE. Run this to extract the setup files needed to install Office 2000 Service Release 1. With SR-1 installed you can then install the service packs which are still available to download from Microsoft, SP3 was the latest, it's here...
https://www.microsoft.com/en-gb/downloa ... .aspx?id=8