Automate Excel Print with Access Macro

[philip260]

Hello all.

I'm running queries that dumps data to excel spreadsheets to form a
report every morning on a timer form in access. These reports are then
manually ran from an access button that opens the excel reports and
then i have to manually print it out. This process takes about 20 min
or so and i wanted to know if there is a way to automate the process.
Is there a way that i can automatically print these excel spreadsheets
from access? Like a xlwork.print function or something. I would like to
put something in the timer form that states that at a certain time in
the morning after the append queries have ran, these reports will run
into excel and print it automatically and then close the report once it
is done. Is this possible? Any help would be appreciated. Thanks!!!

 

[Joel Allen]

I have a report that I genterate everyday also. I run a macro that runs a
query. I have this set up on a timer from Windows scheduler to runs
everyday at noon. In the macro, you could set another Action to print.
That seems like it would do what you need it to do.

Joel