I have a VB 6 program that has a scheduler built in. You should be able to create a schedule and select a ms excel report, specify date and time and frequency to run report on.? You should also be able to select if the report shoudl go to email recipients, specific printer, and or file path.
I already have the output subrouting ready in a vbscript that is called from the vb6 program using wscript shell, so the actual report creating there is not need to worry. I am passing some arguments to the shell vbscript file - basically just range of report.
This is relatively easy - I just do not have time to debbug some issues that are occuring when tryint to wrtite to the ADODB database- sometimes it stays locked or open.
## Deliverables
I have attached the current project with the access Database that has to reside in the c:/? drive. When you run the program in vb6, the program auto-minimizes to the taskbar and require sthat you right click and select settings.