need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"

  • Thread starter Thread starter nicaise97
  • Start date Start date
N

nicaise97

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

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

:-)
Click to expand...

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