batch linking word documents in excel sheet

nelliboi

New Member
Joined
Dec 5, 2005
Messages
2
Hi,
I have a excel file with a column that has thousand od items.
Each item must be linked to a word document with same name.
Is there a easy way do do it.
Now I am hyper linking each file one by one.
Please note that item name and file name are same, but item name doesn't have the extention .doc
Your help is highly appreciated.
Regards
Nelson
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,088
Members
412,310
Latest member
mark884
Top