![]() |
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) |
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) |
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) |
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) |
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) |
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) |
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