ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Word Documents from Excel (https://www.excelbanter.com/excel-discussion-misc-queries/191133-printing-word-documents-excel.html)

Richard

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


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com