Hi,

I have developed a VBA code which attaches the file which in present in a
cell...by taking its value like this
Column D
E:\Safi\acb.xls
but the hyperlink is used to get the full file path name to be
attached...this works great..when the file is in drives D:, and so on....
other than the files in C: drive

Example if I Pick a file through Hyperlink from a desktop or my documents

it is showing like this..

...\server\my documents\abc.xls

but i want to have the complete file path name as it was in D,E,F drive.....

as it is not attaching the file if i pick the file from C: drive..

Thanks in advance.
Safi.