15 Messages
Digest #3476
Messages
Mon Aug 3, 2015 2:38 am (PDT) . Posted by:
marion_stuchlik
Hello,
I cannot display stock data with RCH macro.
The stack data are downloaded from Yahoo, but don't put in the table vData.
I don't know where is the problem.
Could you help me?
Thanks in advance,
P.S. the file is enclosed
Marion
I cannot display stock data with RCH macro.
The stack data are downloaded from Yahoo, but don't put in the table vData.
I don't know where is the problem.
Could you help me?
Thanks in advance,
P.S. the file is enclosed
Marion
Attachment(s) from
1 of 1 File(s)
Mon Aug 3, 2015 4:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not exactly sure what you're asking?
Could you be running into a regional issue? The add-in is written for the
U.S. regional setting.
On Mon, Aug 3, 2015 at 2:38 AM, marion_stuchlik@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hello,
> I cannot display stock data with RCH macro.
> The stack data are downloaded from Yahoo, but don't put in the table vData.
> I don't know where is the problem.
> Could you help me?
> Thanks in advance,
>
>
>
Could you be running into a regional issue? The add-in is written for the
U.S. regional setting.
On Mon, Aug 3, 2015 at 2:38 AM, marion_stuchlik@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hello,
> I cannot display stock data with RCH macro.
> The stack data are downloaded from Yahoo, but don't put in the table vData.
> I don't know where is the problem.
> Could you help me?
> Thanks in advance,
>
>
>
Hello Randy.
Hope all is well with you.
I've been using and enjoying SMF for awhile now (longer than one year, actually).
Suddenly, starting this past Saturday the following elements are displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671 are displaying as expected.
Perhaps is it because my Windows7 was upgrade to Windows10? If so, what should I do to fix that?
I've already done ForceRecalculation twice to no avail.
By the way, my Excel is 2010.
Any hints?
Thanks
Armando
Hope all is well with you.
I've been using and enjoying SMF for awhile now (longer than one year, actually).
Suddenly, starting this past Saturday the following elements are displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671 are displaying as expected.
Perhaps is it because my Windows7 was upgrade to Windows10? If so, what should I do to fix that?
I've already done ForceRecalculation twice to no avail.
By the way, my Excel is 2010.
Any hints?
Thanks
Armando
Mon Aug 3, 2015 7:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's because MorningStar hasn't populated the data items on the web page
they are extracted from, at least for the one I looked at (you didn't give
any example ticker symbols):
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=SPY
They may be in the midst of month-end updating?
On Mon, Aug 3, 2015 at 5:35 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Suddenly, starting this past Saturday the following elements are
> displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671 are
> displaying as expected.
>
> Perhaps is it because my Windows7 was upgrade to Windows10? If so, what
> should I do to fix that?
>
> I've already done ForceRecalculation twice to no avail.
>
> By the way, my Excel is 2010.
>
> Any hints?
>
>
they are extracted from, at least for the one I looked at (you didn't give
any example ticker symbols):
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=SPY
They may be in the midst of month-end updating?
On Mon, Aug 3, 2015 at 5:35 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Suddenly, starting this past Saturday the following elements are
> displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671 are
> displaying as expected.
>
> Perhaps is it because my Windows7 was upgrade to Windows10? If so, what
> should I do to fix that?
>
> I've already done ForceRecalculation twice to no avail.
>
> By the way, my Excel is 2010.
>
> Any hints?
>
>
Thanks for your quick reply, Randy.
It seems that way. I mean, I hope that is the reason for the
zeros. Hopefully Morningstar will repopulate those elements.
Best regards
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Aug 3, 2015 11:14 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Elements Displaying all ZEROS
It's because MorningStar hasn't populated the data items on the
web page they are extracted from, at least for the one I looked
at (you didn't give any example ticker symbols):
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=\
SPY
<http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol\
=SPY>
They may be in the midst of month-end updating?
On Mon, Aug 3, 2015 at 5:35 AM, armando@pipeline.com
<mailto:armando@pipeline.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:
Suddenly, starting this past Saturday the following elements are
displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671
are displaying as expected.
Perhaps is it because my Windows7 was upgrade to Windows10? If
so, what should I do to fix that?
I've already done ForceRecalculation twice to no avail.
By the way, my Excel is 2010.
Any hints?
It seems that way. I mean, I hope that is the reason for the
zeros. Hopefully Morningstar will repopulate those elements.
Best regards
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Aug 3, 2015 11:14 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Elements Displaying all ZEROS
It's because MorningStar hasn't populated the data items on the
web page they are extracted from, at least for the one I looked
at (you didn't give any example ticker symbols):
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=\
SPY
<http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol\
=SPY>
They may be in the midst of month-end updating?
On Mon, Aug 3, 2015 at 5:35 AM, armando@pipeline.com
<mailto:armando@pipeline.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:
Suddenly, starting this past Saturday the following elements are
displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671
are displaying as expected.
Perhaps is it because my Windows7 was upgrade to Windows10? If
so, what should I do to fix that?
I've already done ForceRecalculation twice to no avail.
By the way, my Excel is 2010.
Any hints?
Tue Aug 4, 2015 8:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like they're working today. I get a non-zero number now for:
=RCHGetElementNumber("SPY",4673)
On Tue, Aug 4, 2015 at 6:25 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> It seems that way. I mean, I hope that is the reason for the zeros.
> Hopefully Morningstar will repopulate those elements.
>
>
=RCHGetElementNumber("SPY",4673)
On Tue, Aug 4, 2015 at 6:25 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> It seems that way. I mean, I hope that is the reason for the zeros.
> Hopefully Morningstar will repopulate those elements.
>
>
Mon Aug 3, 2015 8:31 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
I'm recently getting these annoying popups whenever I make a new entry in my
gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in
all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.
xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)
")
I do a replace all and get it working again after minor work, but why is it
persisting in doing this, when it didn't used to? Also, every time I open
the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the
Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
I'm recently getting these annoying popups whenever I make a new entry in my
gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in
all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.
xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,
")
I do a replace all and get it working again after minor work, but why is it
persisting in doing this, when it didn't used to? Also, every time I open
the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the
Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
Mon Aug 3, 2015 8:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you are creating the problem yourself, when you are
"redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the
hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK
could have its own location of the add-in. When you open the workbook, it
looks for the add-in in that hard-coded location. If it's not there, you
get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the
unresolved links AND save the workbook, *that* workbook will now be able to
be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not
happy with the way it works, but that's the way Microsoft has EXCEL doing
it.
The macro error sounds like you no longer have the add-in in that location.
Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the
smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I'm recently getting these annoying popups whenever I make a new entry in
> my gurufocus spreadsheet:
>
>
>
>
>
>
>
> After I re-enter the correct file, the new entry will have #NAME pop up in
> all the new cells and they have this inserted in the formula.
>
>
> ='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("
> http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")
>
>
>
> I do a replace all and get it working again after minor work, but why is
> it persisting in doing this, when it didn't used to? Also, every time I
> open the spreadsheet now it wants to Update Links, and it didn't used to.
>
> I also get this popup if I try to use the force macro function:
>
>
>
> How do I make these things stop? I've tried going in and redirecting the
> Add-In to the correct directory several times.
>
>
>
> Thanks.
>
>
>
>
>
> Best regards,
>
> Jim
>
>
>
>
"redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the
hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK
could have its own location of the add-in. When you open the workbook, it
looks for the add-in in that hard-coded location. If it's not there, you
get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the
unresolved links AND save the workbook, *that* workbook will now be able to
be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not
happy with the way it works, but that's the way Microsoft has EXCEL doing
it.
The macro error sounds like you no longer have the add-in in that location.
Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the
smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I'm recently getting these annoying popups whenever I make a new entry in
> my gurufocus spreadsheet:
>
>
>
>
>
>
>
> After I re-enter the correct file, the new entry will have #NAME pop up in
> all the new cells and they have this inserted in the formula.
>
>
> ='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("
> http://www.gurufocus.com/financials/"&A11,1,
>
>
>
> I do a replace all and get it working again after minor work, but why is
> it persisting in doing this, when it didn't used to? Also, every time I
> open the spreadsheet now it wants to Update Links, and it didn't used to.
>
> I also get this popup if I try to use the force macro function:
>
>
>
> How do I make these things stop? I've tried going in and redirecting the
> Add-In to the correct directory several times.
>
>
>
> Thanks.
>
>
>
>
>
> Best regards,
>
> Jim
>
>
>
>
Mon Aug 3, 2015 9:15 am (PDT) . Posted by:
"Jim Ranum" amt2100
Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors
Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.
The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:
I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")
I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors
Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.
The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:
I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,
I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
Mon Aug 3, 2015 9:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The only way to clean up the mess is to keep the SMF add-in in a single
location. If that's not the proper location for any given workbook, then
fix the workbook. Once saved, you shouldn't need to fix that workbook again.
You can choose any location you want. However, the reason I opt for a fixed
location is that it makes it easier for people to share workbooks. If you
use the "...JimR..." location, no one else will have that location. So
anyone that opens a workbook of yours will need to fix the location.
But even then, it's only a temporary issue for them. Once they've fixed the
location and saved the file, it will be ready to go the next time they open
it. As long as they haven't change the location on their system in between.
:)
By definition, the "Roaming" folder is one that can travel along with the
profile (i.e. "JimR"). It makes it easier for backup purposes if all of the
Application Data is within the user profile. However, for workbook sharing
purposes, the SMF add-in really can't roam by profile, but works best as a
fixed location for all profiles. Even to the point of being in a fixed
location between different machines.
On Mon, Aug 3, 2015 at 9:15 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Yes, I messed it up when I installed the FRED add-in for Economic data. It
> has an add-in that goes into the Microsoft standard folder,
> Users\JimR\AppData\Roaming\Microsoft\AddIns
>
>
>
> How can I clean up this mess?
>
> And since Microsoft "wants" the add-in's in that folder, wouldn't it be
> easier to just not fight it and go with the flow? I know you've discussed
> this many times, but it sure seems like we are bashing our heads against a
> brick wall.
>
>
>
location. If that's not the proper location for any given workbook, then
fix the workbook. Once saved, you shouldn't need to fix that workbook again.
You can choose any location you want. However, the reason I opt for a fixed
location is that it makes it easier for people to share workbooks. If you
use the "...JimR..." location, no one else will have that location. So
anyone that opens a workbook of yours will need to fix the location.
But even then, it's only a temporary issue for them. Once they've fixed the
location and saved the file, it will be ready to go the next time they open
it. As long as they haven't change the location on their system in between.
:)
By definition, the "Roaming" folder is one that can travel along with the
profile (i.e. "JimR"). It makes it easier for backup purposes if all of the
Application Data is within the user profile. However, for workbook sharing
purposes, the SMF add-in really can't roam by profile, but works best as a
fixed location for all profiles. Even to the point of being in a fixed
location between different machines.
On Mon, Aug 3, 2015 at 9:15 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Yes, I messed it up when I installed the FRED add-in for Economic data. It
> has an add-in that goes into the Microsoft standard folder,
> Users\JimR&#
>
>
>
> How can I clean up this mess?
>
> And since Microsoft "wants" the add-in's in that folder, wouldn't it be
> easier to just not fight it and go with the flow? I know you've discussed
> this many times, but it sure seems like we are bashing our heads against a
> brick wall.
>
>
>
Mon Aug 3, 2015 9:51 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Jim, it is not mandatory that you use what Mircosoft wants for folder location.
I put my SMF-ADDIN in a folder on the C: drive named SMFADDIN, it works just find. That is, as long as I remember to change the links to my specific location.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:15 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Add-In errors
Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors
Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.
The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")
I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
I put my SMF-ADDIN in a folder on the C: drive named SMFADDIN, it works just find. That is, as long as I remember to change the links to my specific location.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:15 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Add-In errors
Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors
Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.
The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,
I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
Mon Aug 3, 2015 9:57 am (PDT) . Posted by:
"Jim Ranum" amt2100
Will do. Sorry I forgot all the background on this.
Thanks for the reminder, and your patience.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors
The only way to clean up the mess is to keep the SMF add-in in a single location. If that's not the proper location for any given workbook, then fix the workbook. Once saved, you shouldn't need to fix that workbook again.
You can choose any location you want. However, the reason I opt for a fixed location is that it makes it easier for people to share workbooks. If you use the "...JimR..." location, no one else will have that location. So anyone that opens a workbook of yours will need to fix the location.
But even then, it's only a temporary issue for them. Once they've fixed the location and saved the file, it will be ready to go the next time they open it. As long as they haven't change the location on their system in between. :)
By definition, the "Roaming" folder is one that can travel along with the profile (i.e. "JimR"). It makes it easier for backup purposes if all of the Application Data is within the user profile. However, for workbook sharing purposes, the SMF add-in really can't roam by profile, but works best as a fixed location for all profiles. Even to the point of being in a fixed location between different machines.
On Mon, Aug 3, 2015 at 9:15 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:
Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Thanks for the reminder, and your patience.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors
The only way to clean up the mess is to keep the SMF add-in in a single location. If that's not the proper location for any given workbook, then fix the workbook. Once saved, you shouldn't need to fix that workbook again.
You can choose any location you want. However, the reason I opt for a fixed location is that it makes it easier for people to share workbooks. If you use the "...JimR..." location, no one else will have that location. So anyone that opens a workbook of yours will need to fix the location.
But even then, it's only a temporary issue for them. Once they've fixed the location and saved the file, it will be ready to go the next time they open it. As long as they haven't change the location on their system in between. :)
By definition, the "Roaming" folder is one that can travel along with the profile (i.e. "JimR"). It makes it easier for backup purposes if all of the Application Data is within the user profile. However, for workbook sharing purposes, the SMF add-in really can't roam by profile, but works best as a fixed location for all profiles. Even to the point of being in a fixed location between different machines.
On Mon, Aug 3, 2015 at 9:15 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:
Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR&#
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Mon Aug 3, 2015 9:58 am (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks.
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:51 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Add-In errors
Jim, it is not mandatory that you use what Mircosoft wants for folder location.
I put my SMF-ADDIN in a folder on the C: drive named SMFADDIN, it works just find. That is, as long as I remember to change the links to my specific location.
Kermit
From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:15 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: RE: [smf_addin] Add-In errors
Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Best regards,
Jim
From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] Add-In errors
Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.
The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:
I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")
I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
Best regards,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:51 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Add-In errors
Jim, it is not mandatory that you use what Mircosoft wants for folder location.
I put my SMF-ADDIN in a folder on the C: drive named SMFADDIN, it works just find. That is, as long as I remember to change the links to my specific location.
Kermit
From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:15 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: RE: [smf_addin] Add-In errors
Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns
How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.
Best regards,
Jim
From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] Add-In errors
Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.
The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).
On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:
I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:
After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,
I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:
How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.
Thanks.
Best regards,
Jim
Mon Aug 3, 2015 11:38 pm (PDT) . Posted by:
cgrauballe
Does anyone know if it is possible to extract this excel file: http://www.dvca.dk/uploads/Publikationer/DVCA_Liste%20over%20buyouts%20i%20DK.xls http://www.dvca.dk/uploads/Publikationer/DVCA_Liste%20over%20buyouts%20i%20DK.xls
And then the sheet: "Samlet" and all data
I tried using the following formula:
="http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste%20over%20buyouts%20i%20DK.xls]Samlet!J9
Didnt work :/
thx
/Caspar
And then the sheet: "Samlet" and all data
I tried using the following formula:
="http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste%
Didnt work :/
thx
/Caspar
Tue Aug 4, 2015 1:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You aren't doing it quite right. For one thing, you can't use the HTML
encoded characters of the URL -- each of those "%20" character encodes
needs to be a space instead. And you need single quotes around everything
but the cell address.
This worked for me:
='http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste over buyouts i
DK.xls]Samlet'!J9
On Mon, Aug 3, 2015 at 11:38 PM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Does anyone know if it is possible to extract this excel file:
> http://www.dvca.dk/uploads/Publikationer/DVCA_Liste%20over%20buyouts%20i%20DK.xls
>
> And then the sheet: "Samlet" and all data
>
> I tried using the following formula:
>
> ="
> http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste%20over%20buyouts%20i%20DK.xls]Samlet!J9
> <http://www.dvca.dk/uploads/Publikationer/%5BDVCA_Liste%20over%20buyouts%20i%20DK.xls%5DSamlet!J9>
>
> Didnt work :/
>
encoded characters of the URL -- each of those "%20" character encodes
needs to be a space instead. And you need single quotes around everything
but the cell address.
This worked for me:
='http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste over buyouts i
DK.xls]Samlet'!J9
On Mon, Aug 3, 2015 at 11:38 PM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Does anyone know if it is possible to extract this excel file:
> http://www.dvca.dk/uploads/Publikationer/DVCA_Liste%20over%20buyouts%20i%20DK.xls
>
> And then the sheet: "Samlet" and all data
>
> I tried using the following formula:
>
> ="
> http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste%20over%20buyouts%20i%20DK.xls]Samlet!J9
> <http://www.dvca.dk/uploads/Publikationer/%5BDVCA_Liste%20over%20buyouts%20i%20DK.xls%5DSamlet!J9>
>
> Didnt work :/
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar