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!
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.
Thank You!I have discussion with chatGPT, but no working code!Please working examples in VB or C# or C++Thanks!
I don't use C# or C++Unfortunately
Visual basic is possible too