Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress hyperlink Dialogue box when clicking on Link | Excel Discussion (Misc queries) | |||
How to start an RDP seesion by clicking link. | Excel Programming | |||
Opening a folder by clicking on a link | Excel Discussion (Misc queries) | |||
Double Clicking on link w/i workbook does't bring me to souce. | Excel Worksheet Functions | |||
Link spreadsheets by clicking on a field | Excel Programming |