vba variable assistance

[cmefly]

Hi,

I have a worksheet with a link to another xls file.

Using VBA, how do i assign a variable to THAT existing link?

thanks,

Marc

 

[cmefly]

Bump

 

[mikerickson]

Do you mean something like this code (in Workbook1.xls)

Dim otherBook as Workbook

Set otherBook = Workbooks("otherWorkbook.xls")