attributs

Le
RGI
Bonjour

Quelqu'un connait-il les attributs et la signification de ce Print

ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"

Merci

RGI
Vidéos High-Tech et Jeu Vidéo
Téléchargements
Vos réponses
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Trier par : date / pertinence
Daniel.C
Le #5460601
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 difficulté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 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.

Cordialement.
Daniel
"RGI"
Bonjour

Quelqu'un connait-il les attributs et la signification de ce Print

ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"

Merci

RGI


RGI
Le #5460031
Bonjour

Merci beaucoup Daniel

je vais essayer de me débrouiller avec cela

Salutations

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"
Bonjour

Quelqu'un connait-il les attributs et la signification de ce Print

ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"

Merci

RGI






Publicité
Poster une réponse
Anonyme