I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the worksheet
(or anywhere else).

Thanks in advance for any help you can give!

James

James,

Running the macro recorder, I get this, which adds the Anchor parameter to
what you've got. Does that help?

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet2!A1", TextToDisplay:="Sheet2!A1"

Doug

"James Cox" wrote in message
...
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet
(or anywhere else).

Thanks in advance for any help you can give!

James

Doug -

Well, that adds a hyperlink to the workbook at the location of the current
cell - which I need to avoid because it could overwrite whatever was in the
current cell when the macro runs.

Also, it doesn't go to the hyperlink target - just creates the hyperlink and
stays there.

Thanks for the help, but that's not the functionality needed....

James



"Doug Glancy" wrote in message
...
James,

Running the macro recorder, I get this, which adds the Anchor parameter to
what you've got. Does that help?

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet2!A1", TextToDisplay:="Sheet2!A1"

Doug

"James Cox" wrote in message
...
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet
(or anywhere else).

Thanks in advance for any help you can give!

James

Sub AA()
ActiveWorkbook.FollowHyperlink _
Address:="C:\Data\Add_Button.xls", _
SubAddress:="Sheet2!B3"
End Sub

worked fine for me.

--
Regards,
Tom Ogilvy

"James Cox" wrote in message
...
Doug -

Well, that adds a hyperlink to the workbook at the location of the current
cell - which I need to avoid because it could overwrite whatever was in
the
current cell when the macro runs.

Also, it doesn't go to the hyperlink target - just creates the hyperlink
and
stays there.

Thanks for the help, but that's not the functionality needed....

James



"Doug Glancy" wrote in message
...
James,

Running the macro recorder, I get this, which adds the Anchor parameter
to
what you've got. Does that help?

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=
_
"Sheet2!A1", TextToDisplay:="Sheet2!A1"

Doug

"James Cox" wrote in message
...
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink
Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook
with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet
(or anywhere else).

Thanks in advance for any help you can give!

James

James

ThisWorkbook.FollowHyperlink "#Sheet1!A3"

Not very intuitive, but that's what works.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


James Cox wrote:
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink
Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook
with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet (or anywhere else).

Thanks in advance for any help you can give!

James

Sorry - didn't realize you were moving in the same workbook.

I am sure Dick's example works, but why use a hyperlink. Why not use

Sub AA()
Application.GoTo Reference:=Worksheets("Sheet2").Range("B3"), _
Scroll:=True
End Sub


--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
Sub AA()
ActiveWorkbook.FollowHyperlink _
Address:="C:\Data\Add_Button.xls", _
SubAddress:="Sheet2!B3"
End Sub

worked fine for me.

--
Regards,
Tom Ogilvy

"James Cox" wrote in message
...
Doug -

Well, that adds a hyperlink to the workbook at the location of the
current
cell - which I need to avoid because it could overwrite whatever was in
the
current cell when the macro runs.

Also, it doesn't go to the hyperlink target - just creates the hyperlink
and
stays there.

Thanks for the help, but that's not the functionality needed....

James



"Doug Glancy" wrote in message
...
James,

Running the macro recorder, I get this, which adds the Anchor
parameter
to
what you've got. Does that help?

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="",
SubAddress:=
_
"Sheet2!A1", TextToDisplay:="Sheet2!A1"

Doug

"James Cox" wrote in message
...
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink
Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook
with:

ThisWorkbook.FollowHyperlink Address:="",
SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the
open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet
(or anywhere else).

Thanks in advance for any help you can give!

James

I obviously missed the boat on this one - and I'm curious, is this
different, or better than, Application.Goto?

Thanks,

Doug

"Dick Kusleika" wrote in message
...
James

ThisWorkbook.FollowHyperlink "#Sheet1!A3"

Not very intuitive, but that's what works.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


James Cox wrote:
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink
Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook
with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet (or anywhere else).

Thanks in advance for any help you can give!

James

Different and worse, I would say. I think you get more options with Goto
that would make that a better choice. I can think of one situation where
FollowHyperlink would be better: If you are building the string dynamically
and sometimes it points inside the workbook, sometimes to another workbook,
and sometimes to another program. In that case you could use one method to
do it all and just build the appropriate string. Beyond that, I'd go with
Goto.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Doug Glancy wrote:
I obviously missed the boat on this one - and I'm curious, is this
different, or better than, Application.Goto?

Thanks,

Doug

"Dick Kusleika" wrote in message
...
James

ThisWorkbook.FollowHyperlink "#Sheet1!A3"

Not very intuitive, but that's what works.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


James Cox wrote:
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink
Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook
with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the
open workbook, but I'm picking up an error - "Run time error 5 -
Invalid procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet (or anywhere else).

Thanks in advance for any help you can give!

James

Thanks for all the high-powered help, folks!

The comments about the use of Application.GoTo make sense, but I got into
the hyperlink mindset because this question underlies a need to jump to (and
back from) a shape on a worksheet. The use of hyperlinks was providing an
easy way to get back to the original anchor location - something that GoTo
didn't seem to provide.

More globally, this was a way to do hyperlink documentation of the flowchart
of a program, with detailed documentation in shapes on a differerent
worksheet in the workbook. However, the comment from Dick about sometimes
pointing to inside the workbook and sometimes to an external workbook has
gotten me thinking about the possibility of keeping a centralized version of
the documentation and letting the customized versions of the workbook
hyperlink back to the detailed documentation in a master workbook. This has
the potential of cutting down on the labor to update all the copies of the
workbook in use...

Again, thanks for the help! For the time being, I'll be #'ing around in the
local workbook with an eye out for the advantages of dynamic hyperlink
creation - unless someone has an insight into a slick implementation of
"GoTo / GoBack" functionality that's based on Application.GoTo.

James


"James Cox" wrote in message
...
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet
(or anywhere else).

Thanks in advance for any help you can give!

James