Impresión con contraseña

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.

hola, Miguel !

los argumentos de la macro-funcion (PRINT) del (viejo ?) excel 4
solo utiliza 12 argumentos y en la macro grabada hay 17 (???)

haz una prueba con la grabadora mandando la salida a una impresora local
despues, confirma si la macro grabada se ejecuta sin errores (?)

con respecto de la solicitud de password de la impresora (o de la red)
no es parte del modelo de objetos de excel y que no creo sea "grabable" por
vba
prueba el metodo sendkeys una linea ANTES de la instruccion con el PRINT
(p.e.)

SendKeys "paSsWorD~"

sustituye paSsWorD por la contrasena y DEJA el "~" (significa {enter})

saludos,
hector.

Muchas gracias por la información, muy util.
Un saludo.

"jsilva69" escribió:

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.
.

Hola Héctor Miguel:
Muchas gracias por la respuesta, actualmente no tenemos impresoras locales,
las tenemos todas en red, y no puedo hacer la prueba.
En cuanto al sendkeys, lo he probado de todas las maneras y nada de nada, no
hay forma.
De todas formas muchas gracias.

"Héctor Miguel" escribió:

hola, Miguel !

los argumentos de la macro-funcion (PRINT) del (viejo ?) excel 4
solo utiliza 12 argumentos y en la macro grabada hay 17 (???)

haz una prueba con la grabadora mandando la salida a una impresora local
despues, confirma si la macro grabada se ejecuta sin errores (?)

con respecto de la solicitud de password de la impresora (o de la red)
no es parte del modelo de objetos de excel y que no creo sea "grabable" por
vba
prueba el metodo sendkeys una linea ANTES de la instruccion con el PRINT
(p.e.)

SendKeys "paSsWorD~"

sustituye paSsWorD por la contrasena y DEJA el "~" (significa {enter})

saludos,
hector.