Followhyperlink - How do I disable IE launch?

[Kenji4861]

Everytime I do a followhyperlink within excel such as

thisworkbook.followhyperlink "http://www.spoofee.com", , false

I say "False" to the NewWindow parameter, but it still launches, why
is that? Is there a way to disable this?

 

[keepITcool]

no.
newwindow = false means that if IE is open the existing window will be
used.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Tom Ogilvy]

If there is no instance of IE open and you pass it a URL of a web page, what
do you want to happen?

 

[Peter Beach]

Hi Tom,

Experimenting I find that (XL 2000 Win 2000) that a new IE window is opened
regardless of whether an instance is already running, or whether the
NewWindow parameter is True or False.

Looks like a bug to me, or I've stuffed up something in my IE settings <g>.

Regards,

Peter Beach

 

[Tom Ogilvy]

If you open the workbook with the macro in a web browser and run the code,
it opens in the existing window. If set to True, it opens a new browser
window with the page displayed. (xl97, Win 98SE).

 

[Peter Beach]

Hi Tom,

Ah, opening it in the browser was the trick I missed :-( Can't think why I
missed it, a browser seems such an obvious host for a spreadsheet <vbg>.

Regards,

Peter Beach