Selasa, 19 Februari 2013

[smf_addin] Digest Number 2514

6 New Messages

Digest #2514
1a
Re: Retrieving Actual Closing Dates by "Randy Harmelink" rharmelink
2
I'm Sorry, so Sorry! by "almondtree" almondtree
3a
3b
Re: Compile error: Invalid outside procedure by "Randy Harmelink" rharmelink
4
Ameri Sky by "Ameri Sky" amerisky

Messages

Mon Feb 18, 2013 7:44 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Because you told it to get the contents of the cell it was in after the
search string was found (i.e. pCells=0).

Looks like what you want is:

=RCHGetTableCell("
http://markets.cbsnews.com/cbsnews/quote/historical?Month=1&Symbol=310%3A998313&Year=2012&Range=3&tag=cbsContent;contentMain",4,"Jan
31, 2012")

On Mon, Feb 18, 2013 at 5:00 AM, rjemery7 rjemery@gmail.com> wrote:

> I could you some help in implementing a RCHGetTableCell function call.
> Why does the following only return the search string itself?
>
> =RCHGetTableCell("
> http://markets.cbsnews.com/cbsnews/quote/historical?Month=1&Symbol=310%3A998313&Year=2012&Range=3&tag=cbsContent;contentMain",0,"Jan
> 31, 2012",,,,,4,,0)
>
> I am seeking the DJIA close on 1/31/2012, which as listed on the refernced
> web page is 12633.
>

Mon Feb 18, 2013 3:41 pm (PST) . Posted by:

"almondtree" almondtree

I reloaded the 2013.02.12.zip to get the compile error do its dastardly deed again. You guessed it, works just fine now. Is there no justice on what to blame? http://www.youtube.com/watch?v=QaAf8Z75mTQ lol at 4:43....

Mon Feb 18, 2013 10:03 pm (PST) . Posted by:

"almondtree" almondtree

I thought all was fine until I used this macro, before it was loading the 34.xlsm...excel 2010,Q9300 chip quad core HP,8g...

tried to use `Stock Screener 34.xlsm'! modUtilities.smfForceRecalculation

I tried tools>References...grayed out

normally I would just see smfForceRecalculation
I'm going back to 1/4/2013 for now.

Macro _________
Macro name:
`Stock Screener 34.xlsm'!Modulel.AccountListview ____________________ LL ßun
Sheet2l.Test
Sheet5.Test Ltep Into
`Stock Screener 34.xlsm'!modUtthties.smfFixünks _________
`Stock Screener 34.xlsm'! modUtilities.smfForceRecalculation Edit
`Stock Screener MASTER DATABASE 34.xlsm'!smfForceRecalulation
`Stock Screener 34.xlsm'! ModulelO.smfUpdateDownloadTable
`Stock Screener 34.xlsm'! ModuIelO.smfUpdateDownloaclTableCurRow
`Stock Screener 34.xlsm9 Modulel.StartTimer
`Stock Screener 34.xlsm'! Modulel.StopTimer
`Stock Screener 34.xlsm'! Module5.SubTestTranspose2
`Stock Screener 34.xlsm'! Modulel.TargetAllocationView Qptions...
`Stock Screener 34.xlsm'! Modulel.UserPortfolioView
Macros ¡n: All Open Workbooks Æ
Description

Mon Feb 18, 2013 10:42 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I have no idea what "Stock Screener 34.xlsm" is...

It's nothing of mine.

On Mon, Feb 18, 2013 at 11:03 PM, almondtree almondtree@yahoo.com> wrote:

> I thought all was fine until I used this macro, before it was loading the
> 34.xlsm...excel 2010,Q9300 chip quad core HP,8g...
>
> tried to use `Stock Screener 34.xlsm'! modUtilities.smfForceRecalculation
>
> I tried tools>References...grayed out
>
> normally I would just see smfForceRecalculation
> I'm going back to 1/4/2013 for now.
>
> Macro _________
> Macro name:
> `Stock Screener 34.xlsm'!Modulel.AccountListview ____________________ LL
> ßun
> Sheet2l.Test
> Sheet5.Test Ltep Into
> `Stock Screener 34.xlsm'!modUtthties.smfFixünks _________
> `Stock Screener 34.xlsm'! modUtilities.smfForceRecalculation Edit
> `Stock Screener MASTER DATABASE 34.xlsm'!smfForceRecalulation
> `Stock Screener 34.xlsm'! ModulelO.smfUpdateDownloadTable
> `Stock Screener 34.xlsm'! ModuIelO.smfUpdateDownloaclTableCurRow
> `Stock Screener 34.xlsm9 Modulel.StartTimer
> `Stock Screener 34.xlsm'! Modulel.StopTimer
> `Stock Screener 34.xlsm'! Module5.SubTestTranspose2
> `Stock Screener 34.xlsm'! Modulel.TargetAllocationView Qptions...
> `Stock Screener 34.xlsm'! Modulel.UserPortfolioView
> Macros ¡n: All Open Workbooks Æ
> Description
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Tue Feb 19, 2013 6:47 am (PST) . Posted by:

"almondtree" almondtree

Stock Screener 34.xlsm is MY STUFF
plus the ! modUtilities.smfForceRecalculation is your stuff. Everything worked until I updated to .xla 2-12-2013 I am restarting computer to clean memory.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I have no idea what "Stock Screener 34.xlsm" is...
>
> It's nothing of mine.
>
> On Mon, Feb 18, 2013 at 11:03 PM, almondtree wrote:
>
> > I thought all was fine until I used this macro, before it was loading the
> > 34.xlsm...excel 2010,Q9300 chip quad core HP,8g...
> >
> > tried to use `Stock Screener 34.xlsm'! modUtilities.smfForceRecalculation
> >
> > I tried tools>References...grayed out
> >
> > normally I would just see smfForceRecalculation
> > I'm going back to 1/4/2013 for now.
> >
> > Macro _________
> > Macro name:
> > `Stock Screener 34.xlsm'!Modulel.AccountListview ____________________ LL
> > ßun
> > Sheet2l.Test
> > Sheet5.Test Ltep Into
> > `Stock Screener 34.xlsm'!modUtthties.smfFixünks _________
> > `Stock Screener 34.xlsm'! modUtilities.smfForceRecalculation Edit
> > `Stock Screener MASTER DATABASE 34.xlsm'!smfForceRecalulation
> > `Stock Screener 34.xlsm'! ModulelO.smfUpdateDownloadTable
> > `Stock Screener 34.xlsm'! ModuIelO.smfUpdateDownloaclTableCurRow
> > `Stock Screener 34.xlsm9 Modulel.StartTimer
> > `Stock Screener 34.xlsm'! Modulel.StopTimer
> > `Stock Screener 34.xlsm'! Module5.SubTestTranspose2
> > `Stock Screener 34.xlsm'! Modulel.TargetAllocationView Qptions...
> > `Stock Screener 34.xlsm'! Modulel.UserPortfolioView
> > Macros ¡n: All Open Workbooks Æ
> > Description
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>

Diposting oleh EXCEL FEED LEARNING di 08.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)