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