Minggu, 06 Mei 2012

[smf_addin] Digest Number 2202

Messages In This Digest (15 Messages)

Messages

1.1.

Re: Instructions for fixing the elements problem....

Posted by: "Pete A" optionzz@gmail.com   option2z

Sat May 5, 2012 2:19 am (PDT)



Oops. Losing it! "GetData" is a local name I use. Sorry. Randy called it: smfUpdateDownloadTable(). A very useful function for my work. It still doesn't work with 13862. I just downloaded the latest .TXT file.

Pete A

--- In smf_addin@yahoogroups.com, "Pete A" <optionzz@...> wrote:
>
> Hi Kermit,
>
> "GetData" is a utility program written by Randy awhile back. It processes a single row of "codes" against a bunch of tickers, filling out the matrix with a single call to a VBA routine. I don't think he supports it, but I found it in the files section sometime or other.
>
> Appreciate your trying it; the number still 13862 still returns nothing, even after updating with the latest elements-1.txt file. Not urgent; I'll get to analyzing why it doesn't work in the "GetData" implementation.
>
> Pete A
>
>
> --- In smf_addin@yahoogroups.com, "Kermit W. Prather" <kermitp@> wrote:
> >
> > Pete, I just tried
> > =RCHGetElementNumber($E1, $A20)
> > Where $E1 was the symbol
> > And $A20 was the element
> >
> > And it worked just fine.
> >
> > What is GETDATA? It is not part of the add-in
> >
> >
> > Kermit
> >
> >
> > -----Original Message-----
> > From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> > Of Pete A
> > Sent: Thursday, May 03, 2012 6:27 PM
> > To: smf_addin@yahoogroups.com
> > Subject: [smf_addin] Re: Instructions for fixing the elements problem....
> >
> > Thanks Mike. I had been following that MSM thing, and had downloaded the
> > elements-1.txt file...still doesn't work. Most of the fixes do.
> >
> > Appreciate the quick response! Save Randy a few minutes...
> >
> > Pete A
> >
> > --- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@> wrote:
> > >
> > > Pete, 13862 comes from MSN. See all the messages recently about the
> > > changes at MSN. In short, you need the new elements-1.txt file in the
> > > Works in Progress folder.
> > >
> > > _____
> > >
> > > From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On
> > > Behalf Of Pete A
> > > Sent: Thursday, May 03, 2012 5:41 PM
> > > To: smf_addin@yahoogroups.com
> > > Subject: [smf_addin] Re: Instructions for fixing the elements problem....
> > >
> > >
> > >
> > >
> > > 13862 (company name) doesn't work at all when using the utility "GetData"
> > > It's been down for several days now; I haven't delved into it because
> > > it isn't critical. Is there something differenct about how GetData does
> > it?
> > > Thanks Randy!
> > > Pete A
> > >
> > > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> > > , Randy Harmelink <rharmelink@> wrote:
> > > >
> > > > All of those element numbers are working fine for me right now:
> > > >
> > > > Element #
> > > > MMM NFLX Element Description
> > > > 13862 3M Co Netflix Inc Company Name 55 15.1 23.8 % Growth Rate --
> > > <snip> 13862.... When do you think the errors of those elements are
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (34)
1.2.

Re: Instructions for fixing the elements problem....

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat May 5, 2012 2:48 am (PDT)



Ahhhh. No, it won't. For some reason I haven't been able to figure out,
some of the new elements defined by a function definition don't evaluate
under smfUpdateDownloadTable.

Oddly enough, the formula in the element definition DOES work if hard-coded:

