automatic hyperlink of file list in excel

I require help on macro , couldnt find this issue anywhere else in this forum.

I have a list of names(around 500 mech parts) in excel 2003.Eg: "5922 X0E". These names can be converted to filenames if the spaces in between are removed. I have pooled all the files with these filenames in server directory(\\Server\ABC).

I need a macro which automatically hyperlinks the excel list to original files (which is .dwg). If i could assign a software with which the files would open, it would be added advantage.

so basically:

1. remove spaces in column A text
2. hyperlink to file with this name, in network directory
3. assign software to open the link with (solidworks viewer)

have been searchin for solution since 1 week Pl give me some magic script.