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


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
 
Ad

Advertisements

N

nicaise barret

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)

:)
 
G

GS

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
 
Ad

Advertisements

G

GS

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top