Messages In This Digest (14 Messages)

1a.: Help w/ Windows From: John Zman
1b.: Re: Help w/ Windows From: Randy Harmelink
1c.: Re: Help w/ Windows From: John Zman
1d.: Re: Help w/ Windows From: ROBERT GAUER

2a.: Getting link on Internet explorer From: antonvanas1989
2b.: Re: Getting link on Internet explorer From: Randy Harmelink
2c.: Re: Getting link on Internet explorer From: antonvanas1989
2d.: Re: Getting link on Internet explorer From: Randy Harmelink

3a.: Gogle Results From: wu_ming_sg
3b.: Re: Gogle Results From: Randy Harmelink
3c.: Re: [Bulk] [smf_addin] Gogle Results From: Mike McQuaid
3d.: Re: [Bulk] [smf_addin] Gogle Results From: wu_ming_sg
3e.: Re: Gogle Results From: wu_ming_sg

4a.: Re: Spreadsheet Auto-Update From: agotti101

View All Topics | Create New Topic

Messages

1a.: Help w/ Windows

Posted by: "John Zman" john.zman@yahoo.com john.zman

Tue Dec 13, 2011 8:20 am (PST)

I am currently running WindowsXP on my desktop and using the getquote funcion ok. But on my laptop, I am running Windows 7 and despite what appears to be a successful load of the modules into the VBA Project Object Module - it doesn't work. I get the "NAME?" error in each cell.
In the Excel Trust Center settings I have tried both of the following:
* Enable All Macrosand* Disable unsigned macros, but with the "Trust access to the VBA Project Object Module checked.
Neither works.
Thanks for any help.
John Baughman

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1b.: Re: Help w/ Windows

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 8:23 am (PST)

#NAME? is typically a result of not having the add-in installed. However,
check the "Location Errors" item in the "Links" area of the group.

You should never need to enable all macros.

On Tue, Dec 13, 2011 at 9:20 AM, John Zman <john.zman@yahoo.com> wrote:

>
> I am currently running WindowsXP on my desktop and using the getquote
> funcion ok. But on my laptop, I am running Windows 7 and despite what
> appears to be a successful load of the modules into the VBA Project Object
> Module - it doesn't work. I get the "NAME?" error in each cell.
>
> In the Excel Trust Center settings I have tried both of the following:
>
> * Enable All Macros
> and
> * Disable unsigned macros, but with the "Trust access to the VBA Project
> Object Module checked.
>
> Neither works.
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1c.: Re: Help w/ Windows

Posted by: "John Zman" john.zman@yahoo.com john.zman

Tue Dec 13, 2011 11:45 am (PST)

Thanks Randy, this put me on the path to a fix, although I would make the following comments:
Somehow I couldn't get the subroutine to work at all. Not sure what I did wrong, I put it in the sheet handle code to be run when the sheet was selected.Then I tried a "search and replace" on the worksheet, attempting to delete the path to the add-in w/ "" - didn't work eitherFinally, I manually deleted the path to the function call in the first cell, then did a copy down the column, worked fine.Your solution was much more elegant, just not sure where I went wrong. It would appear your sub could automate this process when changing between OS's.
Thanks for the help.
John B
--- On Tue, 12/13/11, Randy Harmelink <rharmelink@gmail.com> wrote:

From: Randy Harmelink <rharmelink@gmail.com>
Subject: Re: [smf_addin] Help w/ Windows
To: smf_addin@yahoogroups.com
Date: Tuesday, December 13, 2011, 4:23 PM

#NAME? is typically a result of not having the add-in installed. However, check the "Location Errors" item in the "Links" area of the group.

You should never need to enable all macros.

On Tue, Dec 13, 2011 at 9:20 AM, John Zman <john.zman@yahoo.com> wrote:

I am currently running WindowsXP on my desktop and using the getquote funcion ok. But on my laptop, I am running Windows 7 and despite what appears to be a successful load of the modules into the VBA Project Object Module - it doesn't work. I get the "NAME?" error in each cell.

In the Excel Trust Center settings I have tried both of the following:

* Enable All Macrosand* Disable unsigned macros,
but with the "Trust access to the VBA Project Object Module checked.
Neither works.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1d.: Re: Help w/ Windows

Posted by: "ROBERT GAUER" b_bgauer.56@verizon.net bgauer

Tue Dec 13, 2011 7:25 pm (PST)

John, these routines are add-ins, not macros. And as far as automating updating between operating systems...the difference in activating addins between Excel 2003 and Excel 2010 is huge. (I just did it, and I had to look for the location to do it in 2010 for quite a while.) BGauer
----- Original Message -----
From: John Zman
To: smf_addin@yahoogroups.com
Sent: Tuesday, December 13, 2011 1:45 PM
Subject: Re: [smf_addin] Help w/ Windows

