Executing code with opening target workbook
 

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

Executing code with opening target workbook
 

don't believe you can.

--
Regards,
Tom Ogilvy

Todd Huttenstine wrote in message
...
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