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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Closing Workbook then Activating Other Wb with Userform showing? 1
Userform to Select what worksheets to print 1
closing another file by code causes failure to run workbook activate event 2
Userform within a userform ... 7
VBA Code== Goto a webpage using a command button in a UserForm 14
UserForm 8
Modeless dialog box appears twice on screen??? 1

Back
Top