1 Message
Digest #4026
Message
Mon May 22, 2017 6:58 pm (PDT) . Posted by:
ddockstader
Randy,
I've been experiencing the same problem ever since Yahoo started screwing up their data. I have found a work around. I discovered if I turned the add-in off and then turned it back on (Alt T - I, uncheck the add-in, then Alt T - I and check the add-in again), everything was copacetic for the rest of the session. Unfortunately, I have to do this EVERY TIME I open a workbook that uses your add-in. But I just have to do it at the start, so I wrote an auto-open subroutine to handle it for me:
Sub Auto_Open()
AddIns("Stock Market Functions Add-In").Installed = False
AddIns("Stock Market Functions Add-In").Installed = True
End Sub
It adds a minute or two every time I open the workbook, but I can live with that. And it's certainly not elegant, but it is effective. Some others may be willing to try it.
Dave
I've been experiencing the same problem ever since Yahoo started screwing up their data. I have found a work around. I discovered if I turned the add-in off and then turned it back on (Alt T - I, uncheck the add-in, then Alt T - I and check the add-in again), everything was copacetic for the rest of the session. Unfortunately, I have to do this EVERY TIME I open a workbook that uses your add-in. But I just have to do it at the start, so I wrote an auto-open subroutine to handle it for me:
Sub Auto_Open()
AddIns("
AddIns("
End Sub
It adds a minute or two every time I open the workbook, but I can live with that. And it's certainly not elegant, but it is effective. Some others may be willing to try it.
Dave
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar