Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 102
Default Hyperlink -Syntax


'm new to VBA here.
What's the syntax for:
Go to this hypelink:

I want have a command button or text in a form hyperlink to a document on
our shared server.

I know the html syntax... can someone help me this.

Thanks in advance,
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Hyperlink -Syntax



Check the Excel VB IDE help on the Hyperlink.Follow method.


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113032

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Hyperlink -Syntax


You can use

ThisWorkbook.FollowHyperlink "your_URL_here.htm"

This will work with any protocol link (e.g., http, ftp, mailto, etc)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 6 Jul 2009 10:36:01 -0700, Benjamin
wrote:

'm new to VBA here.
What's the syntax for:
Go to this hypelink:

I want have a command button or text in a form hyperlink to a document on
our shared server.

I know the html syntax... can someone help me this.

Thanks in advance,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink syntax?? Kevin Excel Programming 0 November 20th 08 10:33 PM
follow hyperlink syntax david s. Excel Discussion (Misc queries) 0 August 23rd 08 06:06 PM
Syntax to obtain the SubAddress of a Hyperlink in A1 on Sheet1 EagleOne Excel Discussion (Misc queries) 0 December 7th 06 02:20 AM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM
reading html when hyperlink address not hyperlink text diplayed Kevin Excel Programming 1 December 4th 03 10:13 PM


All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"