Help with writing a macro to select & ID a printer.

[Rene'48]

Hello Tech Support,

I am writing a macro in excel 2003:

1. What command my macro that will allow the print icon to come up without
out having to use activesheet.printview? Currently the printview will be
displayed. Then I have to select the print button before I can select the
name of the printer I want.
2. Currently I have to ask the user to enter in a cell in excel an A for
Adobe PDF print format or P for a local printer so that my macro will use the
correct setup for the printview. I want to know is there macro code that
will identify the default printer or the type of printer you selected in the
print icon without having to enter the name of the printer in a cell.

Thank you for your help.

Rene’

 

[The Code Cage Team]

This line brings up the printer selection dialogue
Code
-------------------
Application.Dialogs(xlDialogPrint).Show
-------------------

Hello Tech Support,

I am writing a macro in excel 2003:

1. What command my macro that will allow the print icon to come u
without
out having to use activesheet.printview? Currently the printview wil
be
displayed. Then I have to select the print button before I can selec
the
name of the printer I want.
2. Currently I have to ask the user to enter in a cell in excel an
for
Adobe PDF print format or P for a local printer so that my macro wil
use the
correct setup for the printview. I want to know is there macro cod
that
will identify the default printer or the type of printer you selecte
in the
print icon without having to enter the name of the printer in a cell.

Thank you for your help.

Reneâ€

--
The Code Cage Tea

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com