Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2021, 09:19 AM
As1900 As1900 is offline RefreshAll data source Excel from Word Windows 10 RefreshAll data source Excel from Word Office 2019
Novice
RefreshAll data source Excel from Word
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
RefreshAll data source Excel from Word Merge same excel data source in two columns Marcia Mail Merge 1 07-25-2019 02:27 PM
Excel spreadsheet as a data source stored within a word document slaycock Word VBA 0 03-19-2017 11:36 AM
RefreshAll data source Excel from Word Excel data linked to external source Doug Needham Excel Programming 1 09-15-2015 05:14 AM
Merge fields in Word and source data from Excel SteveVai Mail Merge 3 03-13-2014 05:25 AM
RefreshAll data source Excel from Word How to dynamically link imbedded Excel chart with source data from Word TBoz Excel 1 07-06-2012 05:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft