Requesting a macro for printing an Excel sheet automatically as PDF on daily basis.

[aneshdas]

Friends,


Can you help me by providing a macro for Printing a Page as PDF on daily basis.


More clearly, I have an excel sheet and I am entering data on it everyday. I need that page to be saved as PDF on everyday on a particular time. for example at 12:00 pm I need that page to be saved as PDF in a particular folder with that particular date as file name. can you help me please..

[westconn1]

you can use application.ontime to automate the saving at a particular time, as long as excel is running
you can call application.ontime from workbook open event, or if workbook is always open call it recursively from the called procedure (or both). to cover if workbook is closed by system down