printing excel worksheet from macro in another workbook

how can i print all or part of a worksheet from a macro in another workbook? the worksheet will definitely be open + i might need to print the entire worksheet or 1 or 2 of the 3 pages maximum.

i was thinking it might be something like:

Please Login or Register  to view this content.

but thats as far as i got.

second question, how do i save the workbook with a new name, again from a macro in another workbook?

You can't use activesheet unless the workbook is active

try the below. Change sheet 1 to sheet to print

Please Login or Register  to view this content.

to print all sheets try

Please Login or Register  to view this content.

to save it something like

Please Login or Register  to view this content.

VBA Noob