Excel document print
i need to print an Excel document at 4:00 PM every day which is in LAN and
shared across by many people. i wanted this process to be automated. i mean i wanted that Excel should automatically give the print command at 4:00 PM every day . any solutions for this i got one solution in terms of Ontime method in macro but can any body tell me the how to code and the complete procedure for it .......i dont know which parameters i need to pass in onTime method . thanks Tanu |
Excel document print
try something like this:
Application.OnTime TimeValue("16:00:00"), Application.Dialogs(xlDialogPrint).Show hope this helps! -chad "Tanu Gulati" wrote: i need to print an Excel document at 4:00 PM every day which is in LAN and shared across by many people. i wanted this process to be automated. i mean i wanted that Excel should automatically give the print command at 4:00 PM every day . any solutions for this i got one solution in terms of Ontime method in macro but can any body tell me the how to code and the complete procedure for it .......i dont know which parameters i need to pass in onTime method . thanks Tanu |
Excel document print
well thanks for giving the hint for the below mentioned question, but i am
looking for printlng the document , in your code you have not mentioned where i am instructing the computer to print and where i need to write the code ....please specify "Chad" wrote: try something like this: Application.OnTime TimeValue("16:00:00"), Application.Dialogs(xlDialogPrint).Show hope this helps! -chad "Tanu Gulati" wrote: i need to print an Excel document at 4:00 PM every day which is in LAN and shared across by many people. i wanted this process to be automated. i mean i wanted that Excel should automatically give the print command at 4:00 PM every day . any solutions for this i got one solution in terms of Ontime method in macro but can any body tell me the how to code and the complete procedure for it .......i dont know which parameters i need to pass in onTime method . thanks Tanu |
Excel document print
This code can be put either in the Workbook_Activate or
Workbook_SheetActivate sub, or so on, depending upon when you want it to display. -Chad "Tanu Gulati" wrote: well thanks for giving the hint for the below mentioned question, but i am looking for printlng the document , in your code you have not mentioned where i am instructing the computer to print and where i need to write the code ...please specify "Chad" wrote: try something like this: Application.OnTime TimeValue("16:00:00"), Application.Dialogs(xlDialogPrint).Show hope this helps! -chad "Tanu Gulati" wrote: i need to print an Excel document at 4:00 PM every day which is in LAN and shared across by many people. i wanted this process to be automated. i mean i wanted that Excel should automatically give the print command at 4:00 PM every day . any solutions for this i got one solution in terms of Ontime method in macro but can any body tell me the how to code and the complete procedure for it .......i dont know which parameters i need to pass in onTime method . thanks Tanu |
All times are GMT +1. The time now is 03:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com