Re: Papersizes
I'm not sure why the printer would ignore some paper sizes but that more a
question for the printer manufacture, or is it Excel that can't enumerate
more than 128 paper sizes and you wish to delete any paper sizes that are
not used so the list does not exceed 128?
Forms data is added when a new printer / driver is added so anytime a new
printer gets added to the system, there is the potential for an increase in
the number of forms.
Form data is stored in the registry
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Forms
If the printer is a connection, delete the connection, fix the forms on the
server, then make the connection again.
If out stop / start the spooler service after deleting forms, does the index
number change?
--
Alan Morris
Windows Printing Team
Search the Microsoft Knowledge Base here:
http://support.microsoft.com/search/?adv=1
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christian" <Christian@discussions.microsoft.com> wrote in message
news:AD107FE2-A13D-4F27-A8D0-3BC2EF746254@microsoft.com...
> Hi Alan,
>
> i used the Macro-Editor of Excel.
> First I set the needed papersize in File->Pagesetup
> and then called the ActiveSheet.PageSetup.PaperSize method.
>
>
> "Alan Morris [MSFT]" wrote:
>
>> Christian, where are you getting the ID 128 data from?
>>
>> --
>> Alan Morris
>> Windows Printing Team
>> Search the Microsoft Knowledge Base here:
>> http://support.microsoft.com/search/?adv=1
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Christian" <Christian@discussions.microsoft.com> wrote in message
>> news:AC5C3361-BAB3-48A7-93B3-5B12E1149D7F@microsoft.com...
>> > The papersizes are assigned to the trays by the Devicesettings in the
>> > Printerdriver.
>> > For instance:
>> > tray1 = CustomPaperSize1
>> > tray2 = CustomPaperSize3
>> > tray3 = CustomPaperSize2
>> >
>> >
>> > "Dusko Savatovic" wrote:
>> >
>> >> How do you set paper size?
>> >> Paper size on my HP printer is set in the paper tray by sliding
>> >> vertical
>> >> divider to a preset position. Depending on the position, the printer
>> >> reports
>> >> the paper size of the paper tray.
>> >
>>
>>
>>