VBA: Print dialog box 
Author Message
 VBA: Print dialog box

I tried to use line "Sheet1.CommonDialog.ShowPrinter" to display Print
dialog box but I always get an error "METHOD OR DATA MEMBER NOT FOUND"
pointing at the word "CommonDialog".
I checked that the library "MSComDlg" contains class "CommonDialog".
Any ideas!?

jamcik



Wed, 09 Feb 2005 03:39:08 GMT  
 VBA: Print dialog box
Hi jamcik:

Use:

Application.Dialogs(xlDialogPrint).Show
--
Regards,

Vasant.

I tried to use line "Sheet1.CommonDialog.ShowPrinter" to display Print
dialog box but I always get an error "METHOD OR DATA MEMBER NOT FOUND"
pointing at the word "CommonDialog".
I checked that the library "MSComDlg" contains class "CommonDialog".
Any ideas!?

jamcik



Wed, 09 Feb 2005 12:39:56 GMT  
 VBA: Print dialog box
Jam,
The command to use is
Application.Dialogs(xlYourNumberHere).Show
where "xlYourNumberHere" is an index into the built-in dialogs; see the
Dialogs collection in online help.  The code for your particular case
is xlDialogPrint.

HTH
Dave Braden

Quote:

> I tried to use line "Sheet1.CommonDialog.ShowPrinter" to display Print
> dialog box but I always get an error "METHOD OR DATA MEMBER NOT FOUND"
> pointing at the word "CommonDialog".
> I checked that the library "MSComDlg" contains class "CommonDialog".
> Any ideas!?

> jamcik

--



Wed, 09 Feb 2005 20:30:06 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Suppressing the Print Dialog box when printing a report via VBA

2. VBA access to excels print dialog box

3. Suppress Printing dialog box using VBA

4. VBA code for Print Dialog box

5. Powerpoint - VBA: Help with Custom Print Dialog Box

6. How to get print dialog box using VBA code

7. Getting the Print Dialog box from VBA

8. Need help with VBA SendKeys to print driver's dialog box

9. VBA exel 97 list boxes in dialog box

10. print properties dialog box to come up before printing report


 
Powered by phpBB® Forum Software © phpBB Group