UserForm Question
 

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

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

UserForm Question
 

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/

UserForm Question
 

Thanks, this works perfectly!

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


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