Messages In This Digest (5 Messages)
- 1a.
- Help with smfUpdateDownloadTable() function From: Subu S
- 1b.
- Re: Help with smfUpdateDownloadTable() function From: Randy Harmelink
- 2a.
- Re: Distribute Spreadsheet with SMF Add-In From: caninvestor_99
- 2b.
- Re: Distribute Spreadsheet with SMF Add-In From: Randy Harmelink
- 3a.
- Re: Missing something while using latest stable add in From: rWarHol
Messages
- 1a.
-
Help with smfUpdateDownloadTable() function
Posted by: "Subu S" mail_to_subu@yahoo.com mail_to_subu
Sat May 12, 2012 4:22 am (PDT)
Hi Randy and others
1. I am interested in using this smfUpdateDownloadTable() function to avoid repeated / un necessary access to web pages
2. Tried searching some recent messages and files , I checked the documentation folder but can't see any help / documentation on how to use smfUpdateDownloadTable() function
3. Hate to trouble this group ... found no other way ... so posting here
4. Other facts : using MS office 2003, have the latest XLA file and RCHGetElementNumber() works for me
*Thanks* in advance
B regards
Subu
- 1b.
-
Re: Help with smfUpdateDownloadTable() function
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat May 12, 2012 6:41 am (PDT)
Check the "Links" area of the group. There are several items there.
On Sat, May 12, 2012 at 4:19 AM, Subu S <mail_to_subu@yahoo.com > wrote:
>
> 1. I am interested in using this smfUpdateDownloadTable() function to
> avoid repeated / un necessary access to web pages
>
> 2. Tried searching some recent messages and files , I checked the
> documentation folder but can't see any help / documentation on how to use
> smfUpdateDownloadTable() function
>
> 3. Hate to trouble this group ... found no other way ... so posting here
>
> 4. Other facts : using MS office 2003, have the latest XLA file and
> RCHGetElementNumber() works for me
>
- 2a.
-
Re: Distribute Spreadsheet with SMF Add-In
Posted by: "caninvestor_99" stselpidis@gmail.com caninvestor_99
Sat May 12, 2012 8:13 am (PDT)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Unfortunately, this is a common situation when workbooks are shared. It
> occurs because when you save your EXCEL file,MicroSoft decided to save the
> hard-coded location of the add-in in the cell formula, so that EXCEL knows
> the function comes from an external source. Then, when the file is opened,
> EXCEL looks for that external source. If it finds it, it resolves the link
> and removes the hard-coded location -- all is well. However, if it doesn't
> find the external source, EXCEL marks it as an unresolved link, which makes
> the cell non-functional until the link error is resolved.
>
> As you note, a manual change, cell by cell, does fix the problem. If you
> check EXCEL's menus, you find a way to > Edit > Links, which is another way
> to solve the issue for an entire workbook. However, I've found it work
> differently on different versions of EXCEL and was not a reliable way to fix
> link errors.
>
> The quickest and most reliable way I've found to fix the issue is to do a
> "Find and Replace All" (keyboard shortcut Ctrl+H), replacing all hard-coded
> locations:
>
> 'C:\User Name\Application
> Data\Microsoft\AddIns\RCH_ Stock_Market_ Functions. xla'!
>
> ...with nothing. Once that is done and the file is saved, that person's
> hard-coded add-in location will be saved with the formulas, so that the next
> time they open the file on their computer, the links will be resolved
> automatically.
>
> It's one reason I tried to go with a standard folder for the location of the
> add-in in the installation instructions. If everyone used the same location,
> this would never be an issue.
>
> Unfortunately, even I had to violate that, because Vista wouldn't let me
> update the add-in's XLA file while it was located in a subdirectory of the
> "Program Files" folder. The "Find and Replace" process could be automated --
> I have a macro I manually run to do it as needed when I open files that used
> to use my old location:
>
> Public Sub smfFixLinks()
> ActiveSheet.Cells.Replace _
> What:="'C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions .xla'!", _
> Replacement:="", _
> LookAt:=xlPart, _
> SearchOrder:=xlByRows, _
> MatchCase:=False, _
> SearchFormat:=False, _
> ReplaceFormat:=False
> End Sub
>
>
> On Wed, Aug 25, 2010 at 1:45 PM, Ping Zhu <p_zhu00@...> wrote:
>
> > This might be a pretty dumb question, but I've got an issue when I tried
> > to copy my working Excel model to my colleagues' computers. I installed
> > RCH_Stock_Market_Functions. xla as add-ins in my computer, and was able to
> > develop a model by placing the formulas in some cells directly (not in VBA
> > code). For example:
> >
> > In cell A1, I placed "=RCHGetElementNumber("YUM", 13862)", and I correctly
> > got the result as "YUM! BRANDS INC".
> >
> > Unfortunately, when I copy this same Excel file to another computer (with
> > SMF Add-Ins installed), the formula in cell A1 was automatically changed to
> > something like:
> >
> > ='C:\User Name\Application
> > Data\Microsoft\AddIns\RCH_ Stock_Market_ Functions. xla'!RCHGetEleme ntNumber( "YUM",
> > 13862)
> >
> > As a result, this cell no longer returns a valid result. If I manually
> > remove the path, it'll work fine in the new computer. However, this is very
> > tedious as I have many RCHGetElementNumber calls in lots of cells.
> >
> > I suspect I'm not installing the Excel add-in correctly? Is there a way so
> > that I can freely copy my finished models to other computers in the future,
> > without encountering the same problem?
> >
>
I have a similar issue after all programs on my laptop had to be reinstalled; the worksheet I am using "TD_Trend_Exhaustion_v3.xlsx" now has links errors and returns #NAME and # when a ticker symbol is entered. When I open the worksheet it prompts me me worksheet contains links that needs to be updated, I clik update but Excel cannot resolve and update the links. If I try to edit the link to RCH_Stock_Market_ Functions. xla (C:\Program Files\SMF Add-in\RCH_Stock_ Market_Functions -2.1.2010. 08.02) it won't work because the worksheet is protected. The "Find and Replace All" won't work either because of the sheet protection.
Any idea how to solve this issue?
- 2b.
-
Re: Distribute Spreadsheet with SMF Add-In
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat May 12, 2012 8:15 am (PDT)
Turn off the sheet protection before doing the "Find and Replace All"?
On Sat, May 12, 2012 at 7:04 AM, caninvestor_99 <stselpidis@gmail. com >wrote:
>
> I have a similar issue after all programs on my laptop had to be
> reinstalled; the worksheet I am using "TD_Trend_Exhaustion_v3.xlsx" now has
> links errors and returns #NAME and # when a ticker symbol is entered. When
> I open the worksheet it prompts me me worksheet contains links that needs
> to be updated, I clik update but Excel cannot resolve and update the links.
> If I try to edit the link to RCH_Stock_Market_Functions. xla (C:\Program
> Files\SMF Add-in\RCH_Stock_Market_Functions -2.1.2010. 08.02) it won't work
> because the worksheet is protected. The "Find and Replace All" won't work
> either because of the sheet protection.
>
> Any idea how to solve this issue?
>
- 3a.
-
Re: Missing something while using latest stable add in
Posted by: "rWarHol" l.pieraut@videotron.ca rWarHol
Sun May 13, 2012 12:42 am (PDT)
Hello Randy,
Sorry for the delay,
Here is an example: Stock name BCE.TO
RCHGetElementNumber("BCE.TO" ,13862) will return "Error"
Other RCHGetElementNumber requests will return a value.
(I used the latest element1 file from May 10th)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Example please. I do nothing with Canadian stocks...
>
> On Sat, May 5, 2012 at 10:57 AM, rWarHol <l.pieraut@...> wrote:
>
> > The new TXT file works fine so far except for one glitch: for Canadian
> > stocks, the company name, item #13862, does not work.
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar