Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
malycom
 
Posts: n/a
Default Print Multiple Workbooks

Hi

In the past, we have created a spreadsheet which creates a new worksheet
containing statements for all clients from another worksheet. This new
worksheet may hold 700 statements but this is fine.

We have recently had some software created which is excellent apart from
now, the statements are created as individual workbooks in a folder. THis is
run every 2 months so every two months, a new folder is created with all new
workbooks in.

I need help in finding a way to be able to print all workbooks without
having to open each one individually and selecting print. Very time
consuming.

I am aware that this is probably going to be some coding of some sort, so
could you please be as descriptive as possible as I am not a programmer of
any sort.

Any help is greatly appreciated.

Thanks in advance

Malcolm
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing source on multiple workbooks charlilot Links and Linking in Excel 1 January 26th 06 09:08 PM
Multiple Workbooks Summary tcgaines Excel Worksheet Functions 0 December 13th 05 05:31 PM
Multiple Print areas in same sheet? Enzo Excel Discussion (Misc queries) 4 August 29th 05 07:58 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 PM
adding certain cells in multiple worksheets in multiple workbooks Stephen via OfficeKB.com Excel Worksheet Functions 1 February 4th 05 08:31 PM


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"