​​Excel Visual Basic for Applications (VBA) For Industrial Automation​

Training Provider: SINGAPORE POLYTECHNIC
Course Reference: TGS-2024042283
S$213
Original: S$710
Save S$497

About This Course

​​This course aims to demonstrate participants how to use Excel Visual Basic for Applications (VBA) to run procedure periodically, create a real-time dashboard, read/write to My Structured Query Language (MySQL) database, and send Outlook email. Communications using Open Platform Communications Unified Architecture (OPC UA) and Application Programming Interface (API) are also included.​

What You'll Learn

​Excel Visual Basic for Applications (VBA) is widely used in companies for automatic data processing. Beyond the powerful data processing capabilities, Excel Visual Basic for Applications can also be used for creating real-time dashboard, accessing database, communicating with machines using standard industrial protocols and so on. Those features make Excel Visual Basic for Applications to be a useful tool in industrial automation as well.

Entry Requirements

​​Working knowledge of Microsoft Excel and basic level of concept in programming.

Course Details

Duration 16 hours
Language English
Training Commitment Not specified
Total Enrolled New course
Back to All Courses
Note: To apply for this course, visit or contact the training provider directly.

More Courses from SINGAPORE POLYTECHNIC

This comprehensive short course designed to introduce participants to the fundamentals of motion gra...
Duration 16 hours
Fee After Subsidy S$258
Adobe Illustrator Fundamentals: Building Professional Designs with AI and Illustrations is a short c...
Duration 16 hours
Fee After Subsidy S$258
Graphics Design using Adobe Photoshop is a short course to designing graphics using Adobe Photoshop....
Duration 16 hours
Fee After Subsidy S$258