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: https://www.youtube.com/watch?v=U6lrAi75e78

- - - - - - - - - - - - - - - - - - - -

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: https://www.youtube.com/channel/UCX-H7IOnCfHihvtnypTORMA
Subscribe: https://bit.ly/2PmVzwJ

- - - - - - - - - - - - - - - - - - - -

Other great content!

Top Free Engineering Software:
https://www.youtube.com/watch?v=PE5hMaQBCn4

Excel For Engineers: Other
https://www.youtube.com/watch?v=-zvxn4bQr-E&list=PLAVcy54svukf-joaAQHcy_GiSrtqy0p00

- - - - - - - - - - - - - - - - - - - -

Follow and interact!

Subscribe: https://bit.ly/2PmVzwJ
Twitter: https://twitter.com/TheEngToolbox
Facebook: https://www.facebook.com/TheEngineeringToolbox/

- - - - - - - - - - - - - - - - - - - -
#ExcelVBA
#Programming
#EngineeringToolbox

Видео Real Excel VBA Project (Export Data to log sheet, create PDF, Send Email) канала The Engineering Toolbox Channel