HELP: print macro woes :S

[KevinGPO]

I find that the 'print' macro immediately calls the default printer in EXCEL
but it opens the Printer selection dialog window in WORD. How can one stop
the PRINT button from selecting the default printer? Surely, it can open
the Printer selection window?

 

[tfoster]

Hey Kevin! I know it is a week later, but have you thought of selecting
File->Print through a macro that you create? This will surely take care of
your problem...

 

[KevinGPO]

Yep. Tried that thanks. Nothing gets recorded in the macro. It could be
something me doing not right.


:S

 

[David McRitchie]

Are you using file, print when you record the macro.
Make sure your printer is set correctly during use of file, print.

 

[KevinGPO]

Yes I am. Am not wanting the worksheet to be printed. I just want the
command to display the Print Options/Dialog window.

Are you using file, print when you record the macro.
Make sure your printer is set correctly during use of file, print.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Yep. Tried that thanks. Nothing gets recorded in the macro. It could be
something me doing not right.


:S

 

[broro183]

Hi Kevin,

Yes I am. Am not wanting the worksheet to be printed. I just want the
command to display the Print Options/Dialog window.

I'm not sure if this exactly what you want but try:
1)
application.dialogs(xlDialogPrint).show 'opens the "Print
Options/Dialog window"
'found by searching "Built-In Dialog" in Excel's VB help.
or
2)
expression.PrintOut(From, To, Copies, Preview, ActivePrinter,
PrintToFile, Collate, PrToFileName)
'found by searching "print" in Excel's VB help.

I think 1) is what you are after.

hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[David McRitchie]

Hi Kevin,

Application.Dialogs(xlDialogPrint)

http://archive.baarns.com/excel/faq/xd_dbox1.asp

changing parameters:
http://groups.google.com/group/micr...4d52e/303e98aaa5d7b904?hl=en#303e98aaa5d7b904

for examples and setting parameters use a Google search:
print dialog box sub excel
actually now you can improve that with
xldialogprint sub excel parameters

 

[JNW]

should read
application.dialogs(xldialogprint).show

 

[David McRitchie]

Thanks for the correction, don't know why I dropped the last part