Setting print properties in Excel

[littleIdiot]

I'm new to VB and am asking this question to see if it is AT ALL possible to do the following - any useful links/tips/answers appreciated!

I am trying to change the settings on an Excel workbook so that when the user goes to print a page off, the following settings are set already:
- all page margins set to 0
- the specific printer to be used is set
- set the printer tray to be manual feed

Is all of this possible through VB?

Can you suggest what I should look for - I'm hoping to get some ideas from tutorials etc but being completly new to VB, don't know what to search for!

Many thanks,
Tim

 

[SkipVought]

Hi,

Here's what I would suggest.

1. Make sure that you are thoroughly familiar with the process of Page Setup to set the parameters you need and Print, setting the parameters you need.

2. Turn on the Macro recorder Tools/Macro/Record New Macro

3. Record the Page Setup process and the printer selection process - you actually have to CHANGE the printer selection to get any code. Tray selection will not be included.

4. Turn off the macro recorder.

Now you have a macro that does all this. Usually, some code cleanup is recommended.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com