Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone,
I have an Excel file that exports attachments from emails in a particular Outlook-folder to a folder on a hard-drive, makes a list of files in the latter, but then... I'd like to use the list of files that was devised by Excel to be printed in the order of that same list. I know, I know, I could have the Exporer-window open, showing the destination folder, select all files pressing Ctrl+A, right-click the bunch, select Print from the contextmenu and they would all be printed. But I wouldn't be an all-purpose Excel fanatic if I weren't looking for that final piece of craftsmanship that could make Excel print those files from my list, already on-screen. Besides, doing what I've just described would not necessarily mean the files would be printed in the order of the Excel list. Which means that having a perfectly sorted order of files to be printed would nonetheless still include: me, sitting behind a desk, (litterally) sorting things out. Not if I can help it. Or would that be ... Not if you can help it.? Example: Folder on hard-drive (=destination): D:\Scans to be handled Files within that folder: 823000.pdf 823001.pdf 823002.tif 823003.tif 823004.tif 823005.pdf 823006.pdf 823007.pdf 823008.tif 823009.tif 823010.tif I'd like our printer to print these files in the order mentioned above. I use Acrobat Reader for the pdf files and some kind of KODAK viewer for the ..tif files. Thanks in advance for your kind help. Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing pdf files from Excel 2007 | Excel Discussion (Misc queries) | |||
Printing multiple excel files | Excel Discussion (Misc queries) | |||
Excel printing to separate files | Setting up and Configuration of Excel | |||
Batch printing of excel files | Excel Programming | |||
Printing .pdf files from directory from excel | Excel Programming |