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

On Sat, 26 Apr 2008 00:29:29 -0700 (PDT), Akash <akashkadam2000@gmail.com>
wrote:

>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

On Apr 26, 8:23*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> 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
>
> On Sat, 26 Apr 2008 00:29:29 -0700 (PDT), Akash <akashkadam2...@gmail.com>
> wrote:
>
>
>
> >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- Hide quoted text -
>
> - Show quoted text -

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