Im using Workbooks.Open Filename and id like to have a variable in the link so that i can refer to the contents of a cell in the link, so it would read Workbooks.Open Filename:= (the contents of some cell).xls. I need to run the macro several times with different workbooks each time, so instead of editing the macro each time id like to just input from the spreadsheet. Thanks!