Printing Reports to a file

[natatbh]

I want to Print Reports to a file using vba code. I'll explain exactly what I do without vba code and I whould like to know how to do it using vba code.
In a Mirosoft Access program I select a report. I then go to the menu and click 'print' which brings up a dialog box. In the dialog box I select the 'print to a file' checkbox.
This brings up another dialog box that prompts me for destination to print the file to. I enter a path and click OK. The report is then printed to that location as a postScript file. I want to accomplish all this using vba code and without any interaction from the user. Any Idea, Please help.

Thanks,
natatbh

 

[gwog]

I don't know very much about VBA Code. But what if you created a macro that used TransferSpreadsheet? You could then specify the table or select query to export (not sure about report?) and where to export it to.

I don't know if this helps at all - but maybe it will at least give you another direction to think in. I know for me, sometimes I just get stuck and need a push in a new directtion of thinking.

 

[CosmoKramer]

Check out Access help for the Output To method. This should be what you're looking for.....

 

[evilmousse]

there's no poscsript acformat for outputto.