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