Thread: [Solved] Word VBA help to copy cell info from Excel to Word
View Single Post
 
Old 03-04-2015, 12:43 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
If you are going to have users manually selecting ranges as part of the process, you need to do this from Excel. You could create the code in an Excel add-in and distribute that instead.

However it could be practical to run it from Word, if the ranges were known in advance, but from your description that does not appear to be the case.

I would think the only practical solution for working in Word would be to read the selected worksheet into a Userform list box, then allow the user to pick the records to be transferred to the document. The formatting would then have to be applied in Word.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote