innocuous wrote:Itsallaguess wrote:I've just downloaded a fresh copy of the XLA add-in from here -
http://lemonfoolfinancialsoftware.weebly.com/share-prices-in-excel.html
I've opened a new Excel workbook (Windows 10 / Office 2007), with the following VBA references set -
- Visual Basic For Applications
- Microsoft Excel 12.0 Object Library
- OLE Automation
- Microsoft Office 12.0 Object Library
I've then activated the downloaded add-in via Excel Options / Add-ins / Manage Excel Add-ins, and made sure that the .xla file is added to the add-in references and activated.
I've then entered 'VOD.L' into Cell E7, and in Cell G7, I've typed the formula '=getdata(E7)', and pressed return.
At first, Cell G7 contained the text '::queued::', but when I right-clicked the cell, I got the option to 'Refresh prices once', and when I selected that option, Cell G7 then refreshed to display the correct Vodafone price of 131.28p
Cheers,
Itsallaguess
Thanks for checking - I am going to try it again totally fresh. I will also try on another PC and see if that works or not. Back shortly with the results.
This is weird. So just used my standard work laptop win 10 build with Office 365 pro. Downloaded addin from your link; Activated addin in Excel; Shutdown Excel; Open new book and test VOD.L - ::tick_err:: then GOOG - :tick_Err::
I then edited the VB in fUtilities to make .StatusText <> 200 alteration. Test again. still get ::tick_err::
So on one PC where I do have admin ability and could have done stupide stuff to break underlying code bases required to make the addin work it is not functioning; but even on my corporate machine that is totally locked down; I also cant get it to work.