Code for checking link to Excel workbook (1 Viewer)

[ChristopherM]

Does anyone know of some simple code (access 97) to check/refresh a link to an Excel spreadsheet - I have adapted the Nwind example to link the program to an external Access DB but am not sure how the Dim statement etc should work for a spreadsheet and if you have to justspecify the workbook or a specific sheet.

Thanks