Executing hyperlink

**calhawk01** · 12-23-2012, 12:58 AM

Hi-

I'm working on a project that requires me to execute a hyperlink if a cell flips over to "1"

A1= a formula that gives me 0 or 1

A2= has the link

I want:

=if(a1=1, Execute the link in A2, Or else 0)

I know there's a macro that I can create to accomplish this. Any other way?

**FDibbins** · 12-23-2012, 01:08 AM

do you want to actually activate/apply/use the hyperlink, or just have it "be" there if A1=1?

**calhawk01** · 12-23-2012, 01:45 AM

I want to activate the link.

So if the link is www.google.com

So if A1=1 I want www.google.com to be executed and opened in firefox/IE

**DonkeyOte** · 12-23-2012, 02:40 AM

Originally Posted by calhawk01

I know there's a macro that I can create to accomplish this. Any other way?

No, you cannot use a formula to physically execute the hyperlink and, I am assuming given above quote that you have the code you need to do this ?

**calhawk01** · 12-25-2012, 06:31 PM

Yup, here's what i'm using

Please Login or Register  to view this content.

"BUYSTRATEGY2" is a simple macro that executes the hyperlink

But there is still a problem. I'm trying to communicate with a broker's API to execute my buy/sell orders.

The buy orders is based on the formula in G8. When I get a ''buy'' signal, G8 turns into 1. But the problem that I'm facing now is that.. lets assume that G8 turns into 1 when X>Y. The value that I'm getting for X are streaming quotes. So even though G8 is > that Y.. and continues to be greater than Y for the next 20 quotes.. the problem i'm facing is that every time I get a newer quote for X that is greater than Y.. my macro is executed and sends an additional order to the broker to buy shares.

Is there a way to limit the macro to the ''first'' time G8 flips over to 1 in a given day? Or between a certain time.. 9:30 am to 4 PM