Refresh Excel link to Access

Does anyone know how to refresh an Excel spreadsheet from
code in Access?

I have a spreadsheet linked to an Access query and a
Powerpoint presentation linked to the Excel spreadsheet.
I need to refresh the Excel data and save the file and
then refresh Powerpoint.

I can refresh the Excel data with suitable code in the
Workbook_Open module e.g. ActiveWorkbook.Refreshall but
that means I have to open and close the spreadsheet
manually.

If I try to incorporate similar code in an Access
procedure by setting up a reference to the Excel
application object then an error is generated when it
tries to refresh the data - the user is prompted to login
to Access and 'ODBC MS Access Driver Login Failed' is
displayed.

If I can refresh the Excel spreadsheet OK is there similar
code to refresh the Powerpoint charts as well?

Thanks

Mike Collard

I take it that when you say you can refresh the data in the Excel spreadsheet that you have a Macro tied to the Access DB and this runs when the spreadsheet opens. (thus you have to open and close). If you create a new menu item and tie it to the same macro then you should be able to select the same thing from a menu.

Look at how to create CommandBars and CommandBarControls in your excel Help file.

The menu creation items are Office wide so there should be a representative ability in PowerPoint also. (I have never worked with powerpoint so this is a presumption).