| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing all files in a folder
Ok, at the end of my sub, I want to have the print dialogue box pop up,
let the user choose a printer, and then print all the files in a folder, say C:/Sales TIA, Mike *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing all files in a folder
Try this:
Application.Dialogs(xlDialogPrint).Show or response = Application.Dialogs(xlDialogPrint).Show Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Michael Smith" wrote in message ... Ok, at the end of my sub, I want to have the print dialogue box pop up, let the user choose a printer, and then print all the files in a folder, say C:/Sales TIA, Mike *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing all files in a folder
try these and see which is appropriate
application.Dialogs(xlDialogPrinterSetup).Show application.Dialogs(xlDialogPrint).Show -- Regards, Tom Ogilvy "Michael Smith" wrote in message ... Ok, at the end of my sub, I want to have the print dialogue box pop up, let the user choose a printer, and then print all the files in a folder, say C:/Sales TIA, Mike *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing all files in a folder
Ok the printersetup dialogue box is just what I need, now how do I Print
all files in a folder *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
| Copying all files in a folder to new folder | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| How to copy 30 csv files from a folder to another folder | Excel Programming | |||
| Printing to PDF Goes to Wrong Drive/Folder | Excel Programming | |||
Linear Mode
