Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2006

Tip: Looking for answers? Try searching our database.

Printing all word documents in a folder.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
shd - 17 Oct 2006 19:32 GMT
I have written a macro that will print out all Word documents in a folder.

It works fine!!! All 30 or so files are sent to print in the order required.

Trouble is that the first 10  - 15 files (each a page or so long) go to the
print queue and sit there with a status of "Spooling". The next 10 (all 5 -
10 pages) go to the print queue, process, and start printing. The first 10 -
15 files then sort themselves out and print, followed by the last batch.

I have tried:
- put a delay of up to 20 seconds between each file print request.
- tried foregound vs background printing
- checked print settings for each print file.
- printed to printer and to prn file
- shutting down all unneccasary programs on the PC

All suffer the above problem, but not exactly the same, sometimes only the
first 5 - 10 files will stick in "Spooling" Status !

Anybody have any ideas????

Cheers
Nick Danger - 17 Oct 2006 21:51 GMT
Can't you just open the folder in Windows Explorer, select all the files you
want to print, then right-click, and select Print?
shd - 18 Oct 2006 14:04 GMT
> Can't you just open the folder in Windows Explorer, select all the files
> you want to print, then right-click, and select Print?

This macro is part of a development whereby a tutor can place specify a list
of files in a folder to be printed for a set of course handouts or a manual.
They will be able to specify the  number of copies of each file, whether
some will be printed in portrait / landscape , 1 / 2 sided, collated /
uncollated. They will be able to state how many print runs are required and
whether the files are to be collated or uncollated.

I have found snippets and sample code to set up the print management, but if
I can't ensure the order of the printing. all the other bells & whistles are
pretty pointless!
Jonathan West - 18 Oct 2006 15:10 GMT
>> Can't you just open the folder in Windows Explorer, select all the files
>> you want to print, then right-click, and select Print?
[quoted text clipped - 9 lines]
> if I can't ensure the order of the printing. all the other bells &
> whistles are pretty pointless!

This article shows you how to get a list of the files in a folder

Find & ReplaceAll on a batch of documents in the same folder
http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

Of course, you will want to replace the find/replace code with whatever you
need to do instead.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Steve2006 - 20 Oct 2006 17:23 GMT
Try this link

https://sourceforge.net/projects/folderprint

I hope this helps.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.