There is a profile has been assigned to this network printer. this profile
has setup sepcificly for an Excel report. by choosing this profile, user
doesn't need to set up the property each time, for example, print on both
side, legel paper...etc. we have finished the code that select this network
printer as a default printer. the problem is how to select this profile from
the printer through macro. user just wants to click on the 'Print' button
from the macro then get the print out from the printer. no more click.

"Dave Peterson" wrote:

I'm not sure what a printer profile is, but maybe you can just show the user the
screen to select the printer???

Application.Dialogs(xlDialogPrinterSetup).Show
or
Application.Dialogs(xlDialogPrint).Show



BJ wrote:

we have a profile set up in a network printer. are there anyway to select
this profile using VBA macro?

thank you for any help.

--

Dave Peterson