Hyper link

[Sridharan]

I am having some file names which are created by my Cad system with character
#.

I am unable to use these files names in excel as hyperlink.

for example: I am unable to create a hperlink fro a file withname as -
C:\test\test#.txt

 

[Jan Karel Pieterse]

Hi Sridharan,

I am having some file names which are created by my Cad system with character
#.

I am unable to use these files names in excel as hyperlink.

That is something that cannot be changed, # is a special character within Excel
hyperlinks and thus if it is within the filename Excel gets confused.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Sridharan]

Hi Jan,

Thank you for the response.

Is there any trick or work around it?

thank you,

Sridharan

 

[Jan Karel Pieterse]

Hi Sridharan,

Is there any trick or work around it?

Not that I know of, but then again, I don't know everything there is to know
about Excel either...

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com