Thanks Randy, this put me on the path to a fix, although I would make the following comments:

a.. Somehow I couldn't get the subroutine to work at all. Not sure what I did wrong, I put it in the sheet handle code to be run when the sheet was selected.
b.. Then I tried a "search and replace" on the worksheet, attempting to delete the path to the add-in w/ "" - didn't work either
c.. Finally, I manually deleted the path to the function call in the first cell, then did a copy down the column, worked fine.
Your solution was much more elegant, just not sure where I went wrong. It would appear your sub could automate this process when changing between OS's.

Thanks for the help.

John B

--- On Tue, 12/13/11, Randy Harmelink <rharmelink@gmail.com> wrote:

From: Randy Harmelink <rharmelink@gmail.com>
Subject: Re: [smf_addin] Help w/ Windows
To: smf_addin@yahoogroups.com
Date: Tuesday, December 13, 2011, 4:23 PM

#NAME? is typically a result of not having the add-in installed. However, check the "Location Errors" item in the "Links" area of the group.

You should never need to enable all macros.

On Tue, Dec 13, 2011 at 9:20 AM, John Zman <john.zman@yahoo.com> wrote:

I am currently running WindowsXP on my desktop and using the getquote funcion ok. But on my laptop, I am running Windows 7 and despite what appears to be a successful load of the modules into the VBA Project Object Module - it doesn't work. I get the "NAME?" error in each cell.

In the Excel Trust Center settings I have tried both of the following:

* Enable All Macros
and
* Disable unsigned macros, but with the "Trust access to the VBA Project Object Module checked.

Neither works.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)

2a.: Getting link on Internet explorer

Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989

Tue Dec 13, 2011 12:11 pm (PST)

Dear Rhamlink,

When i refresh my data sheet Internet explorer automatic opens or adding a tap and going to this link: about:blank#http://finance.google.com/finance?fstype=ii&q=CVX

Do you know from what formula or someting it can come?? It's for mounths now and i have no clue from what formula it can be....

It's getting a bit annoying though

Hope you can fix it

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2b.: Re: Getting link on Internet explorer

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 12:54 pm (PST)

You probably just need the new Google element definitions from the "Works
in Progress" folder of the "Files" area of the group.

On Tue, Dec 13, 2011 at 1:11 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

>
> When i refresh my data sheet Internet explorer automatic opens or adding a
> tap and going to this link: about:blank#
> http://finance.google.com/finance?fstype=ii&q=CVX
>
> Do you know from what formula or someting it can come?? It's for mounths
> now and i have no clue from what formula it can be....
>
> It's getting a bit annoying though
>
> Hope you can fix it
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.: Re: Getting link on Internet explorer

Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989

Tue Dec 13, 2011 1:40 pm (PST)

Updated smf-elements-3 but still same link..

i see now that in my sheet google aint working..
getting EPS and Shares outstanding
with =RCHGetElementNumber(Ticker; 2912) for q
and =RCHGetElementNumber(Ticker; 3596) for A

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You probably just need the new Google element definitions from the "Works
> in Progress" folder of the "Files" area of the group.
>
> On Tue, Dec 13, 2011 at 1:11 PM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > When i refresh my data sheet Internet explorer automatic opens or adding a
> > tap and going to this link: about:blank#
> > http://finance.google.com/finance?fstype=ii&q=CVX
> >
> > Do you know from what formula or someting it can come?? It's for mounths
> > now and i have no clue from what formula it can be....
> >
> > It's getting a bit annoying though
> >
> > Hope you can fix it
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2d.: Re: Getting link on Internet explorer

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 2:06 pm (PST)

Did you reload the element definitions? Either by running
smfForceRecalculation, or by exiting and restarting EXCEL? Otherwise, the
add-in only loads the element definitions once -- when the first
RCHGetElementNumber() function is used in a session of EXCEL.

I don't know what the "for q" and "for A" text means?

On Tue, Dec 13, 2011 at 2:40 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> Updated smf-elements-3 but still same link..
>
> i see now that in my sheet google aint working..
> getting EPS and Shares outstanding
> with =RCHGetElementNumber(Ticker; 2912) for q
> and =RCHGetElementNumber(Ticker; 3596) for A
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

3a.: Gogle Results

Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg

Tue Dec 13, 2011 2:41 pm (PST)

Hi Randy,
Is it possible to use ur add-in to extract this info from the below web
link?
http://www.google.com/search?q=psl%20holdings%20sgx
I am looking at extracting the number of 484000 from "About 484,000
results" please.
Thank you.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3b.: Re: Gogle Results

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 2:49 pm (PST)

Try something like:

=0+smfStrExtr(smfGetTagContent("
https://www.google.com/search?q=psl%20holdings%20sgx",
"div",-1,">About"),"About "," results")

