Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2013, 11:06 AM
BradleyS BradleyS is offline Create DDL from Excel source Windows XP Create DDL from Excel source Office 2003
Novice
Create DDL from Excel source
 
Join Date: Jan 2013
Location: Suffolk, UK
Posts: 2
BradleyS is on a distinguished road
Default Create DDL from Excel source

Hi

I have a number of word documents that have the same list DDL content in each Word document.



However, when something changes in the DDL I then have to edit every document to change each DDL.

Is there a way I can enter the drop down list content into an Excel spreadsheet, that will automatically show in each of the DDL within each document, so I only need change the Excel source file for the changes to show in each Word document?

Thank you in advance.
Reply With Quote
  #2  
Old 01-30-2013, 10:58 PM
macropod's Avatar
macropod macropod is offline Create DDL from Excel source Windows 7 64bit Create DDL from Excel source Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What kind of drop-down are you using (eg formfield, useform combo-box, something else)? Do note that whatever the solution might be, it will entail vba programming.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create DDL from Excel source cannot start the source application for this object - Excel charlesmac Excel 3 08-15-2012 05:22 AM
Create DDL from Excel source drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
Auto Updating and Using Excel as Source Shugs81 PowerPoint 0 02-21-2012 03:25 AM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM
Create DDL from Excel source How can I revise Excel data source in merge? navysalad Mail Merge 6 01-07-2012 06:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:48 AM.


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