Kamis, 12 Oktober 2017

[smf_addin] Digest Number 4169

3 Messages

Digest #4169
1b
Re: Run-time error '53' upon opening by "Randy Harmelink" rharmelink
2a
Re: OX and OX2 data sources not working by "Terry Mitchell" terry_a_mitchell

Messages

Thu Oct 12, 2017 10:25 am (PDT) . Posted by:

badihis

I have installed the add-in and immediately after enabling it, and whenever I start Excel (even just the application before opening any file) I get Run-time error '53' File not found.
When I click on the debug button it gets me to this line:

Open ThisWorkbook.Path & Application.PathSeparator & "smf-elements-" & pSuffix & ".txt" For Input As #1


in Sub LoadElementsFromFile(pSuffix As Variant)


I am using Office 2016 Pro (64 bit) on Windows 10 (64 bit)



Other than that (after stooping the macro and continuing) the few functions that I have tried so far seem to work OK.



Thu Oct 12, 2017 2:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmm. That routine has an error handler, which should have handled that
error. You must have your VBA options set to break on all errors, instead
of just on unhandled errors?

On Thu, Oct 12, 2017 at 6:56 AM, badihi@
​...
wrote:

>
> I have installed the add-in and immediately after enabling it, and
> whenever I start Excel (even just the application before opening any file)
> I get Run-time error '53' File not found.
> When I click on the debug button it gets me to this line:
>
> Open ThisWorkbook.Path & Application.PathSeparator & "smf-elements-" &
> pSuffix & ".txt" For Input As #1
>
> in Sub LoadElementsFromFile(pSuffix As Variant)
>
> I am using Office 2016 Pro (64 bit) on Windows 10 (64 bit)
>
> Other than that (after stooping the macro and continuing) the few
> functions that I have tried so far seem to work OK.
>

Thu Oct 12, 2017 10:26 am (PDT) . Posted by:

"Terry Mitchell" terry_a_mitchell

That's to bad.  I've found the OX2 option prices to be much more accurate since the Yahoo / Verizon merger.  Thanks, Randy, for all your hard work on these tools. 


On Wednesday, October 11, 2017, 9:15:41 PM EDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

Not that I can see. 
I would think Schwab would have their own option quotes pages, so their formatting is probably gone anyway.
On Wed, Oct 11, 2017 at 5:01 PM, johnrr9@​... wrote:

Is there any way to fix this?

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar