hyperlink is not working

  • Thread starter Thread starter F. Muecke
  • Start date Start date
F

F. Muecke

Hi,

within a makro, i import stuff from a web database in order to control
change requests worked of eithin this database.

after this procedure there are lots of hyperlinks like
http://erls3iga.ww007.siemens.net:2180/loba/dispatcher.asp?NewPage=Packages.
asp&NewPars=action§§display§§unqid§§40C6407C-266D-4A40-9EF4-84FADC9855A1
(This is some Intranet thing, the link won't work at WWW)

If i copy&paste the Hyperlink with IE, everything is fine.
The correct page is opened
If i copy&paste to mail, again everything is fine.
But from within the excel-sheet this link does not work - even if i do the
stuff manually.

Is Excel 're-parsing' before calling or do the '=' within the link disturb
excel or ... ?

Any Idea will be helpful.

regards, Fritz

(Spam avoiding: Delete CRLF and blanks to contact me with e-mail ...
Friedrich . Muecke @
siemens . com)
 
if you right click on the cell and choose edit hyperlink, does it look
proper? Does it offer hyperlink as a popup menu option? If not, excel
isn't seeing it as a hyperlink.
 
Try setting up the hyperlink manually by browsing to the correct location.
Compare what is built there with what your link looks like and see if there
is a difference.

This character looks funny §§

Maybe it is a font or language setting thing.
 
If i right click, it offers 'edit hyperlink'.
if i choose 'edit hyperlink' and copy the line 'address' to the url-line in
IE or to a mail body, the link works as expected.

regards, fritz
 
btw.:

the behaviour shows the same wrong behaviour if i insert the link below into
a word *.doc

so this seems to be a systematic issue within office.
 
If i navigate there i the result that only the main page is displayed, but
the parameters for the *.asp are cut off.

.... i'll check this in depth tomorrow.

thanks for advice!
 
If i use

Dim IE : Set IE = CreateObject("InternetExplorer.Application")
and use the address of the hyperlink of the cell for opening thr url
everything is fine.

but i don't want to assign a makro for each cell (and i don't know how to do
that ...)

any additional advice?

regards, fritz
 
Back
Top