ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hyperlink is not working (https://www.excelbanter.com/excel-programming/279987-hyperlink-not-working.html)

F. Muecke

hyperlink is not working
 
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:21...wPage=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)



Tom Ogilvy

hyperlink is not working
 
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.

--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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:21...wPage=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)





Tom Ogilvy

hyperlink is not working
 
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.
--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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.

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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:21...wPage=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)









F. Muecke

hyperlink is not working
 
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

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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:21...wPage=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)







F. Muecke

hyperlink is not working
 
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.

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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:21...wPage=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)







F. Muecke

hyperlink is not working
 
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!

"Tom Ogilvy" wrote in message
...
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.
--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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.

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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:21...wPage=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)











F. Muecke

hyperlink is not working
 
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

"F. Muecke" wrote in message
...
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!

"Tom Ogilvy" wrote in message
...
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.
--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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.

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

F. Muecke wrote in message
...
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:21...wPage=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)














All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com