You should read this thread, so you get an idea of what's happening, and then use a similar fashion with your VBA:
http://www.daniweb.com/techtalkforums/post85128-2-15.html
Basically, figure out the path to adobe's acrobat, then load it with a shell command, and pass it the switches needed to print. Let me know if I should elaborate more.
Comatose
Taboo Programmer
2,910 posts since Dec 2004
Reputation Points: 361
Solved Threads: 215