HillManMill wrote:I am trying to get the itsallaguess excel spreadsheet to work using excel 2010 32 bit version on win 10 pc.
I have enabled the tools > references> microsoft html object library as advised but nothing seems to be happening. I have tried adding my sample fund id to the end of the html string
e.g.
https://markets.ft.com/data/funds/tears ... 00B888FR33 and forming a hyperlink within excel and its opening the web page correctly.
Can anyone point me to resolving this one please?
Hi there,
It doesn't sound like you're quite following the process as described in my earlier post -
https://www.lemonfool.co.uk/viewtopic.php?f=27&t=19975#p258874I've just added the fund identity that you're wanting to use to the end of my original list (
GB00B888FR33) and everything works fine, as you can see in the two screen-shots linked below which show the process
before the VBA Command Button is pressed and then also
afterwards -
Before -
https://i.imgur.com/MzNGr2m.pngAfter -
https://i.imgur.com/bcLA7Z9.pngI'm not sure what you're doing differently to the process detailed in my earlier post, but when you discuss 'hyperlinks' as you do above, then my process doesn't actually need any 'hyperlinks' creating, so I suspect this is an area you might want to concentrate on initially.
So long as you've got the data in the first two columns as shown in my first screen-shot above, and then you've created a 'Command Button' (Active X Control), and then assigned the whole of the VBA routine as shown in my linked post earlier to the 'Command Button', then if you've got Macro's enabled and then press the 'Command Button', the process should work fine.
Do make sure that you're using all the VBA code listed, as there's a scroll-box with the code in, and you'll have to drag and scroll to select all the VBA code before you carry out a COPY/PASTE into the Excel VBA Editor. Here's a screenshot showing the whole VBA code that should be attached to the 'Command Button' -
https://i.imgur.com/HVQaeRM.pngIt sounds like iambic was able to follow my process and get things working, so hopefully starting from scratch again might give better results, but please do let me know if there's anything in there that's not as clear as it could be, and I'm more than happy to help out to get you going here.
Also, Merry Christmas!
Cheers,
Itsallaguess