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

This line brings up the printer selection dialogue
Code:
--------------------
Application.Dialogs(xlDialogPrint).Show
--------------------
, your print should be outputted according to the printer selected!Rene'48;199747 Wrote:
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

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54989