Printing

[smith.james0]

Is there any way of getting my computer to automatically print a work
sheet everyday?

James

 

[Guest]

Is there any way of getting my computer to automatically print a work
sheet everyday?

Have a look at Scheduled Tasks in Control Panel

 

[smith.james0]

I have got it to open the file. I just don't know how to get it to prin
:confused

 

[anilsolipuram]

this will automatically print the excel sheet whenever the excel
workbook is opened, you to copy this code in "this workbook" at vba
editor, save it and close it.Now whenever the file is opened, it
prints.


Private Sub Workbook_Open()
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

 

[smith.james0]

Do i click on the work sheet i want to print, as there is six sheet
containing about 50 ish pages I only need to print work sheet

 

[anilsolipuram]

I am assuming that Sheet6 is the name of sheet 6, change the name if it
is different than that.

you have to copy this code in "this workbook" at vba editor, save it
and close it.Now whenever the file is opened, it prints sheet6.



Private Sub Workbook_Open()
Sheets("Sheet6").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
end sub

 

[smith.james0]

Thankyou :

 

[abcd]

also try
(Sheet6 is supposed to be the VBA name of the sheet, this way you can
change the name of the sheet)

Private Sub Workbook_Open()
Sheet6.PrintOut Copies:=1
end sub