UserForm Question

  • Thread starter Thread starter abxy
  • Start date Start date
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
 
workbooks.open "c:\whatever_my_path_is\Book1.xls"
ActiveWorkbook.Worksheets(1).Printout
Activeworkbook.Close SaveChanges:=False
 
Thanks, this works perfectly!

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