Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print range within file
Hi
How can I use a macro to print a specific range in an Excel workbook to for all the file within a specific folder. I would prefer it if the printing can be done without the need to open the workbooks? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print range within file
You cannot print Excel files without Excel. But you can select a group of
Excel files in Windows Explorer, right click and select Print. This will print the active sheet in each selected file (or the range "print_area" on the active sheet if it exists). If you need more than the active sheet in each file printed I think you'd have to use a macro that opens and each workbook and does the printing. -- Jim "nc" wrote in message ... | Hi | | How can I use a macro to print a specific range in an Excel workbook to for | all the file within a specific folder. I would prefer it if the printing can | be done without the need to open the workbooks? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my excel is converting all my print jobs to print to file why? | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
Can view file in print preview, but not print layout.... | Excel Discussion (Misc queries) | |||
How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) |