RefreshData

[bhofsetz]

another simple piece of code that won't work for me.

this is supposed to update the links to data.xls but it keeps giving me run errors.

any help?

>
Sub RefreshData()
ThisWorkbook.UpdateLink Name:="I:\Data.xls", Type:=xlExcelLinks
End Sub
>

thanks

[bhofsetz]

and yes, the data.xls file is on the I:\ directory

[anilsolipuram]

Sub RefreshData()
ThisWorkbook.UpdateLink Name:="I:\Data.xls", Type:=xlExcelLinks
End Sub

this code will work only if the present file, the file where the macro is as a cell which as reference to "i:\data.xls" workbook.

[bhofsetz]

Thanks, I don't believe I overlooked that.