Jumat, 18 Desember 2015

[smf_addin] Digest Number 3586[1 Attachment]

8 Messages

Digest #3586
1b
Re: Excel 2016 Fix links Macro not working by "Randy Harmelink" rharmelink
2a
Spreadsheet Not Working by scottandrewjackson
2b
Re: Spreadsheet Not Working [1 Attachment] by "Randy Harmelink" rharmelink
2c
Re: Spreadsheet Not Working by "Scott Jackson" scottandrewjackson
2d
Re: Spreadsheet Not Working by "Randy Harmelink" rharmelink
2e

Messages

Thu Dec 17, 2015 11:14 am (PST) . Posted by:

jchealey66

Hi All,

I am using excel 2016 but cannot get the Fix Links and Force Recalculation Macros to work.

Just get message, macro cannot work with worksheet, you may need to enable macro settings etc.

Anybody else experienced the same / any problems?

I have enabled macros in the Trust Center Settings.

Thanks,
James




Thu Dec 17, 2015 12:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I earlier versions, you didn't need to enable macros. That's a dangerous
setting to have.

Just the fact that you installed the add-in with the add-in manager should
have been permission enough.

Other than that, I'm clueless...

On Thu, Dec 17, 2015 at 12:14 PM, jameshealey@...wrote:

>
> I am using excel 2016 but cannot get the Fix Links and Force Recalculation
> Macros to work.
>
> Just get message, macro cannot work with worksheet, you may need to enable
> macro settings etc.
>
> Anybody else experienced the same / any problems?
>
> I have enabled macros in the Trust Center Settings.
>
>

Thu Dec 17, 2015 1:10 pm (PST) . Posted by:

jchealey66


Hi Randy,

Thanks for your speedy reply.

Have fixed the problem now. Somehow after upgrading to windows 10 there is old older version of SMF hiding in a folder somewhere that I cannot access.

Once I re-installed latest version again in the add-in manager it has replaced older version and now everything works ok so far. Also now no need for fix links macro as I have same destination folder on both computers. Also gone back to safe setting in Trust Center.

Hopefully all good from here.

Happy Holidays.

Thanks again,
James

Thu Dec 17, 2015 9:10 pm (PST) . Posted by:

scottandrewjackson

Randy,


I'm not sure what I did wrong, but my spreadsheet isn't pulling data and the functions aren't working. Can you take a look at it and let me know if I'm doing something wrong?


-Scott




Attachment(s) from
1 of 1 File(s)

Thu Dec 17, 2015 9:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It worked fine here.

It would run a lot faster if you made those array-entered
RCHGetYahooQuotes() functions over a range.

Define "not working"? Are you seeing unresolved links? "Error" results?
What?

On Thu, Dec 17, 2015 at 10:10 PM, scottandrewjackson@...wrote:

>
> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and
> the functions aren't working. Can you take a look at it and let me know if
> I'm doing something wrong?
>
>
>

Thu Dec 17, 2015 10:18 pm (PST) . Posted by:

"Scott Jackson" scottandrewjackson

I'm not sure what I did but it's working now.

How would I enable the functions as an array? It's taking a while to update.

Also, is there a debt to equity function that I may input?

Thanks

> On Dec 17, 2015, at 9:50 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> It worked fine here.
>
> It would run a lot faster if you made those array-entered RCHGetYahooQuotes() functions over a range.
>
> Define "not working"? Are you seeing unresolved links? "Error" results? What?
>
> On Thu, Dec 17, 2015 at 10:10 PM, scottandrewjackson@...wrote:
>>
>> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and the functions aren't working. Can you take a look at it and let me know if I'm doing something wrong?
>
>

Thu Dec 17, 2015 10:28 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

On Thu, Dec 17, 2015 at 11:18 PM, Scott Jackson scottandrewjackson@...
wrote:

>
> I'm not sure what I did but it's working now.
>
> How would I enable the functions as an array? It's taking a while to
> update.
>

You need to array-enter the function over a range, giving it multiple
ticker symbols and/or Yahoo codes. It can be used for up to 200 ticker
symbols.

>
> Also, is there a debt to equity function that I may input?
>
>
Nothing for RCHGetYahooQuotes(). You'd need one of the other formulas.

Thu Dec 17, 2015 10:28 pm (PST) . Posted by:

"Jim RACINOWSKI" jimrazz9

Scott,

It worked for me with excel 2007 and logged into FINVIZ without a premium
account.

Good Luck,

Jim

On Fri, Dec 18, 2015 at 12:10 AM, scottandrewjackson@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> [Attachment(s) <#151b37f401ea3b6f_TopText> from
> scottandrewjackson@yahoo.com [smf_addin] included below]
>
> Randy,
>
> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and
> the functions aren't working. Can you take a look at it and let me know if
> I'm doing something wrong?

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

Tidak ada komentar:

Poskan Komentar