Bonjour
Quelqu'un connait-il les attributs et la signification de ce Print
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Merci
RGI
Bonjour
Quelqu'un connait-il les attributs et la signification de ce Print
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Merci
RGI
Bonjour
Quelqu'un connait-il les attributs et la signification de ce Print
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Merci
RGI
Bonjour.
C'est une impression le premier "1" veut dire de toutes les pages, le
deuxième, signifie "en 1 exemplaire. Après, j'ai peur de me perdre dans le
compte des virgules. Je te mets l'aide en anglais. Si tu as des difficu ltés
reviens.
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 Pri nt
dialog box. Arguments corresponding to check boxes are logical values. If an
argument is TRUE, Microsoft Excel selects the check box; if FALSE, Micr osoft
Excel clears the check box.
Syntax
PRINT(range_num, from, to, copies, draft, preview, print_what, color, f eed,
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 req uired
arguments.
From specifies the first page to print. This argument is ignored unl ess
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 defa ult
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 displa yed.
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. T his
argument will override the setting in the Page Setup dialog box. If omi tted,
the note argument in the Page.Setup function is used to determine wheth er 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 avail able
only in Microsoft Excel for the Macintosh. If omitted, the setting is n ot
changed.
Feed is a number specifying the type of paper feed. Feed is availabl e
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 SETU P
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 ver tical
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, i f
A1:F40 is selected on the active sheet, A1:F40 will be printed from eac h 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.
Cordialement.
Daniel
"RGI" a écrit dans le message de news:Bonjour
Quelqu'un connait-il les attributs et la signification de ce Print
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Merci
RGI
Bonjour.
C'est une impression le premier "1" veut dire de toutes les pages, le
deuxième, signifie "en 1 exemplaire. Après, j'ai peur de me perdre dans le
compte des virgules. Je te mets l'aide en anglais. Si tu as des difficu ltés
reviens.
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 Pri nt
dialog box. Arguments corresponding to check boxes are logical values. If an
argument is TRUE, Microsoft Excel selects the check box; if FALSE, Micr osoft
Excel clears the check box.
Syntax
PRINT(range_num, from, to, copies, draft, preview, print_what, color, f eed,
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 req uired
arguments.
From specifies the first page to print. This argument is ignored unl ess
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 defa ult
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 displa yed.
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. T his
argument will override the setting in the Page Setup dialog box. If omi tted,
the note argument in the Page.Setup function is used to determine wheth er 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 avail able
only in Microsoft Excel for the Macintosh. If omitted, the setting is n ot
changed.
Feed is a number specifying the type of paper feed. Feed is availabl e
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 SETU P
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 ver tical
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, i f
A1:F40 is selected on the active sheet, A1:F40 will be printed from eac h 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.
Cordialement.
Daniel
"RGI" <nospam.RGI@wanadoo.fr> a écrit dans le message de news:
OR398ZWoIHA.4616@TK2MSFTNGP05.phx.gbl...
Bonjour
Quelqu'un connait-il les attributs et la signification de ce Print
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Merci
RGI
Bonjour.
C'est une impression le premier "1" veut dire de toutes les pages, le
deuxième, signifie "en 1 exemplaire. Après, j'ai peur de me perdre dans le
compte des virgules. Je te mets l'aide en anglais. Si tu as des difficu ltés
reviens.
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 Pri nt
dialog box. Arguments corresponding to check boxes are logical values. If an
argument is TRUE, Microsoft Excel selects the check box; if FALSE, Micr osoft
Excel clears the check box.
Syntax
PRINT(range_num, from, to, copies, draft, preview, print_what, color, f eed,
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 req uired
arguments.
From specifies the first page to print. This argument is ignored unl ess
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 defa ult
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 displa yed.
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. T his
argument will override the setting in the Page Setup dialog box. If omi tted,
the note argument in the Page.Setup function is used to determine wheth er 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 avail able
only in Microsoft Excel for the Macintosh. If omitted, the setting is n ot
changed.
Feed is a number specifying the type of paper feed. Feed is availabl e
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 SETU P
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 ver tical
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, i f
A1:F40 is selected on the active sheet, A1:F40 will be printed from eac h 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.
Cordialement.
Daniel
"RGI" a écrit dans le message de news:Bonjour
Quelqu'un connait-il les attributs et la signification de ce Print
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Merci
RGI