Clicking on link from VB?
 

Hi all!

I have a cell, with a link in it, and I need to click on that link. Is
that possible?

Maybe, I have to read out the text, and change it a bit, then "open"
it. How do I open such a thing? Windows.open()?

Is there a sleep function in VB?

BR
Sonnich

Clicking on link from VB?
 

Look at the linksources property of the workbook

--
Regards,
Tom Ogilvy


"Sonnich Jensen" wrote:

Hi all!

I have a cell, with a link in it, and I need to click on that link. Is
that possible?

Maybe, I have to read out the text, and change it a bit, then "open"
it. How do I open such a thing? Windows.open()?

Is there a sleep function in VB?

BR
Sonnich

Clicking on link from VB?
 

On Oct 1, 6:19 pm, Sonnich Jensen
wrote:
Hi all!

I have a cell, with a link in it, and I need to click on that link. Is
that possible?

Maybe, I have to read out the text, and change it a bit, then "open"
it. How do I open such a thing? Windows.open()?

Is there a sleep function in VB?

I found it. Both in the Shell API searching this group :-)

Say: ShellExecute Scr_hDC, "open", sTemp, "", "c:\", SW_NORMAL

Though, one thing I cannot find: I open this, but is there a way to
get the window, then close it again?

Say:

ShellExecute Scr_hDC, "open", sTemp, "", "c:\", SW_NORMAL
Sleep(5000)
' close the window here - ?

WBR
Sonnich

Clicking on link from VB?
 

On Oct 1, 6:29 pm, Tom Ogilvy
wrote:
Look at the linksources property of the workbook

I need to open another programme, say I open something.txt, then it
opens in notepad, then I'd like to close it again....

Any ideas?