On Tue, Dec 13, 2011 at 3:41 PM, wu_ming_sg <nghongchong@hotmail.com> wrote:

>
>
> Is it possible to use ur add-in to extract this info from the below web
> link?
>
> http://www.google.com/search?q=psl%20holdings%20sgx
>
> I am looking at extracting the number of 484000 from "About 484,000
> results" please.
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3c.: Re: [Bulk] [smf_addin] Gogle Results

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Tue Dec 13, 2011 2:54 pm (PST)

Try:

=smfWord(smfGetTagContent("http://www.google.com/search?q=psl%20holdings%20s
gx","div",0,"nossln","resultStats"),2
<http://www.google.com/search?q=psl%20holdings%20sgx> ," ")

If you need to convert it to a number, use VALUE function. You will need
the SMF addin from the Works In Process folder for the smfWord function

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of wu_ming_sg
Sent: Tuesday, December 13, 2011 5:41 PM
To: smf_addin@yahoogroups.com
Subject: [Bulk] [smf_addin] Gogle Results

Hi Randy,

Is it possible to use ur add-in to extract this info from the below web
link?

http://www.google.com/search?q=psl%20holdings%20sgx

I am looking at extracting the number of 484000 from "About 484,000 results"
please.

Thank you.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3d.: Re: [Bulk] [smf_addin] Gogle Results

Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg

Tue Dec 13, 2011 3:20 pm (PST)

Thanks you ! I will try it out later.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Try:
>
> =smfWord(smfGetTagContent("http://www.google.com/search?q=psl%20holdings%20s
> gx","div",0,"nossln","resultStats"),2
> <http://www.google.com/search?q=psl%20holdings%20sgx> ," ")
>
> If you need to convert it to a number, use VALUE function. You will need
> the SMF addin from the Works In Process folder for the smfWord function
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of wu_ming_sg
> Sent: Tuesday, December 13, 2011 5:41 PM
> To: smf_addin@yahoogroups.com
> Subject: [Bulk] [smf_addin] Gogle Results
>
>
>
>
>
> Hi Randy,
>
> Is it possible to use ur add-in to extract this info from the below web
> link?
>
> http://www.google.com/search?q=psl%20holdings%20sgx
>
> I am looking at extracting the number of 484000 from "About 484,000 results"
> please.
>
> Thank you.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3e.: Re: Gogle Results

Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg

Tue Dec 13, 2011 3:21 pm (PST)

Thank you ! It works :)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try something like:
>
> =0+smfStrExtr(smfGetTagContent("
> https://www.google.com/search?q=psl%20holdings%20sgx",
> "div",-1,">About"),"About "," results")
>
> On Tue, Dec 13, 2011 at 3:41 PM, wu_ming_sg <nghongchong@...> wrote:
>
> >
> >
> > Is it possible to use ur add-in to extract this info from the below web
> > link?
> >
> > http://www.google.com/search?q=psl%20holdings%20sgx
> >
> > I am looking at extracting the number of 484000 from "About 484,000
> > results" please.
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4a.: Re: Spreadsheet Auto-Update

Posted by: "agotti101" alberto.gotti@gmail.com agotti101

Tue Dec 13, 2011 10:30 pm (PST)

Now it works great!
Thank you so much for you support

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See item 9.4.2 in the "Links" area of the group...
>
> But nothing "automatically" updates.
>
> On Tue, Dec 13, 2011 at 2:30 AM, agotti101 <alberto.gotti@...> wrote:
>
> > I'm not able to change the Internet Options to have the RCHGetYahooHistory
> > function automatically updated when a new day comes in; could you please
> > provide some more details on it.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

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

Rabu, 14 Desember 2011

Messages In This Digest (14 Messages)

Messages

Posted by: "John Zman" john.zman@yahoo.com john.zman

Tue Dec 13, 2011 8:20 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 8:23 am (PST)

Posted by: "John Zman" john.zman@yahoo.com john.zman

Tue Dec 13, 2011 11:45 am (PST)

Posted by: "ROBERT GAUER" b_bgauer.56@verizon.net bgauer

Tue Dec 13, 2011 7:25 pm (PST)

Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989

Tue Dec 13, 2011 12:11 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 12:54 pm (PST)

Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989

Tue Dec 13, 2011 1:40 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 2:06 pm (PST)

Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg

Tue Dec 13, 2011 2:41 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Dec 13, 2011 2:49 pm (PST)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Tue Dec 13, 2011 2:54 pm (PST)

Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg

Tue Dec 13, 2011 3:20 pm (PST)

Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg

Tue Dec 13, 2011 3:21 pm (PST)

Posted by: "agotti101" alberto.gotti@gmail.com agotti101

Tue Dec 13, 2011 10:30 pm (PST)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me