View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Printing Word Documents from Excel

MS OS XP, Excel 2003

In Excel I have a list of names, Word Documents and Printers.
I need to be able to print different Word documents to different people on
different printers.
I know how to get all the data onto one spreadsheet.

Name, Document Path,
Printer Name
George, C:\Documents and Settings\Gary Burton\Desktop, Printer Name on FS001

Name Document Path
Printer Name

George Brown C:\Documents and Settings\Gary Burton\Desktop My Printer on FS001

Mary Smith C:\Documents and Settings\Gary Burton\Desktop Your Printer on FS002

John Thomas C:\Documents and Settings\Gary Burton\Desktop Test Printer on
FS003

I have created the above table in Excel. What VBA code do I need to print
from the Excel table above?

Thanks in Advanced.

--
Richard