vb + excel + builtin dialogs

f150man
07-06-2001, 09:37 AM
Hey people.

I need to modify Excels built-in dialog box at design time (with VB). This would include disabling some of the options, setting the print_what option (to eg. entire work book). I know you can use the .show method and modify the agruments to suit you're needs, but it doesn't seem to be working. The biggest problem I have is setting the print_what option.....HOW DO I DO THIS!?!?!?!

Thanks
F150man

f150man
07-09-2001, 08:27 AM
Can anyone help me out there?
Here's the code that i am trying to run...

objExcel.Application.Dialogs(xlDialogPrint).Show arg7:=1, arg1:=1

"arg7" is the print_what option
"arg1" is the range_num option

Does anyone know what the proper settings for "arg7" are to get the "Entire Workbook" to be the default selection on the print dialog box at run time?????

I've tried different numbers, boolean, and text strings but nothing seems to be working.

Thanks again to anyone who can help
f150man

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum