Hperlink problem OWC Spreadsheet 9

[PO]

Hi!

I use the following script to insert a hyperlink in the spreadsheet:

With Spreadsheet1.ActiveCell
.Offset(0,5).hyperlink.address = "http://www.google.se"
.Offset(0,5).hyperlink.name = "Open Google"
End With

The problem is that when the user clicks the link Google is opened in the
same window (the current html document is replaced). I want Google to be
opened in a new window.

How do I get the hyperlink document to be displayed in a new window?

Regards
PO

 

[Alvin Bruney [Microsoft MVP]]

I believe this behavior was only added to version 10 of the components. I am
not 100% sure though. I cannot verify this because I no longer have a copy
of OWC version 9.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc

 

[PO]

Hi Alvin

I think your right. Is there a workaround that you know of?

Regards
PO

I believe this behavior was only added to version 10 of the components. I am
not 100% sure though. I cannot verify this because I no longer have a copy
of OWC version 9.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
--------------------------------------------------

Hi!

I use the following script to insert a hyperlink in the spreadsheet:

With Spreadsheet1.ActiveCell
.Offset(0,5).hyperlink.address = "http://www.google.se"
.Offset(0,5).hyperlink.name = "Open Google"
End With

The problem is that when the user clicks the link Google is opened in the
same window (the current html document is replaced). I want Google to be
opened in a new window.

How do I get the hyperlink document to be displayed in a new window?

Regards
PO

 

[Alvin Bruney [Microsoft MVP]]

There isn't a workaround that i know of for version 9. As a last resort, you
can look up the event model in the help files to see if it exposes a
navigate event though i seriously doubt that it does.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
--------------------------------------------------

Hi Alvin

I think your right. Is there a workaround that you know of?

Regards
PO

I believe this behavior was only added to version 10 of the components. I am
not 100% sure though. I cannot verify this because I no longer have a
copy
of OWC version 9.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
--------------------------------------------------

Hi!

I use the following script to insert a hyperlink in the spreadsheet:

With Spreadsheet1.ActiveCell
.Offset(0,5).hyperlink.address = "http://www.google.se"
.Offset(0,5).hyperlink.name = "Open Google"
End With

The problem is that when the user clicks the link Google is opened in the
same window (the current html document is replaced). I want Google to
be
opened in a new window.

How do I get the hyperlink document to be displayed in a new window?

Regards
PO