Why Visual programming language?

Answer 1

Assuming you are referring to VBA (Visual Basic for Applications), it was designed to be a common language allowing the various Microsoft applications to communicate with each other within an application. For example, while an Excel spreadsheet could import data exported from an Access database, this would have to be done repeatedly every time the most up-to-date data was desired. Additionally, manual tasks to customize the data might also have to be repeated each time. By creating a VBA application, the data extraction and customization steps would only have to be finalized once and then the fully-customized and accurate data would be available every time the application was run with no other steps required.