Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Auto print macro for excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Akash - 26 Apr 2008 08:29 GMT
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
Gord Dibben - 26 Apr 2008 16:23 GMT
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

>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
Akash - 27 Apr 2008 09:16 GMT
> You do not provide much information that would allow anyone to give you a
> specific set of code.
[quoted text clipped - 21 lines]
>
> - 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.