What is VBA?

Visual Basic for Application or VBA for short is a scripting language that can be used to control processes in Microsoft Office programmes such as Word or Excel. VBA is the most widely used scripting language for programming macros.

 

When does soXes use VBA?

At soXes, VBA is used to automate and extend Microsoft Office programmes. The script language can be used to integrate additional functions in Word or Excel, but also in external programmes.

 

Where has soXes used VBA?

soXes has used VBA, for example, in the application VACPro from Vertrieb Schweiz AG, which is used to broker insurance applications from independent brokers. The application offers the function of exporting Excel sheets, which was implemented with the help of Visual Basic for Application.

 

Why soXes?

With soXes you gain a partner with competence and reliability. For 20 years, our company has stood for the best quality in the development, programming and outsourcing of software. With its services, soXes covers the entire life cycle of an IT development (conception, consulting, development and support). Take the first step towards the successful implementation of your project and contact us for more information.

Your direct contact:

Rolf Borkowski

Rolf Borkowski
CVO

Reference Projects VBA
Raiffeisen
Kunde: Raiffeisen Group
Applikation: Raiffeisen
Technologie: C++, JAVA; TCL/TKL, HTML5/JSON

In recent years, the Raiffeisen Group has established itself as the leading retail banking group and third largest banking group in Switzerland. Its strength is its local roots. Today, Raiffeisen customers include 3.7 million Swiss nationals. Of these, over 1.8 million are members of cooperatives and thus co-owners of their Raiffeisen bank.

The Raiffeisen Group provides its individual autonomous Raiffeisen banks with price information for foreign exchange, interest rates (e.g. mortgages) and securities. Together with Dion Global Solutions, soXes has developed a central pricing tool specially for the Raiffeisen Group, which receives, validates and calculates market data from different providers (Reuters, Bloomberg, Sungard etc.). This information is then made available to the different systems (e.g. Avaloq) or the local Raiffeisen banks.

This pricing tool was implemented several years ago and is still in daily use today. Today, soXes takes over the maintenance and support of this application. In addition, changes and improvements are regularly incorporated into the solution within the scope of small projects.

From a technical point of view, the solution consists of a backend (central computer) developed in C++/Java and a frontend developed in TCL/TKL and HTML5/JSON.

Sulzer
Kunde: Sulzer AG
Applikation: Sulzer
Technologie: Access, VBA, Excel

Sulzer AG is a globally active Swiss industrial group with headquarters in Winterthur. The company was founded in 1834 by Johann Jacob Sulzer as a foundry and produced cast iron, fire tips, pumps and apparatus for the textile industry. Today, the Sulzer Corporation employs around 15,000 people and generates sales of over 3 billion Swiss francs. Sulzer now consists of the core operating divisions Pumps, Rotating Machinery Services (such as generators and motors) and the Chemical Division.

To improve the project process at Sulzer Pumps, Sulzer Pumps Ltd. has commissioned soXes GmbH to create a software solution based on Access and Excel. Sulzer Pumps is the world's leading pump manufacturer with more than 20 production sites.  The most complex pipeline system in the world is based on Sulzer Pumps and transports two million barrels of crude oil daily from Canada over 13 500 km to North America.

Today, all projects at Sulzer Pumps are coordinated via the Order Progress Room, a new service developed by soXes. The Access-based application clearly displays all orders, including order number, customer name, project name, project manager and project name, thanks to filter functions. Orders can be sorted by calculated or agreed delivery date. The core function provides a list of the order and production stages, whereby it can be defined for each order whether or not the respective stage can be kept to the planned deadline and whether or not there are any delays in delivery. Based on this order status overview, reports of up to a display size of DIN A0 can be generated and thus even printed as posters. There is also an import/export interface via Excel to the Sulzer ERP systems.

Thanks to the Order Progress Room, the project process at Sulzer Pumps was made clearer and its handling optimized. The solution is used worldwide (multi-user capable). 

Law office
Kunde: German Law office
Applikation: Law office
Technologie: .NET, SQL Server VBA

In this project, the client is a German law firm with a Swiss branch and specialization in tax consulting. Among other things, it has many years of experience in the successful execution of exonerating self-denunciations in tax and economic criminal proceedings in Germany.
In order to simplify processes and increase efficiency in the handling of tax law cases, this law firm has worked with soXes GmbH to develop an application that automatically generates a German tax return for clients. The basic idea is that the clients' securities accounts are read into the system on the basis of bank data and then an automatic process based on WMM data generates the tax return. Usually, 80-90% of the tax return for the client can be generated automatically in this way. German tax law not only includes various types of tax and forms of collection, but also numerous special regulations, which makes it very complex and difficult for the layman to understand. 

soXes has managed to absorb this high complexity and to integrate it to a large extent into the Jakowetz solution. For example, calculations of complex processes such as capital gains for various types of investments and time periods are mapped 1:1 in the tool and correctly calculated to the decimal point. All changes in the law between 1997 and 2014 as well as special treatment of communities such as families, married couples etc. are also taken into account. Any special cases are subsequently processed manually by a specialist.

