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 ***

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 ***

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 ***

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 ***