Thread: [Solved] How to import list from Excel into drop-down list into word
View Single Post
 
Old 08-21-2016, 04:12 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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
Have you done all that the instructions in post #2 say you need to do? Did you
• set a reference to Excel?
• edit the StrWkBkNm line to point to your workbook-
StrWkBkNm = "C:\Users\" & Environ("Username") & "\Documents\Workbook Name.xls"
• edit the StrWkShtNm line to point to your worksheet-
StrWkShtNm = "Sheet1"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote