View Single Post
 
Old 08-31-2021, 09:19 AM
As1900 As1900 is offline Windows 10 Office 2019
Novice
 
Join Date: Aug 2021
Posts: 1
As1900 is on a distinguished road
Default 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
Reply With Quote