TRIM(smfStrExtr("|"&smfGetTagContent("
http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~
","div",-1,"class=""cn"">"),"|","<"))

Or, if you want to do it so that you can pick up changes to the function
invocation used by the element number:

=smfWord(smfGetAParms(13862),3,";")

I've been trying to decide if I should give up trying to figure out the
problem and just use that automation as a work-around.

On Sat, May 5, 2012 at 2:18 AM, Pete A <optionzz@gmail.com> wrote:

> Oops. Losing it! "GetData" is a local name I use. Sorry. Randy called
> it: smfUpdateDownloadTable(). A very useful function for my work. It
> still doesn't work with 13862. I just downloaded the latest .TXT file.
>
> Pete A
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (34)
2a.

Re: Missing something while using latest stable add in

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Sat May 5, 2012 7:12 am (PDT)



Thanks for the reply Mike

I don't seem to have solved it still.

This is what I did

I visited the WIP link you had given, downloaded and unzipped its entire
contents to the SMF add in directory within the Program files directory.
While unzipping I retained the old *.xla files renaming them *_old.xla
..etc

Then I created a test XL sheet : I started XL and created an XL sheet
with numbers 1 .. 400 in column A i,e, 1 on Cell A1, 2 on A 2 and so on
... 400 Numbers on 400 rows of Column A. Used a V lookup and got the
site name and definitions finally value pasted them on columns B and C
adjacent to these numbers.

So the sheet looks like

1

MSN

Company Description

2

Obsolete

FYI Alerts

3

MSN

Exchange

4

MSN

Industry
...and so on

Then on column D I entered the formula =RCHGetElementNumber("AAPL",A1),
=RCHGetElementNumber("AAPL",A2).. and so on (using XL copy paste). AAPL
is just an example here ...just to be sure that 10 years etc valid data
is in place

I checked the links on this test XL sheet and ensured that they are
pointing to my computer's c:\Program files\SMF
..etc\RCH_Stock_Market_Functions.xla file

Still this test file returns "Error" for numbers 1 to 252; Only numbers
253 onwards return some values

1

MSN

Company Description

Error

2

Obsolete

FYI Alerts

Obsolete

3

MSN

Exchange

Error

4

MSN

Industry

Error

.......

253

MSN10

10 Year Summary -- Current Assets -- FY1

116,370,000,000.00

254

MSN10

10 Year Summary -- Current Assets -- FY2

75,180,000,000.00

255

MSN10

10 Year Summary -- Current Assets -- FY3

47,500,000,000.00

256

MSN10

10 Year Summary -- Current Assets -- FY4

36,170,000,000.00

257

MSN10

10 Year Summary -- Current Assets -- FY5

25,350,000,000.00

I've tried re naming the Old and new add ins and tried with both (of
course I shut down XL before re starting the next test)

Still same results

I'd be grateful IF someone can help me understand what I'm missing or
where I'm wrong

thanks in advance
Best regards

Subu

--- In smf_addin@yahoogroups.com, "MikeM" <mikemcq802@...> wrote:
>
> All of those elements are from MSN.
>
> MSN recently changed its website. You need to get the latest
smf-elements-1.txt file from the Works In Progress folder in the group.
>
>
http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/
>
>
> --- In smf_addin@yahoogroups.com, "Subu S" mail_to_subu@ wrote:
> >
> > Hi Randy
> >
> > Good day to you...
> >
> > Here's what I've done
> > --------------------------------
> > - I've tried to use the latest Add in from http://bit.ly/Inmrc9 i.e.
downloaded and extracted files to c:\Program files\SMF Add-in directory
> > - Then opened XL
> > - Then typed =RCHGetElementNumber("AAPL",1) on a blank cell
> > - I get "Error" as the result
> > - for =RCHGetElementNumber("AAPL",2)I get "No longer available" as
the result
> > - for =RCHGetElementNumber("AAPL",3) ...
=RCHGetElementNumber("AAPL",552) I get "Error" as the result
> > - For =RCHGetElementNumber("AAPL",553) I get "Current Qtr. Jun 12"
and then some data
> >
> > - what am I missing ?
> >
> > - Hate to trouble you ...still can't quite figure out !!
> >
> >
> > PS : AAPL is just an example, I shall replace that with a Cell ref /
variable etc
> >
> >
> > *Thanks in advance* and regards
> >
> > Subu
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2b.

Re: Missing something while using latest stable add in

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat May 5, 2012 7:16 am (PDT)



As Mike said, you need to get the latest smf-elements-1.txt file from the
Works In Progress folder in the group.

Not the ZIP file. The TXT file.

The single file.

It is the most current definition of MSN data elements.

Up until yesterday, that would have fixed all elements except #1. The
current file should fix #1 as well.

On Sat, May 5, 2012 at 7:12 AM, Subu S <mail_to_subu@yahoo.com> wrote:

>
> Thanks for the reply Mike
>
> I don't seem to have solved it still.
>
> This is what I did
>
> I visited the WIP link you had given, downloaded and unzipped its entire
> contents to the SMF add in directory within the Program files directory.
> While unzipping I retained the old *.xla files renaming them *_old.xla ..etc
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2c.

Re: Missing something while using latest stable add in

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Sat May 5, 2012 7:21 am (PDT)



Thanks Randy

Hate to take your time ..still ..

- I *have* that TXT file
- unzipped and in SMF add ins folder

- Still, what should I do with that TXT file ?
- Just leave it in that folder ?
- or ?

Sorry for such a silly question, but I've downloaded that TXT file just less than half and hour ago while un zipping the file and still can't get any result (I replaced the old TXT ..only old XLAs were retained but TXT was replaced )

regards
Subu

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> As Mike said, you need to get the latest smf-elements-1.txt file from the
> Works In Progress folder in the group.
>
> Not the ZIP file. The TXT file.
>
> The single file.
>
> It is the most current definition of MSN data elements.
>
> Up until yesterday, that would have fixed all elements except #1. The
> current file should fix #1 as well.
>
> On Sat, May 5, 2012 at 7:12 AM, Subu S <mail_to_subu@...> wrote:
>
> >
> > Thanks for the reply Mike
> >
> > I don't seem to have solved it still.
> >
> > This is what I did
> >
> > I visited the WIP link you had given, downloaded and unzipped its entire
> > contents to the SMF add in directory within the Program files directory.
> > While unzipping I retained the old *.xla files renaming them *_old.xla ..etc
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2d.

Re: Missing something while using latest stable add in

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat May 5, 2012 7:25 am (PDT)



You don't want the TXT file from the zip archives -- it's an OLD TXT file.

There is a newer version of the TXT file in the "Works in Progress" folder.

And, yes, you just leave it in the folder that the add-in is in, replacing
the version from the ZIP archive. It's read by the add-in when it needs
element definitions.

On Sat, May 5, 2012 at 7:21 AM, Subu S <mail_to_subu@yahoo.com> wrote:

> Thanks Randy
>
> Hate to take your time ..still ..
>
> - I *have* that TXT file
> - unzipped and in SMF add ins folder
>
> - Still, what should I do with that TXT file ?
> - Just leave it in that folder ?
> - or ?
>
> Sorry for such a silly question, but I've downloaded that TXT file just
> less than half and hour ago while un zipping the file and still can't get
> any result (I replaced the old TXT ..only old XLAs were retained but TXT
> was replaced )
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2e.

Re: Missing something while using latest stable add in

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Sat May 5, 2012 11:45 am (PDT)



thanks a ton

regards
Subu

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You don't want the TXT file from the zip archives -- it's an OLD TXT file.
>
> There is a newer version of the TXT file in the "Works in Progress" folder.
>
> And, yes, you just leave it in the folder that the add-in is in, replacing
> the version from the ZIP archive. It's read by the add-in when it needs
> element definitions.
>
> On Sat, May 5, 2012 at 7:21 AM, Subu S <mail_to_subu@...> wrote:
>
> > Thanks Randy
> >
> > Hate to take your time ..still ..
> >
> > - I *have* that TXT file
> > - unzipped and in SMF add ins folder
> >
> > - Still, what should I do with that TXT file ?
> > - Just leave it in that folder ?
> > - or ?
> >
> > Sorry for such a silly question, but I've downloaded that TXT file just
> > less than half and hour ago while un zipping the file and still can't get
> > any result (I replaced the old TXT ..only old XLAs were retained but TXT
> > was replaced )
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2f.

Re: Missing something while using latest stable add in

Posted by: "rWarHol" l.pieraut@videotron.ca   rWarHol

Sat May 5, 2012 11:57 am (PDT)



Hi Randy:
The new TXT file works fine so far except for one glitch: for Canadian stocks, the company name, item #13862, does not work.

Laurent

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You don't want the TXT file from the zip archives -- it's an OLD TXT file.
>
> There is a newer version of the TXT file in the "Works in Progress" folder.
>
> And, yes, you just leave it in the folder that the add-in is in, replacing
> the version from the ZIP archive. It's read by the add-in when it needs
> element definitions.
>
> On Sat, May 5, 2012 at 7:21 AM, Subu S <mail_to_subu@...> wrote:
>
> > Thanks Randy
> >
> > Hate to take your time ..still ..
> >
> > - I *have* that TXT file
> > - unzipped and in SMF add ins folder
> >
> > - Still, what should I do with that TXT file ?
> > - Just leave it in that folder ?
> > - or ?
> >
> > Sorry for such a silly question, but I've downloaded that TXT file just
> > less than half and hour ago while un zipping the file and still can't get
> > any result (I replaced the old TXT ..only old XLAs were retained but TXT
> > was replaced )
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2g.

Re: Missing something while using latest stable add in

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat May 5, 2012 11:59 am (PDT)



Example please. I do nothing with Canadian stocks...

On Sat, May 5, 2012 at 10:57 AM, rWarHol <l.pieraut@videotron.ca> wrote:

> The new TXT file works fine so far except for one glitch: for Canadian
> stocks, the company name, item #13862, does not work.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
3a.

Re: Buttons ???

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Sat May 5, 2012 7:22 am (PDT)



Randy, I don't understand why you can't just execute this smfFixLinks function when the workbook is first opened.

That way you can assign a location where you want the SMF addin and it will solve all these problems we are having each time we download a file.

To be honest I don't have a problem with every file I download but I do have problems with many as my previous postings will tell you.

Quite frankly, this is a problem you can resolve by assigning a location for the addin. Users aren't usually allow by most programs to decide where to install a function.

Thanks, for a great program.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, May 04, 2012 11:29 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Buttons ???


They are something you have to create. You need to customize the toolbar. Just do a Google search and you'll find lots of examples.
On Fri, May 4, 2012 at 7:46 AM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

Randy .... not being savvy with excel, I am lost when you say "you just press a button on your toolbar that runs the smfFixLinks macro that is part of the add-in" .... I don't see it on my excel tool bar or may be I am missing something??? .... do I need to create this button and if so, how? .... same is apparently true about smfForceRecalculation "button" .... is that something automatic or do I have to create it? .... Thanks in advance ....

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (20)
3b.

Re: Buttons ???

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat May 5, 2012 8:39 am (PDT)



Because that would require that EVERY workbook have VBA code in it, since
it would need code to execute at the "open workbook" event. And I don't
like workbooks to have VBA code in them. It can create a huge security
issue.

For example, when you download a workbook with macros in it, do you examine
the VBA code before giving it the OK? If not, someone could easily upload a
workbook that would wipe out your hard drive. It's one of the reasons I
have the add-in as open source. If I protected the code, you'd have no idea
of what could be in there.

I got a number of messages about location problems even when I did have an
assigned location for the add-in. Especially with people that wanted to put
the add-in on a network drive. The big problem arose when I got Vista,
which required me to move the location of my add-in. At that time, the
choice was to either live with the error, or redo all templates and force
everyone to re-install the add-in in the new location, and fix all of their
files. It seemed easier to deal with it on a case by case basis instead.

Location is only an issue when sharing a workbook, which isn't all the
frequent. Once the links are resolved and the file saved, there are no
future location errors with that file. For the number of times I do need to
fix links, the button to execute smfFixLinks is really easy to use.

On Sat, May 5, 2012 at 7:21 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> Randy, I don't understand why you can't just execute this smfFixLinks function
> when the workbook is first opened. ****
>
> ** **
>
> That way you can assign a location where you want the SMF addin and it
> will solve all these problems we are having each time we download a file.*
> ***
>
> ** **
>
> To be honest I don't have a problem with every file I download but I do
> have problems with many as my previous postings will tell you. ****
>
> ** **
>
> Quite frankly, this is a problem you can resolve by assigning a location
> for the addin. Users aren't usually allow by most programs to decide
> where to install a function. ****
>
> ** **
>
> Thanks, for a great program.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (20)
4a.

Re: Randy...HELP!!..how do i use smf under windows 7 64 bit on my ne

Posted by: "investor952" investor952@yahoo.com   investor952

Sat May 5, 2012 12:51 pm (PDT)



Hello Randy..

If the smf_addin can be located anywhere..what about the associated
.txt files that I believe it accesses?..Do they have to be in the SAME location as the addin...

I am having problem getting my old spreadsheets to work under Windows 7 and excel 2010...so far.

I moved your addin out of the c:\program files area into a separate
folder like you say you do..and now when I open an old spreadsheet which I moved to my computer..it still looks for the add in in the program files area...even though I've tried changing the location with the add-in manager.

hmmm....

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in can be located almost anywhere. The only issue with the location
> is in sharing files with other computers. If the add-in isn't in the same
> location when the workbook is saved and when the workbook is open, you'll
> need to manually edit unresolved links (or run the smfFixLinks macro).
>
> I currently have my add-in located here, because of issues I had with the
> Program Files folder when I moved from XP to Vista:
>
> C:/SMF Add-in
>
> Your EXCEL files should be in your "Documentation" folder, where all of
> your personal files are.
>
> On Fri, May 4, 2012 at 7:29 PM, investor952 <investor952@...> wrote:
>
> > This will probably be the 1st of several questions I will have.
> > I recently bought a new lenovo thinkpad laptop 64 bit, that operates under
> > Windows 7. My old Dell desktop (about 8-10 yrs old) runs under
> > Windows XP. I have been using your smf files successfully on my old
> > computer. I am now slowing moving everything to my new computer and am
> > experiencing difficulty.
> >
> > 1. My new computer has 2 c:\program files folders... one of which has an
> > (x86) in the name...which i believe is for 32 bit programs. I believe the
> > other is for 64 bit programs..not sure at this point.
> >
> > Which of these folders should I move the smf add in to?
> >
> > 2. Note, at this time, I have moved it to what I believe is the 64 bit
> > folder, which does not have the (x86) in the folder name.
> >
> > I also put my older excel programs in there to try them.
> >
> > They aren't working (they were done under 32 bit excel).
> >
> > Do I have to put these excel spreadsheets elsewhere but keep your
> > add in and associated files in the 64 bit folder..I ask this because I
> > remember reading a similar question at your group here and think you said
> > to put your add in in the 64 bit folder because of the title being the same
> > you use in your software?
> >
> > In and case...when I currently pull up one of my old spreadsheet..some
> > things come up too fast for me to read them..then go away..and I see a
> > message that says something like excel couldn't read or retrieve the file.
> >
> > Pls advise..how do i use spreadsheets i created with windwows 2002 with
> > smf under 64 bit windows 7?
> >
> > thx.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4b.

Re: Randy...HELP!!..how do i use smf under windows 7 64 bit on my ne

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat May 5, 2012 1:47 pm (PDT)



On Sat, May 5, 2012 at 12:51 PM, investor952 <investor952@yahoo.com> wrote:

>
> If the smf_addin can be located anywhere..what about the associated
> .txt files that I believe it accesses?..Do they have to be in the SAME
> location as the addin...
>

Yes.

I am having problem getting my old spreadsheets to work under Windows 7 and
> excel 2010...so far.
>
> I moved your addin out of the c:\program files area into a separate
> folder like you say you do..and now when I open an old spreadsheet which I
> moved to my computer..it still looks for the add in in the program files
> area...even though I've tried changing the location with the add-in manager.
>

Yes, of course it does. That's the way EXCEL works. When a workbook is
saved, it has a hard-coded link to the location of the add-in.

That's why you have to manually resolve the links, as I noted. But you only
need to do it once. When you save the workbook after resolving those links,
EXCEL will save the workbook with a pointer to the new location.

That's because Microsoft chose to hard-code the location of the add-in when
a workbook is saved, and look for the add-in in that location when the
workbook is opened, instead of using the active add-in that the add-in
manager has installed. If it can't find the add-in in the hard-coded
location, it tags it as an "unresolved link", which you need to fix.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4c.

Re: Randy...HELP!!..how do i use smf under windows 7 64 bit on my ne

Posted by: "investor952" investor952@yahoo.com   investor952

Sat May 5, 2012 9:32 pm (PDT)



Regarding changing the add-in link in my old computer excel worksheets, do I need to first do this on my old computer and save it, and THEN move it to my new computer?..or can I first move the old spreadsheet to my new computer and then change the link..which is what I've been having trouble doing...thx.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> On Sat, May 5, 2012 at 12:51 PM, investor952 <investor952@...> wrote:
>
> >
> > If the smf_addin can be located anywhere..what about the associated
> > .txt files that I believe it accesses?..Do they have to be in the SAME
> > location as the addin...
> >
>
> Yes.
>
> I am having problem getting my old spreadsheets to work under Windows 7 and
> > excel 2010...so far.
> >
> > I moved your addin out of the c:\program files area into a separate
> > folder like you say you do..and now when I open an old spreadsheet which I
> > moved to my computer..it still looks for the add in in the program files
> > area...even though I've tried changing the location with the add-in manager.
> >
>
> Yes, of course it does. That's the way EXCEL works. When a workbook is
> saved, it has a hard-coded link to the location of the add-in.
>
> That's why you have to manually resolve the links, as I noted. But you only
> need to do it once. When you save the workbook after resolving those links,
> EXCEL will save the workbook with a pointer to the new location.
>
> That's because Microsoft chose to hard-code the location of the add-in when
> a workbook is saved, and look for the add-in in that location when the
> workbook is opened, instead of using the active add-in that the add-in
> manager has installed. If it can't find the add-in in the hard-coded
> location, it tags it as an "unresolved link", which you need to fix.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4d.

Re: Randy...HELP!!..how do i use smf under windows 7 64 bit on my ne

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat May 5, 2012 11:14 pm (PDT)



It doesn't matter, since the location is hard-coded in the workbook when
you save it.

On Sat, May 5, 2012 at 9:32 PM, investor952 <investor952@yahoo.com> wrote:

> Regarding changing the add-in link in my old computer excel worksheets, do
> I need to first do this on my old computer and save it, and THEN move it to
> my new computer?..or can I first move the old spreadsheet to my new
> computer and then change the link..which is what I've been having trouble
> doing...thx.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
Recent Activity
Visit Your Group
Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.18

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)