7 New Messages
Digest #2422
Messages
Mon Dec 3, 2012 6:09 am (PST) . Posted by:
"Steven" stevenletzer
This website provides contact information, for example tax preparers in Farmington MI; the web address is: http://www.valueappeal.com/tax-preparers/city/oakland-county/farmington-mi
I am trying to bring in the contact info without having to copy and paste. For example at this address: http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro, this information is displayed:
****************************************************************
Abba Shapiro
Harelik Shapiro Wolgin & Fine Pc
30445 Northwestern Hwy #Ste, Farmington, MI 48334
Email (a link returns "ashapiro@hswf.net <ashapiro@hswf.net >")
Website (a link that returns "http://www.hswf.net/ ")
Phone: 248-851-2211 (text)
****************************************************************
I know that I will have to copy and past the web address with the internal contact data. But that is one task vs. several.
I need to capture the table data and the email and website data.
Any ideas?
I am trying to bring in the contact info without having to copy and paste. For example at this address: http://www.valueapp
************
Abba Shapiro
Harelik Shapiro Wolgin & Fine Pc
30445 Northwestern Hwy #Ste, Farmington, MI 48334
Email (a link returns "ashapiro@hswf.
Website (a link that returns "http://www.hswf.
Phone: 248-851-2211 (text)
************
I know that I will have to copy and past the web address with the internal contact data. But that is one task vs. several.
I need to capture the table data and the email and website data.
Any ideas?
Mon Dec 3, 2012 7:00 am (PST) . Posted by:
"Randy H" rharmelink
The data isn't in tables, so you need to use the smfGetTagContent()
function. Here's what I got:
=smfStrExtr(smfGetTagContent("http://www.valueappeal.com/tax-preparer/oa\
kland-county/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-sh\
apiro ","div",-1,">Email"),"mailto:","""")
=smfStrExtr(smfGetTagContent("http://www.valueappeal.com/tax-preparer/oa\
kland-county/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-sh\
apiro ","div",-1,">Email"),"http://","""")
=smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro ","div\
",-1,"Phone:")
=smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro ","h1"\
,1,"Phone:")
=smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro ","h2"\
,1,"Phone:")
=smfGetTagContent("http://www.valueappeal.com/tax-preparer/oakland-count\
y/farmington-mi/527492/harelik-shapiro-wolgin-fine-pc/abba-shapiro ","h3"\
,1,"Phone:")
...returned:
ashapiro@hswf.net www.hswf.net/ Phone: 248-851-2211 Abba
Shapiro Harelik Shapiro Wolgin & Fine Pc 30445 Northwestern
Hwy #Ste, Farmington, MI 48334
On Mon, Dec 3, 2012 at 7:09 AM, Steven <stevenletzer@yahoo.com
<mailto:stevenletzer@yahoo.com > > wrote:
This website provides contact information, for example tax preparers in
Farmington MI; the web address is:
http://www.valueappeal.com/tax-preparers/city/oakland-county/farmington-\
mi
<http://www.valueappeal.com/tax-preparers/city/oakland-county/farmington\
-mi >
I am trying to bring in the contact info without having to copy and
paste. For example at this address:
http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/527\
492/harelik-shapiro-wolgin-fine-pc/abba-shapiro
<http://www.valueappeal.com/tax-preparer/oakland-county/farmington-mi/52\
7492/harelik-shapiro-wolgin-fine-pc/abba-shapiro > , this information is
displayed:
****************************************************************
Abba Shapiro
Harelik Shapiro Wolgin & Fine Pc
30445 Northwestern Hwy #Ste, Farmington, MI 48334
Email (a link returns "ashapiro@hswf.net <mailto:ashapiro@hswf.net >
<ashapiro@hswf.net <mailto:ashapiro@hswf.net > >")
Website (a link that returns "http://www.hswf.net/
<http://www.hswf.net/ > ")
Phone: 248-851-2211 <tel:248-851-2211> (text)
****************************************************************
I know that I will have to copy and past the web address with the
internal contact data. But that is one task vs. several.
I need to capture the table data and the email and website data.
Any ideas?
function. Here's what I got:
=smfStrExtr(
kland-county/
apiro
=smfStrExtr(
kland-county/
apiro
=smfGetTagContent(
y/farmington-
",-1,"Phone:
=smfGetTagContent(
y/farmington-
,1,"Phone:")
=smfGetTagContent(
y/farmington-
,1,"Phone:")
=smfGetTagContent(
y/farmington-
,1,"Phone:")
...returned:
ashapiro@hswf.
Shapiro Harelik Shapiro Wolgin & Fine Pc 30445 Northwestern
Hwy #Ste, Farmington, MI 48334
On Mon, Dec 3, 2012 at 7:09 AM, Steven <stevenletzer@
<mailto:stevenletzer@
This website provides contact information, for example tax preparers in
Farmington MI; the web address is:
http://www.valueapp
mi
<http://www.valueapp
-mi
I am trying to bring in the contact info without having to copy and
paste. For example at this address:
http://www.valueapp
492/harelik-
<http://www.valueapp
7492/harelik-
displayed:
************
Abba Shapiro
Harelik Shapiro Wolgin & Fine Pc
30445 Northwestern Hwy #Ste, Farmington, MI 48334
Email (a link returns "ashapiro@hswf.
<ashapiro@hswf.
Website (a link that returns "http://www.hswf.
<http://www.hswf.
Phone: 248-851-2211 <tel:248-851-
************
I know that I will have to copy and past the web address with the
internal contact data. But that is one task vs. several.
I need to capture the table data and the email and website data.
Any ideas?
Mon Dec 3, 2012 10:41 am (PST) . Posted by:
"ddbohrer" ddbohrer
Randy,
The problem seems to be related to excel not recognizing the add-in unless I unclick it and then reclick it manually each time I open excel.
If I do as you indicate it works again until I open up excel again.
Thanks
Daryll
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> - Go in to the add-in manager and uncheck the add-in
> - Exit EXCEL (hopefully this will remove any hanging registry pointers
> related to the add-in)
> - Restart EXCEL
> - Go in to the add-in manager and re-add the add-in
> - Exit EXCEL (to get a fresh start)
> - Restart EXCEL
> - Try some of the templates again...
>
> In any case, I'm still confused...
>
> BTW, you will always have unresolved links if you open up a workbook that
> had the add-in in a different location. However, once you fix the
> unresolved links and save the file, everything should be working when you
> re-open the workbook you saved, because the add-in should be in the same
> location as when the workbook was saved.
>
> However, it will NOT fix unresolved links you get from opening the same
> template again from the FILES area of the Yahoo group. Once you get them
> from there, you will always get them from there -- because that workbook
> was saved with the add-in in a different location than yours.
> On Sun, Dec 2, 2012 at 3:40 PM, ddbohrer <ddbohrer@...> wrote:
>
> > I found a way to repeat the problem and fix it.
> >
> > Everytime I start excel I need to go through the addin process again.
> > Excel seems lose the link everytime I close it. Any ideas?
> >
>
The problem seems to be related to excel not recognizing the add-in unless I unclick it and then reclick it manually each time I open excel.
If I do as you indicate it works again until I open up excel again.
Thanks
Daryll
--- In smf_addin@yahoogrou
>
> Try:
>
> - Go in to the add-in manager and uncheck the add-in
> - Exit EXCEL (hopefully this will remove any hanging registry pointers
> related to the add-in)
> - Restart EXCEL
> - Go in to the add-in manager and re-add the add-in
> - Exit EXCEL (to get a fresh start)
> - Restart EXCEL
> - Try some of the templates again...
>
> In any case, I'm still confused...
>
> BTW, you will always have unresolved links if you open up a workbook that
> had the add-in in a different location. However, once you fix the
> unresolved links and save the file, everything should be working when you
> re-open the workbook you saved, because the add-in should be in the same
> location as when the workbook was saved.
>
> However, it will NOT fix unresolved links you get from opening the same
> template again from the FILES area of the Yahoo group. Once you get them
> from there, you will always get them from there -- because that workbook
> was saved with the add-in in a different location than yours.
> On Sun, Dec 2, 2012 at 3:40 PM, ddbohrer <ddbohrer@..
>
> > I found a way to repeat the problem and fix it.
> >
> > Everytime I start excel I need to go through the addin process again.
> > Excel seems lose the link everytime I close it. Any ideas?
> >
>
Mon Dec 3, 2012 12:17 pm (PST) . Posted by:
"smf_addin@yahoogroups.com"
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Mutual Fund Review v3 12 03 2012.xlsm
Uploaded by : mrpatmcginnis <mrpatmcginnis@
Description : Mutual Fund review form- open Morningstar website once before opening the spreadsheet.
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
mrpatmcginnis <mrpatmcginnis@
Mon Dec 3, 2012 7:59 pm (PST) . Posted by:
"carmine288" carmine288
After the latest element defininition update, Excel hangs trying to pull the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> For the element definitions, take a look at earlier messages today...
>
> For the next earnings date:
>
> =RCHGetTableCell("http://www.zacks.com/stock/quote/MMM ",1,"Next Earnings
> Report Date")
>
> On Sun, Dec 2, 2012 at 6:22 PM, fredwwright <fredwwright@...> wrote:
>
> > Can anyone advise me on how to update the Zacks elements. The ones I use
> > mostly are:
> >
> > 848 - Zacks Rank
> > 13873 - Zacks Recommendation
> > 13885 - Average Broker Recommendation
> > 13886 - Avg Brkr recc 1 week ago
> > 13887 - number of anaylsts
> > 850 - Industry Group name
> > 851 - Ind Gr. Rank
> > 852 - Rank in Industry
> > Finally, I was also pulling the next earnings date with
> >
> > RCHGetTableCell("
> > http://www.zacks.com/research/report.php?type=estimates&t= "&TICKER,1,"Next
> > Report Date")
> >
> > But that is no longer working as well.
> >
> > Thanks for any advice.
> >
>
--- In smf_addin@yahoogrou
>
> For the element definitions, take a look at earlier messages today...
>
> For the next earnings date:
>
> =RCHGetTableCell(
> Report Date")
>
> On Sun, Dec 2, 2012 at 6:22 PM, fredwwright <fredwwright@
>
> > Can anyone advise me on how to update the Zacks elements. The ones I use
> > mostly are:
> >
> > 848 - Zacks Rank
> > 13873 - Zacks Recommendation
> > 13885 - Average Broker Recommendation
> > 13886 - Avg Brkr recc 1 week ago
> > 13887 - number of anaylsts
> > 850 - Industry Group name
> > 851 - Ind Gr. Rank
> > 852 - Rank in Industry
> > Finally, I was also pulling the next earnings date with
> >
> > RCHGetTableCell(
> > http://www.zacks.
> > Report Date")
> >
> > But that is no longer working as well.
> >
> > Thanks for any advice.
> >
>
Mon Dec 3, 2012 8:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It appears to hang on me as well -- maybe because that symbol doesn't exist
on Zacks?
On Mon, Dec 3, 2012 at 8:59 PM, carmine288 <carmine.nicoletta@gmail.com >wrote:
> After the latest element defininition update, Excel hangs trying to pull
> the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
>
on Zacks?
On Mon, Dec 3, 2012 at 8:59 PM, carmine288 <carmine.nicoletta@
> After the latest element defininition update, Excel hangs trying to pull
> the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
>
Mon Dec 3, 2012 8:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. When I try to access the web page for POOSF in FireFox, I get an
error with the following message:
*"Firefox has detected that the server is redirecting the request for this
address in a way that will never complete."*
Note the "never complete" part there -- that could be why the add-in is
hanging. It's constantly being redirected in a way that the request can
never get the web page.
On Mon, Dec 3, 2012 at 8:59 PM, carmine288 <carmine.nicoletta@gmail.com >wrote:
> After the latest element defininition update, Excel hangs trying to pull
> the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
>
error with the following message:
*"Firefox has detected that the server is redirecting the request for this
address in a way that will never complete."*
Note the "never complete" part there -- that could be why the add-in is
hanging. It's constantly being redirected in a way that the request can
never get the web page.
On Mon, Dec 3, 2012 at 8:59 PM, carmine288 <carmine.nicoletta@
> After the latest element defininition update, Excel hangs trying to pull
> the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
>
Tidak ada komentar:
Posting Komentar