vb.net code to enlarge font size, font name and do page setup in ms.excell

I am creating an excel report from vb.net. Now it works. But i realize that the apparent does not make sense. I just want enlarge some font size 开发者_高级运维and change font name plus setting up the page to fit my receipt printer (Epson TM-T88IV).

what should i do ?

thanks in advance

First manually set everything up bit by bit until it all fits nicely on your receipt printer.

Once you have everything just the way you want:

1. Generate a new, plain copy of the report.
2. Start recording a macro
3. Manually replicate the changes that you did in your practice sheet onto your macro recording sheet.
4. Stop recording the Macro, and press Alt-F11 to get to the VB that was generated.
5. Use the relevant lines of the generated macro to see what you need to add to your report generation code.