The below working code copys cells from an open workbook and then opens the
target workbook and pastes the copied cells as links from the other
workbook. How can I make the below operation work without having to
actually open the target workbook located in "Workbooks.Open
Worksheets(4).Range("A6").Value"


Workbooks.Open Worksheets(4).Range("A6").Value
Range("A1").Select
ActiveSheet.Paste Link:=True


Thank you

Todd Huttenstine