UserForm Question

A

abxy

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

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

Tom Ogilvy

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

abxy

Thanks, this works perfectly!

one last thing though...how would i get it to print out 3 copies?
 
Top