Microsfot documentation is really bad. they don't tell you what type object
you are suppose top use. In this case the object is the worksheet and you
can't change printers. The printer is the default printer on you PC.
You may want to ask in a forum dedicated to VB--not excel.
If you really meant you wanted to print something in excel's vba:
worksheets("Sheet999").printout 'preview:=true
or
worksheets("sheet999").range("x1:Z9").printout 'preview:=true
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.