Page Setup and Printing from VBA - 1 of 3

There are times when you would like to share your important data as a hard copy. It is quite possible that you may even want to print an invoice or your weekly stats for those dreaded Monday reviews. In such cases, you will have to first go through the page setup so that the data fits nicely into the page or pages as you would require them and when needed, you can finally print it. When you have a static format, then it makes more sense doing the page setup and printing manually. But when you are automating things from VBA and have data which can either expand horizontally or vertically then you may want to do the page setup from VBA before you print your data. There are lot of aspects in page setup and printing that I will cover. I have divided the video in 3 parts of about 20 minutes each. This is the 1st part.
----
00:00 Intro
01:02 Brief description of our dataset
01:21 How page setup works
02:17 Visual Interface of page setup
03:51 Page Orientation
06:30 Print Preview
08:46 Scaling
12:24 Paper Size
13:20 Print Quality
17:28 First Page Number
18:30 Outro
----
Practice Workbook Download: www.dropbox.com/s/cheu5a2jktp...
Software used for recording and editing this video
Camtasia: techsmith.z6rjha.net/SidRecom...
Disclaimer: The above is an affiliate link. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support!
Connect with me on social:
LinkedIn: / siddharthrout
Facebook: / sidzrout
Instagram: / sidzthekidz
Stackoverflow: stackoverflow.com/users/11405...
Microsoft Excel VBA Facebook Group: / msexcelvba
#ExcelVBA #ExcelMacro #VBAExcel #MSExcel #Excel