Auto print macro for excel

  • Thread starter Thread starter Akash
  • Start date Start date
A

Akash

Hi all
I want a macro that will atuomatically print my 3 different excel docs
at 3 different times on given printer. Waiting for help/
Akash
 
You do not provide much information that would allow anyone to give you a
specific set of code.

What are the "different times"? Minutes, hours or days apart?

Are the three workbooks printer-ready as far as print setup?

Turn on the macro recorder and select a workbook to print on a specific printer.

Once you get the code for one workbook, see Chip Pearson's site for instructions
on how to use the OnTime event so's you can schedule the times to print each
workbook.

http://www.cpearson.com/excel/OnTime.aspx

Maybe Windows Task Scheduler might be a better tool for this?


Gord Dibben MS Excel MVP
 
You do not provide much information that would allow anyone to give you a
specific set of code.

What are the "different times"?  Minutes, hours or days apart?

Are the three workbooks printer-ready as far as print setup?

Turn on the macro recorder and select a workbook to print on a specific printer.

Once you get the code for one workbook, see Chip Pearson's site for instructions
on how to use the OnTime event so's you can schedule the times to print each
workbook.

http://www.cpearson.com/excel/OnTime.aspx

Maybe Windows Task Scheduler might be a better tool for this?

Gord Dibben  MS Excel MVP



- Show quoted text -
Click to expand...

Hi Dibben,
My single workbook contains 5 sheets. I want that each day this
workbook to be automatically saved with name WORKBOOKNAME_TODAYSDATE.
Then I want prints of only 3 sheets in that saved workbook each day.
One sheet at 6.00 am, one sheet at 2.00 pm and remaining one at 10.00
pm. Can this be done in excel?
These sheets are shift reports configured using PI.
/Akash
 
Back
Top