Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Batch printing of excel files
Hi,
I'd like to print off 3 excel files in seperate folders in one go. Instead of having to open them up individually and print them. What would be the best way to do this? I'm asking in the VBA newsgroup because I have a resonable grasp of VBA and would imagine it would require coding to achieve. thanks in advance Gordo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Batch printing of excel files
You're going to have to open each workbook using the Workbooks.Open method
and then print each with the Printout method. All that can go in one macro so it can appear "in one go". -- Jim "Grd" wrote in message ... | Hi, | | I'd like to print off 3 excel files in seperate folders in one go. Instead | of having to open them up individually and print them. | | What would be the best way to do this? | | I'm asking in the VBA newsgroup because I have a resonable grasp of VBA and | would imagine it would require coding to achieve. | | thanks in advance | Gordo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I batch convert old excel 95/97/200/xp files to excel2003 | Excel Discussion (Misc queries) | |||
Batch print excel files | Excel Discussion (Misc queries) | |||
Batch renaming of many worksheets in Excel files? | Excel Discussion (Misc queries) | |||
Can I batch print several files at once with Excel? | Excel Discussion (Misc queries) | |||
How can I batch print Excel files? | Excel Programming |