Hyper link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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
 
Hi Jan,

Thank you for the response.

Is there any trick or work around it?

thank you,

Sridharan
 
Back
Top