Real Excel VBA Project (Export Data to log sheet, create PDF, Send Email) скачать в хорошем качестве

Real Excel VBA Project (Export Data to log sheet, create PDF, Send Email)

In this video I go through a real excel VBA project step by step. I will show you how to log data from a form into a historical spreadsheet in a different document, create a PDF of an audit form, and the generate an automated email which attaches the PDF of the form. Time Links [ 00:41 ] Depended Combo Boxes in Form (Data Validation) [ 02:26 ] VBA Starts (Turn on Developer Tab, ActiveX Button, Design Userform) [ 05:45 ] Create routines for each option [ 06:42 ] Data Validation with VBA (Make sure audit form is completely filled out) [ 08:36 ] Export audit form data to logsheet in separate workbook [ 16:35 ] Create PDF of audit sheet [ 20:00 ] Clear audit form information [ 20:33 ] Send Automated Email with PDF Attachment [ 25:47 ] Close Form [ 26:08 ] Wrapping up VBA (Userform defaults, command button execution) Subscribe: https://bit.ly/2PmVzwJ - - - - - - - - - - - - - - - - - - - Previous Video:    • Exploring Excel VBA with Real Project Example   - - - - - - - - - - - - - - - - - - - Check out my channel for more videos and tutorials for engineers! Like, follow, share and don't be afraid to drop me a comment/message with feedback, questions, or video suggestions! Thanks for watching! Channel Link:    / @theengineeringtoolboxchannel   Subscribe: https://bit.ly/2PmVzwJ - - - - - - - - - - - - - - - - - - - Other great content! Top Free Engineering Software:    • EVERY Engineer Should Know About This FREE...   Excel For Engineers: Other    • Top 17 Excel Tips, Tricks, & Productivity ...   - - - - - - - - - - - - - - - - - - - Follow and interact! Subscribe: https://bit.ly/2PmVzwJ Twitter:   / theengtoolbox   Facebook:   / theengineeringtoolbox   - - - - - - - - - - - - - - - - - - - #ExcelVBA #Programming #EngineeringToolbox