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

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

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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
use vba to open pdf then save as xml 4
Need VBA Code to Select text boxes in spreadsheet 2
Someone help me! 2
Explanation of code 10
Sending automatic e-mail from Xl 11
Why this code works and other do not? Newbie here. 2
Controlling "control buttons" 1

Top