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

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

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)

:-)

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

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.

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