I have an Excel spreadsheet that contains tables that are linked to my Access database.
The spreadsheet contains the code ThisWorkbook.RefreshAll to automatically refresh
the data when it is opened. I need to automatically refresh these links from within Access
and email the spreadsheet via Outlook.
What Access VBA code would I use to do this
Thanks
Can you post the code you have so far?