Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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)


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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)




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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)






  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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)






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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)










  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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)










  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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)












Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink not working sanket Excel Worksheet Functions 2 February 8th 10 05:58 PM
Paste Hyperlink result as working hyperlink Bod Excel Worksheet Functions 2 January 22nd 10 04:22 AM
Hyperlink to PDF not working Tim Excel Discussion (Misc queries) 1 November 12th 09 01:32 PM
not working hyperlink after save news.microsoft.com[_4_] Links and Linking in Excel 1 October 4th 07 05:43 PM
Hyperlink not working... neilcarden Excel Worksheet Functions 1 June 22nd 06 09:10 AM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright İ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"