asked on Access VBA email a spreadsheet with linked tables
Hi
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
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
Microsoft AccessMicrosoft Excel
Last Comment
Murray Brown
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks very much. Sorry about late reply
Can you post the code you have so far?