Sabtu, 24 Januari 2015

[smf_addin] Digest Number 3304

4 Messages

Digest #3304

Messages

Fri Jan 23, 2015 7:05 am (PST) . Posted by:

davcabjur1

Hello,
I'm trying to apply this formula and the result is 2 rows of the table. What am I doing wrong?


=RCHGetHTMLTable("http://www.grahaminvestor.com/screens/ncav-stocks-new-without-chinese-rtos/";"plus a breakdown of the Piotroski Score";1;">Share this:";-1)



Thanks in advance


David C.

Fri Jan 23, 2015 7:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's because they aren't coding the end of row HTML tags. The
RCHGetHTMLTable() function is a simple HTML parser and expects all table
tags to be coded.

You could try using the smfGetTagContent() function and retrieve each table
cell, basing the lines on the number of columns per line.

On Fri, Jan 23, 2015 at 5:56 AM, davcabjur1@... wrote:

> I'm trying to apply this formula and the result is 2 rows of the table.
> What am I doing wrong?
>
> =RCHGetHTMLTable("
> http://www.grahaminvestor.com/screens/ncav-stocks-new-without-chinese-rtos/";"plus
> a breakdown of the Piotroski Score";1;">Share this:";-1)
>
>

Fri Jan 23, 2015 8:19 am (PST) . Posted by:

trendsekr

smfFixLinks cleaned up the links, as did the manual fix. But when I restart excel and reopen the spreadsheet it added

'C:\Users\DBLTA_~1\AppData\Local\Temp\Rar$DI02.703\RCH_Stock_Market_Functions.xla'!
to the string.

In both cases, when I restart excel and the spreadsheet, excel isn't loading RCH_Stock_Market_Functions.xla. I open the VB window and nothing is there. I manually open RCH_Stock_Market_Functions.xla and everything is fine.

Thanks for the help. I really love these functions.

Fri Jan 23, 2015 3:38 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Off hand, I would say it sounds like the add-in manager wasn't used to
activate the add-in within EXCEL. You should never be opening the XLA file.
The add-in manager should auto-load it when EXCEL opens.

When you initially open EXCEL, can you use an add-in function within a
brand new workbook?

Note that you do need to SAVE the workbook after using smfFixLinks for the
workbook to work right the next time you open it. However, the path you
cite is using a "temporary" folder. You didn't install the add-in there
with the add-in manager, did you? It could be you have that temporary
folder BECAUSE you opened the XLA file, so it will usually be an issue if
you save a file using that temporary location, and open it up later,
because the add-in may no longer be there the next time it gets opened and
loaded on the fly. Possibly in a different temporary folder.

On Fri, Jan 23, 2015 at 9:19 AM, trendsekr@... wrote:

>
> smfFixLinks cleaned up the links, as did the manual fix. But when I
> restart excel and reopen the spreadsheet it added
>
>
> 'C:\Users\DBLTA_~1\AppData\Local\Temp\Rar$DI02.703\RCH_Stock_Market_Functions.xla'!
> to the string.
>
> In both cases, when I restart excel and the spreadsheet, excel isn't
> loading RCH_Stock_Market_Functions.xla. I open the VB window and nothing is
> there. I manually open RCH_Stock_Market_Functions.xla and everything is
> fine.
>
> Thanks for the help. I really love these functions.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar