Excel Visual Basic for Applications (VBA) For Industrial Automation

Singapore Polytechnic Open House 2026

Save the date now! Explore SP schools through visits and talks, meet future seniors and lecturers, try out CCAs, and grab our SP merch and freebies!

Know more

University Pathways

Discover how Singapore Polytechnic helps students transition to top universities with a robust curriculum and university accelerated pathway programmes.

Know more

Overview

Course Date:

TBA

Registration Period:

TBA

Duration/Frequency:

16 Hours

Mode of Training:

Face-to-Face (Classroom Teaching),Practical Training

Course Objective

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.

More Information

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. These features make Excel Visual Basic for Applications a useful tool in industrial automation as well.

Overview

Course Date:

Registration Period:

Duration/Frequency:

Mode of Training:

Course Objective

More Information

Advanced Manufacturing Lead - AMLead

Diploma (Conversion) in Computer Networking & Cloud Computing

Diploma (Conversion) in Supply Chain Sustainability & Innovation

Specialist Diploma in Digital Marketing and Analytics