If you have Acrobat on the machine, you could print to Acrobat as the printer, but that would demand more of your user, as I think Acrobat makes you set up the format etc.
I don't have much experience with Excel VBA, so cannot comment on the difference.
|