workbooks.open "c:\whatever_my_path_is\Book1.xls"
ActiveWorkbook.Worksheets(1).Printout
Activeworkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy

"abxy " wrote in message
...
I'm trying to make a command button on my UserForm to print Sheet1 of a
different workbook. How can I do this?

eg, clicking command button1 will print:
C:\whatever_my_path_is\[Book1.xsl]Sheet


---
Message posted from http://www.ExcelForum.com/