you need to create a link formula in VBA. Open the file within the sam
excel app and put "=" in a cell then select the cell in the othe
workbook you are trying to link too. Then close the other workboo
(the one you are linking too). Then take a look at the formula in th
cell, you will need to duplicate this in vba code.

Keith
www.kjtfs.co

--
Message posted from http://www.ExcelForum.com