Clicking on link from VB?

[Sonnich Jensen]

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

 

[Guest]

Look at the linksources property of the workbook

 

[Sonnich Jensen]

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

 

[jodleren]

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?