i tell u one trick copy this file with different name.
then add one macro in ur script which will be based on time e.g
if time = 8:00 A.M.
call macro pdf
then put test macro on open.
and then reload this application through batch file,whenver u want to take out pdf scehedule it on that time.
Thank you for the suggestion.
Understand that i can do as you suggested:
*. put the PDF generation at the onOpen trigger with a test condition.
1. reload the data i needed first
2. reload 2nd time and trigger the onOpen trigger then the pdf will be printed.
Tested and this suggestion is working.
However, is there any better ways?