RefreshAll data source Excel from Word
Hi all,
I want to be able to refresh all data saved in an excel spreadsheet. This data is the result of an ODBC connection to a MySQL database. Basically I want to make sure that the mail merge in Word can take advantage of updated data on the Excel sheet.
My problem is that I don't know if it's possible to open my Word document and start the refreshing on the Excel file (via VBA).
Do you have a tip or an example that can help me?
Many thanks.
AS
|