Hello, peopleWhat is the difference between VBA and VSTA? When to use VBA and when VSTA?Please write here examples of use VSTA. VBA versus VSTA or VBA & VSTA?Greetings!
Hello, everybody
No answer about 20 days?!
Is my question that stupid? Or is it too complicated?Greetings!
neither stupid nor complicated !If I don't know the answer, I don't write.I still refrain from trolling the questions of a creative GPT bot that necessarily needs a macro for an operation that requires two mouse clicks (or hitting two keys =CE=).To the question of VBA or VSTA.I think the difference in syntax only.I use VBA and don't know VSTA at all. I suspect that in a few days I could start script in it. But I'm afraid in a week or in a month I coud not be able to tell you what the difference is and which program performs which tasks better.Taras
here is the answer from chat.openai.comExhaustingly
VBA and VSTA are two different technologies used to develop applications in the Microsoft Office environment.
VBA (Visual Basic for Applications) is a programming language used to automate processes in Microsoft Office programs such as Excel, Word, Access, and PowerPoint. VBA has a built-in development environment that allows you to create macros that perform specific actions and VBA-based programs.
VSTA (Visual Studio Tools for Applications) is a set of development tools used to develop applications in the Microsoft Office environment. VSTA enables developers to use programming languages such as Visual Basic.NET, C#, and Visual C++ to develop applications in the Office environment. VSTA also includes a development environment that allows you to create applications that can be used in various Office programs.
The main difference between VBA and VSTA is that VBA uses only the Visual Basic language to develop applications, whereas VSTA allows the use of other programming languages such as C# and Visual C++. In addition, VSTA provides more opportunities for application development, as it includes advanced development tools and an environment that allows developers to create more complex applications than VBA. However, VSTA also requires a higher level of programming knowledge and development experience than VBA.