The application is technically based on an SQL server with a VBA (Access) front-end and includes all information and special regulations for the preparation of a complete German tax return for the years 1997 to 2018. In addition, the German tax forms for all these years can be filled out automatically and printed out at the touch of a button. Please keep in mind that the forms are different for each year. A print wizard also enables the automatic integration of attachments with further evaluations.

This unique software solution has enabled our customer to massively increase their efficiency. This represents an enormous competitive advantage over our competitors.

 

DION Global
Kunde: DION Global Solutions GmbH
Applikation: DION Global
Technologie: C/C++, Java, TCL/TK, mySQL DB, Oralce, Neartime processing

Dion is a global company active in the technical finance industry. It offers tailor-made solutions for the financial industry. soXes is a development partner of Dion and supports them in the development and integration of software solutions for the financial market. Thanks to the joint cooperation, many projects in this area have already been successfully implemented. These include the integration and development support of X-Gen (a workflow management system) and I-Pricer (a multi-asset-class pricing solution) and RateStream (a dynamic FX and money market calculation engine). Technically, these applications are based on C/C++, Java, TCL/TK, mySQL DB, Oralce and neartime processing.

VAC
Kunde: Vertrieb Schweiz AG
Applikation: VAC
Technologie: Desktop Applikation, C#, SQL, VBA

Vertriebschweiz GmbH (VAC) stands between insurance brokers and companies. It accepts insurance applications from the independent brokers and passes them on to the companies. Depending on the type of application or company, the brokers are remunerated or paid commission per application.

The VACPro application has been developed by soXes with the aim that VAC employees can enter the applications as efficiently and easily as possible. The application enables the management of applications in a structured and orderly manner. Various export and import interfaces simplify the work with the tool. The commissions are defined and calculated directly by VACPro. The application can be edited and personalized by the user almost without exception through master data masks.

VACPro is a Windows application programmed in C# and offers Excel exports based on VBA. CristalReports is also used as a built-in tool for creating reports, statements and commission summaries. In the background is a MSSQL database.

Thanks to soXes, VAC was able to switch to a tool specifically designed for them and tailored to their needs. At the same time, soXes GmbH in cooperation with Hotz & Koch Informatik AG took over the entire IT responsibility of VAC.

Relevant Topics
cloud button Cloud View
list button List View

Testimonials

 
Our dedicated soXes team helps us to successfully develop Prisma World further. A big thank you to the IT professionals. Dr. J. P. Pflüger, CEO Prisma World AG
soXes convinces us with its agility paired with broad and deep know-how for complex software developments. Markus Wiegand, CEO Wiegand AG
soXes has always managed our projects to our satisfaction. CorXL Ltd. JPD Dr. med. Jan Steffel, Senior Physician Cardiology / Rhythmology at the University Hospital Zurich
With soXes we know that we are in very good hands. Belinda Stublia, Lucullus SA
The soXes team convinces with its incredible commitment and passion. Argjent Ukshini, IT Project Manager Customer Service Electrolux Schweiz AG
soXes has shown to be a very professional partner and we value their responsiveness, quick turnarounds and enthusiastic work ethics. Patrick Brigger, Co-founder & Chairman, getAbstract
We have been working successfully with soXes for over 10 years. The professionalism and flexibility of soXes continues to convince us. Mark Rüegg, CEO CelsiusPro AG
With competence, commitment and energy, soXes opens the way to success. Cornelia Nestic, Associate Director, HypothekenZentrum AG
The cooperation with the soXes project managers of my project is markedly cooperative and open. soXes shows the flexibility and agility required for such projects. For me, this is a decisive factor for the success of the project. Dan Keller, Manager Major Projects, TUS Telekommunikation und Sicherheit
With soXes at our side, we have succeeded in breaking new ground in software technology, Bruno Schmed, Member of the Executive Board, T&N Telekom und Netzwerk AG
At soXes we get competence and professional results - at any time in a completely uncomplicated way, Simon Keel, Chief Technology Officer, Tolomeo Capital AG
soXes convinces in projects with experienced solutions and close customer contact. Roman Aebi, CEO Cenprom AG
soxes has implemented our ideas into an overall solution: professional, timely and at a fair price. Andreas Lehmann, CEO, PortaNet AG
soXes has demonstrated great expertise and commitment to the complex overall IoT solution with LoRaWAN and NFC. This, and the well structured cooperation were the basis for the simplicity that distinguishes MyPortaNet. Christoph Röthlisberger, IoT/Industry 4.0, PortaNet AG

 

Are you looking for a company that offers you effective support and consulting in the implementation and support of your software projects?


Our services cover the entire life cycle of an IT solution as well as the entire spectrum of modern software development.


From business and process analysis, IT architecture to implementation. From commissioning to support. You benefit from our specialist knowledge and our experts.

With over 150 successful development projects and more than 80 active customers, we have the experience and you have the idea.

Notice

Our website uses cookies to ensure the best possible service. By using the site, you agree to the use of cookies. You can change this in your browser settings. Privacy Policy.