eventide wrote:funduffer wrote:An old thread, but a new problem for me:
I have purchased a new laptop, with Office 365, transferring my excel files to the new device.
I have a few key spreadsheets that use the tlfAddin to download stock prices.
It works fine on my old PC (Office 2013), but not on the new laptop (Office 365). I have copied the add-in from the old PC to the laptop and activated it in the new Excel 365. When I right click the cell the "Refresh prices once" appears on the menu, but the cells still show #VALUE!
Should I be downloading a more recent version of the add-in specific to Office 365? If so, where can I download?
Is the add-in being blocked in some way?
HYPTUSS works fine, but I am not sure it uses tlfAddin!
I suspect it is something simple I am missing. Any help much appreciated.
FD
Possibly a VBA reference missing in the new instance of Excel. Check what references are ticked in the old pc (Alt-F11 > Tools > References), and check same ones in the new instance of Excel.
Also check that macros enabled, VBA enabled etc in the new Excel instance. If you are seeing the right click menu, but nothing works on clicking a menu item, this means the addin is loaded properyl but nothing fires.
Hi eventide, thanks for your reply.
I checked the VBA references, and they are the same on both PC's. Macros are enabled.
I opened a blank workbook, and typed: =getdata("VOD.L") into a cell.
It comes up with ::tick.err:: in the Office 365 version, and the correct share price on the old PC (Office 2013).
I read the advice you provided on p4 of this thread, and wondered if it is still relevant:
ALT-F11 to open VBA editor:
CTRL-F to open search/replace box
Search for the following string in the whole project:
If .StatusText <> "OK"
Replace it with the following string:
If .Status <> 200
I can open the VBA editor, but I don't know how to search for the StatusText string!
Just pressing CTRL-F does nothing.
How do I do this search?
Any advice much appreciated.
FD