Minggu, 11 Januari 2015

[smf_addin] Digest Number 3293

5 Messages

Digest #3293
1.1
1.2
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
1.3
1.4
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
1.5

Messages

Sat Jan 10, 2015 6:17 pm (PST) . Posted by:

"Jim Ranum" amt2100

Links are bad.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, January 08, 2015 5:44 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New file uploaded to smf_addin

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/MebFaberFiveEtfs.xls
Uploaded by : hellian007 <hellian007@yahoo.com <mailto:hellian007@yahoo.com> >
Description : A basic trend following system using ETFs

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/MebFaberFiveEtfs.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content <https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398> &y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hellian007 <hellian007@yahoo.com <mailto:hellian007@yahoo.com> >

Sat Jan 10, 2015 7:57 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

They work for me.

On Sat, Jan 10, 2015 at 7:16 PM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Links are bad.
>
>
>
> Best regards,
>
> Jim
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Thursday, January 08, 2015 5:44 AM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] New file uploaded to smf_addin
>
>
>
>
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Uploads by forum members/MebFaberFiveEtfs.xls
> Uploaded by : hellian007 <hellian007@yahoo.com>
> Description : A basic trend following system using ETFs
>
> You can access this file at the URL:
>
> https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/MebFaberFiveEtfs.xls
>
> To learn more about file sharing for your group, please visit:
>
> https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
>
> Regards,
>
> hellian007 <hellian007@yahoo.com>
>
>
>

Sat Jan 10, 2015 8:11 pm (PST) . Posted by:

"Jim Ranum" amt2100

Why would I get #NAME in all the cells, when all my other spreadsheets using SMF work just fine?

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, January 10, 2015 10:58 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] New file uploaded to smf_addin

They work for me.

On Sat, Jan 10, 2015 at 7:16 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Links are bad.

Best regards,

Jim

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> ]
Sent: Thursday, January 08, 2015 5:44 AM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: [smf_addin] New file uploaded to smf_addin

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/MebFaberFiveEtfs.xls
Uploaded by : hellian007 <hellian007@yahoo.com <mailto:hellian007@yahoo.com> >
Description : A basic trend following system using ETFs

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/MebFaberFiveEtfs.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content <https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398> &y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hellian007 <hellian007@yahoo.com>

Sat Jan 10, 2015 8:19 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Oh. I thought you meant the URL links *to* the files.

But you're probably getting #NAME! errors because he had his add-in in a
different location than yours. You just need to run the smfFixLinks macro
to remove all of the paths in front of your add-in functions in the cells.
Or, you could do it manually by doing a "Find and Replace All" of those
paths, changing them to be nothing.

This is a common issue when workbooks are shared, because EXCEL saves the
hard-coded location of the add-in and NOT the fact that it's using an
add-in. But once you fix the links, then save the file, everything will be
fine next time you open that file from your hard drive, because it will be
saved with the location of YOUR add-in.

On Sat, Jan 10, 2015 at 9:10 PM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Why would I get #NAME in all the cells, when all my other spreadsheets
> using SMF work just fine?
>
>
>

Sat Jan 10, 2015 8:35 pm (PST) . Posted by:

"Jim Ranum" amt2100

Oh yes, I remember that now. It's been quite a while since I had to do that and forgot.

Thanks Randy.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, January 10, 2015 11:20 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] New file uploaded to smf_addin

Oh. I thought you meant the URL links *to* the files.

But you're probably getting #NAME! errors because he had his add-in in a different location than yours. You just need to run the smfFixLinks macro to remove all of the paths in front of your add-in functions in the cells. Or, you could do it manually by doing a "Find and Replace All" of those paths, changing them to be nothing.

This is a common issue when workbooks are shared, because EXCEL saves the hard-coded location of the add-in and NOT the fact that it's using an add-in. But once you fix the links, then save the file, everything will be fine next time you open that file from your hard drive, because it will be saved with the location of YOUR add-in.

On Sat, Jan 10, 2015 at 9:10 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Why would I get #NAME in all the cells, when all my other spreadsheets using SMF work just fine?

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

Tidak ada komentar:

Poskan Komentar