Impresión con contraseña

07/05/2010 - 12:29 por Miguel | Informe spam
Muy buenas a todos:
Me gustaría saber si hay alguna forma de lanzar la impresión de documentos
en impresoras de red que necesitan contraseña, me explico.
Tengo una macro que la lanza la impresión en función de variables a
impresoras que tenemos en red, pero cada departamento tiene un código
diferente para imprimir que es lo que salta cada vez que lanzo una hoja.
He grabado la macro de impresión y me sale
Application.ActivePrinter = "\\srv_\CanonCentral en Ne07:"
ExecuteExcel4Macro _
"PRINT(2,1,1,1,,,,,,,,2,""\\srv_\CanonCentral en
Ne07:"",,TRUE,,FALSE)"

pero en la información de PRINT no encuentro descripción de cada ,,, y
además no veo donde introducir la contaseña y si es algo de excel o algo de
la propia impresora...
Espero haberme explicado muchas gracias por anticipado.
 

Leer las respuestas

#1 jsilva69
07/05/2010 - 16:34 | Informe spam
Te paso las especificaciones que baje de la pagina de MS:

***

PRINT
Equivalent to clicking the Print command on 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.

***

No veo aca nada que indique que le podes pasar como parametro la
contraseña... Tal vez con VBA haya algo...
En cuanto pueda te averiguo.

Julio.

Preguntas similares