Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print job
I have an excel file and macro that fills in a form for each employee.
The forms fills in the individual's data and the form prints. The macro selects the next employee fills in the form and prints. This continues until the last employee is printed. Is there a way to print as one print job instead of multiple print jobs? Thanks. -- Bonita |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print job
I suspect you would need to create you outpot on one sheet or multiple sheets
and then print. I don't think you can "stream" your output to the printer using Excel's built in print capabilities. -- Regards, Tom Ogilvy "Bonita" wrote: I have an excel file and macro that fills in a form for each employee. The forms fills in the individual's data and the form prints. The macro selects the next employee fills in the form and prints. This continues until the last employee is printed. Is there a way to print as one print job instead of multiple print jobs? Thanks. -- Bonita |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print job
Thanks!!
-- Bonita "Tom Ogilvy" wrote: I suspect you would need to create you outpot on one sheet or multiple sheets and then print. I don't think you can "stream" your output to the printer using Excel's built in print capabilities. -- Regards, Tom Ogilvy "Bonita" wrote: I have an excel file and macro that fills in a form for each employee. The forms fills in the individual's data and the form prints. The macro selects the next employee fills in the form and prints. This continues until the last employee is printed. Is there a way to print as one print job instead of multiple print jobs? Thanks. -- Bonita |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
Macro to hide rows with a certain cell empty then set print area and print | Excel Programming | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook | Excel Programming |