ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print from multiple closed files in a folder (https://www.excelbanter.com/excel-programming/435294-print-multiple-closed-files-folder.html)

b1llt

Print from multiple closed files in a folder
 
What VB code would allow me to print a range out of multiple files within a
folder only if data exisits within that range?
Thanks,
B1llt

joel[_64_]

Print from multiple closed files in a folder
 

I would open each book and create a summary sheet/book and then at the
end of the macro print the results.

You have to open each workbook, determine if the data matches your
requirements, and then print the results (or copy the data to a summary
sheet) .


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146983



All times are GMT +1. The time now is 07:28 PM.

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