| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"
Hello
With excel, I need a vba syntax to open a pdf file like ActiveWorkbook.FollowHyperlink Address:="c:\dossier\test.pdf" this works but i want to use a textbox to have address like this : ActiveWorkbook.FollowHyperlink Address:="TextBox1.value" Textbox value gives address. so in textbox i have this value : c:\dossier\test.pdf could someone can help me or can give me solution ? thank you in advance Friendly best regards |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on excel vba please :ActiveWorkbook.FollowHyperlink
On 07/10/2014 10:25 AM, wrote:
ActiveWorkbook.FollowHyperlink Address:="TextBox1.value Try... ActiveWorkbook.FollowHyperlink Address:=TextBox1.Text -- - Garry Free Usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"
thank you for your reply
your reply is simple and i don't know why i have not found it. I thought a something very hard ActiveWorkbook.FollowHyperlink Address:=TextBox1.Text YES IT WORKS PERFECTLY In fact i can put all kind file (pdf, mp4, avi ...) link in textbox1 the file opens good. again thank you (sorry for my bad english) :-) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"
thank you for your reply
your reply is simple and i don't know why i have not found it. I thought a something very hard ActiveWorkbook.FollowHyperlink Address:=TextBox1.Text YES IT WORKS PERFECTLY In fact i can put all kind file (pdf, mp4, avi ...) link in textbox1 the file opens good. again thank you (sorry for my bad english) :-) Glad to help! Thanks for the feedback... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"
GS wrote:
Glad to help! Thanks for the feedback... Such a rare thing these days. - I need help! - Here's your answer. - [insert complete silence here] -- What's wrong with my life today? She's going away. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"
Such a rare thing these days
Seems to be the way it's trending...<g! Makes for higher appreciation when it happens, though! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| VBA code store address with areas separated with "," and I need it sometimes with ";" instead | Excel Programming | |||
Hybrid Mode
