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

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
>
>

On Oct 1, 6:19 pm, Sonnich Jensen <sonnich.jen...@jotautomation.com>
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

On Oct 1, 6:29 pm, Tom Ogilvy <TomOgi...@discussions.microsoft.com>
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?