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::innocuous wrote: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.Itsallaguess wrote: I've just downloaded a fresh copy of the XLA add-in from here -
http://lemonfoolfinancialsoftware.weebl ... excel.html
I've opened a new Excel workbook (Windows 10 / Office 2007), with the following VBA references set -
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.
- Visual Basic For Applications
- Microsoft Excel 12.0 Object Library
- OLE Automation
- Microsoft Office 12.0 Object Library
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
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.