What are the parameters for print(,,,,,,,,,,,,,,,) excel4 macro?

V

velvetlady

When using the following in a VB macro
ExecuteExcel4Macro _
"PRINT(1,,,1,,,,,,,,2,""HP LaserJet 2300 Series PCL 6 on
LPT1:"",,TRUE,,FALSE)"

Where can I find the definition for all the parameters for the PRINT()
function?
 
D

Dave Peterson

I took this from XLMACR8.HLP.

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.

==========================================
http://www.microsoft.com/downloads/results.aspx?freetext=Macrofun

You can read more about them by getting both of these:
Macrofun.exe & Macro97.exe (which contains XLMacr8.hlp)

You may have trouble with macrofun.exe, but macro97.exe creates a .hlp file.

And to me, it sure looks like the content is the same.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top