View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nicaise97@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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