VBA for printer properties settings from excel 1

[Walter349]

Is there a way of being able to set the paper type to Plain, within VBA for Excel.

I can set size, margings, oriantation etc.But I need to find away to force the use of plain type paper.


'If at first you don't succeed, then your hammer is below specifications'

 

[SkipVought]

hi,

I don't suppose so, because each printer driver is DIFFERENT, amd if there were printer driver objects and properties, they would be supplied by the printer manufacturer. I have never been able to find HP printer driver objects and properties, for instance.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[UnsolvedCoding]

Thought for you -

If you load the paper into a pre-determined tray on the printer and then started the macro recorder, you could go into the print options and go to printing preferences, select the desired tray and run a print and stop the recorder.

Then go back into the macro you just recorded and start dicing and slicing.

Don't know if it would work but it would be a starting point.

I will also check my code library and see if there is anything specific that would be helpful.

 

[UnsolvedCoding]

This link has several suggestions and a snipet of code

http://www.mrexcel.com/forum/showthread.php?t=56552

and mentions the following two links.

This link suggests using send keys

http://support.microsoft.com/kb/q135791/

and this link

http://www.xcelfiles.com/PrintIndex.html

goes into a lot of printer detail and is mentioned in the first link.