AW: xlDialogPrint Argumente
31.10.2003 16:47:35
Reinhard
Hallo Daniel,
x=Application.Dialogs(xlDialogPrint).Show(3) geht nicht, was geht ist sowas wie
x=Application.Dialogs(xlDialogPrint).Show(2,2,5,3) 'Seite 2-5, 3 Kopien.
Wobei, wie KRola schon sagte 2,2,5,3 nicht so erhellend ist, ich aber auch arg1,arg2 usw nicht so toll finde.
Leider fand ich keinen Dreh so was wie
...Show range_num=2 _ '1=Alle Seiten,2=Seietn von bis
from:=2 _
to:=5 _
copies:= 3
zu basteln.
Wie auch immer, vieleicht nützt dir die nachträgliche Beschreibung des alten Print() Befehls etwas, wo einige der Parameter erläutert sind.
Gruß
Reinhard
PRINT
Macro Sheets Only
Equivalent to choosing the Print command from the File menu. Prints the active workbook.
Arguments correspond to options, check boxes, and edit boxes in the Print dialog box. Arguments corresponding to check boxes are logical values. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box.
Syntax
PRINT(range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection)
PRINT?(range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection)
Range_num is a number specifying which pages to print.
Range_num Prints the following pages
1 All the pages
2 Prints a specified range. If range_num is 2, then from and to are required arguments.
From specifies the first page to print. This argument is ignored unless range_num equals 2.
To specifies the last page to print. This argument is ignored unless range_num equals 2.
Copies specifies the number of copies to print. If omitted, the default is 1.
Draft This argument overrides the draft argument from the PAGE.SETUP function. If omitted, the Draft Setting from the Page.Setup function is used.
Preview is a logical value corresponding to the Print Preview button in the Print dialog box. If TRUE, the print preview window will be displayed. If FALSE, the window will not be displayed
Print_what is a number from 1 to 3 that specifies what parts of the sheet or macro sheet to print. If a chart is active, print_what is ignored. This argument will override the setting in the Page Setup dialog box. If omitted, the note argument in the Page.Setup function is used to determine whether to print notes or not.
Print_what Prints
1 Sheet only
2 Notes only
3 Sheet and then notes
Color corresponds to the Print Using Color check box. Color is available only in Microsoft Excel for the Macintosh. If omitted, the setting is not changed.
Feed is a number specifying the type of paper feed. Feed is available only in Microsoft Excel for the Macintosh.
Feed Type of paper feed
1 or omitted Continuous (paper cassette)
2 Cut sheet or manual (manual feed)
Quality Specifies the DPI output quality you want. If omitted, the corresponding settings in the Page Setup dialog box will be used. If included, this argument overrides the quality argument in the PAGE SETUP dialog box.
Y_resolution corresponds to the Print Quality box in the Page Setup dialog box if you have specified a printer where the horizontal and vertical resolution are not equal, such as a dot-matrix printer. If omitted, the corresponding settings in the Page Setup dialog box will be used. If included, this argument overrides the print quality setting in the Page Setup dialog box.
Selection specifies what portion of the sheet to print.
Selection Portion printed
1 Prints the current selection from all selected sheets. For example, if A1:F40 is selected on the active sheet, A1:F40 will be printed from each of the selected sheets.
2 Prints the print area or entire sheet from all selected sheets.
3 Prints print area or entire sheet from all sheets in the workbook.