[SOLVED:] Excel-like CHANGELINK from Access VBA [Archive]

View Full Version : [SOLVED:] Excel-like CHANGELINK from Access VBA

Manslay

09-30-2013, 10:34 PM

Hello.

Could you please tell me if it is possible to change Excel sheet links from Access VBA code, like that Excel function Changelink(Name,NewName,Type)?

Manslay

10-01-2013, 12:23 AM

Okay, it just doesn't work as myWorkBook.Changelinks, but works as myWorkBook.ActiveWorkbook.Changelinks.
The problem solved :P