6 New Messages
Digest #2514
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.
>
search string was found (i.e. pCells=0).
Looks like what you want is:
=RCHGetTableCell(
http://markets.
31, 2012")
On Mon, Feb 18, 2013 at 5:00 AM, rjemery7 rjemery@gmail.
> I could you some help in implementing a RCHGetTableCell function call.
> Why does the following only return the search string itself?
>
> =RCHGetTableCell(
> http://markets.
> 31, 2012",,
>
> 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
tried to use `Stock Screener 34.xlsm'
I tried tools>References
normally I would just see smfForceRecalculati
I'm going back to 1/4/2013 for now.
Macro _________
Macro name:
`Stock Screener 34.xlsm'
Sheet2l.Test
Sheet5.Test Ltep Into
`Stock Screener 34.xlsm'
`Stock Screener 34.xlsm'
`Stock Screener MASTER DATABASE 34.xlsm'
`Stock Screener 34.xlsm'
`Stock Screener 34.xlsm'
`Stock Screener 34.xlsm9 Modulel.StartTimer
`Stock Screener 34.xlsm'
`Stock Screener 34.xlsm'
`Stock Screener 34.xlsm'
`Stock Screener 34.xlsm'
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
>
>
>
>
It's nothing of mine.
On Mon, Feb 18, 2013 at 11:03 PM, almondtree almondtree@yahoo.
> 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'
>
> I tried tools>References
>
> normally I would just see smfForceRecalculati
> I'm going back to 1/4/2013 for now.
>
> Macro _________
> Macro name:
> `Stock Screener 34.xlsm'
> ßun
> Sheet2l.Test
> Sheet5.Test Ltep Into
> `Stock Screener 34.xlsm'
> `Stock Screener 34.xlsm'
> `Stock Screener MASTER DATABASE 34.xlsm'
> `Stock Screener 34.xlsm'
> `Stock Screener 34.xlsm'
> `Stock Screener 34.xlsm9 Modulel.StartTimer
> `Stock Screener 34.xlsm'
> `Stock Screener 34.xlsm'
> `Stock Screener 34.xlsm'
> `Stock Screener 34.xlsm'
> 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
> >
> >
> >
> >
>
plus the ! modUtilities.
--- In smf_addin@yahoogrou
>
> 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'
> >
> > I tried tools>References
> >
> > normally I would just see smfForceRecalculati
> > I'm going back to 1/4/2013 for now.
> >
> > Macro _________
> > Macro name:
> > `Stock Screener 34.xlsm'
> > Ãun
> > Sheet2l.Test
> > Sheet5.Test Ltep Into
> > `Stock Screener 34.xlsm'
> > `Stock Screener 34.xlsm'
> > `Stock Screener MASTER DATABASE 34.xlsm'
> > `Stock Screener 34.xlsm'
> > `Stock Screener 34.xlsm'
> > `Stock Screener 34.xlsm9 Modulel.StartTimer
> > `Stock Screener 34.xlsm'
> > `Stock Screener 34.xlsm'
> > `Stock Screener 34.xlsm'
> > `Stock Screener 34.xlsm'
> > Macros ¡n: All Open Workbooks Ã
> > Description
> >
> >
> >
> > ------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
Tidak ada komentar:
Posting Komentar