Thanks Anees. :) Do keep an eye out for the other 2 parts. There are lot of things that I will share regarding Page Setup and Printing from VBA. Also do remember to subscribe if you still have not subscribed to get an immediate alert when I post the new videos.
Hi :) The size that you want to print to is almost the same size what we have for "Envelope DL". The actual size for "Envelope DL" in mm is 110 X 220. To use that in VBA you can use ".PaperSize = xlPaperEnvelopeDL" and then you can use margins like this .LeftMargin = Application.InchesToPoints(0.7) .RightMargin = Application.InchesToPoints(0.7) .TopMargin = Application.InchesToPoints(0.75) .BottomMargin = Application.InchesToPoints(0.75) .HeaderMargin = Application.InchesToPoints(0.3) .FooterMargin = Application.InchesToPoints(0.3)
Hi Erika, Can you explain a bit more on what exactly are you asking? Feel free to post your question on the FB group with screenshots if possible. FB group link is mentioned in the description.
Thanks Ashok :) Do keep an eye out for the other 2 parts. There are lot of things that I will share regarding Page Setup and Printing from VBA. Also do remember to subscribe if you still have not subscribed to get an immediate alert when I post the new videos.
Hi Kevin. I apologize for the inconvenience. Seems like the entire folder of files got deleted. I will try and recreate the file. Please give me 24-48 hours. Thanks for bringing it to my notice!
It's very useful..Thanks
Thanks Anees. :) Do keep an eye out for the other 2 parts. There are lot of things that I will share regarding Page Setup and Printing from VBA. Also do remember to subscribe if you still have not subscribed to get an immediate alert when I post the new videos.
Do you can help me ? I have paper size height 110mm and width 230mm, how make a code vba for printing ?
Hi :) The size that you want to print to is almost the same size what we have for "Envelope DL". The actual size for "Envelope DL" in mm is 110 X 220.
To use that in VBA you can use ".PaperSize = xlPaperEnvelopeDL" and then you can use margins like this
.LeftMargin = Application.InchesToPoints(0.7)
.RightMargin = Application.InchesToPoints(0.7)
.TopMargin = Application.InchesToPoints(0.75)
.BottomMargin = Application.InchesToPoints(0.75)
.HeaderMargin = Application.InchesToPoints(0.3)
.FooterMargin = Application.InchesToPoints(0.3)
Hello. I can not make PageSetup to appear as an option. Do I need to active something to make it work?
Hi Erika, Can you explain a bit more on what exactly are you asking? Feel free to post your question on the FB group with screenshots if possible. FB group link is mentioned in the description.
Very helpful
Thanks for taking the time out to appreciate the video :)
Just Superb.
Thanks Ashok :) Do keep an eye out for the other 2 parts. There are lot of things that I will share regarding Page Setup and Printing from VBA. Also do remember to subscribe if you still have not subscribed to get an immediate alert when I post the new videos.
Hi , When I press the link, I am told it was deleted
Hi Kevin. I apologize for the inconvenience. Seems like the entire folder of files got deleted. I will try and recreate the file. Please give me 24-48 hours. Thanks for bringing it to my notice!
@@SiddharthRout . Thanks, I really appreciate your quick response and your good work on StackOverflow etc
@@kevinlorenz2810 File Link has been restored. Thanks again for the headsup. :)
@@SiddharthRout Many thanks . Very helpful