mike31z
07-11-2012, 08:47 AM
I have a code error that I have assigned to a Macro that worked in excel 2000 and now it doesn't work in excel 2007.
Below is the code that worked in excel 2000.
ActiveWorkbook.UpdateLink Name:="R:\REGteam12.xls", Type:=xlExcelLinks
I tried to add an x to the file REGteam12.xlsx I get an error
" Runtime error '1004' Method 'updatelink' of Object '_workbook' failed"
I think it a version difference for the code but I don't know how correct the code.
Thanks for looking
Mike in Wisconsin
Below is the code that worked in excel 2000.
ActiveWorkbook.UpdateLink Name:="R:\REGteam12.xls", Type:=xlExcelLinks
I tried to add an x to the file REGteam12.xlsx I get an error
" Runtime error '1004' Method 'updatelink' of Object '_workbook' failed"
I think it a version difference for the code but I don't know how correct the code.
Thanks for looking
Mike in Wisconsin