Set customized paper size

antyjong

New Member
Hi there:

One of our customers hopes that she can print directly once an Excel file generated by our software. But here's the problem: she doesn't print that with her default printer, and she need to print that file with an self-defined papersize(which's defined in start-> setup->printer->file->printer server ) .
I know that there a method "PaperSize" can be used to predefined papersize while file is generated, but I've search all resources I can find, they only said that I can use "ActiveSheet:PageSetup:PaperSize =" to assign a known papersize (such as A4, B3 etc.) to my COM-HANDLE. I still don't know how to assign a self-defined papersize to my file.
If there's anyone know the answer to my question, would you please that me know? thanks a lot.:blush1:

AntyJong
 
Have you tried a customized page setup (with margin, etc...) ? I don't know if you can do this with Excel but you can with Word. Does it change paper size when printing ? Didn't test what I'm talking about :blush:
 
Back
Top