our work for you

about us

our technologies

Graphic embedding - Microsoft Word, Microsoft Excel, VBA

Company: Tandura Treuhand, Solothurn

Technology: MS Excel, VBA.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Dez 2012 – Dez 2012

Cost: no details


Creating an application using Microsoft Word, Microsoft Excel and VBA to present the annual financial statements of the individual clients of the company Tandura Treuhand AG. Using VBA, these financial statements are calculated and clearly presented in Microsoft Word in the form of graphical diagrams. The calculations are supplied as an attachment in Microsoft Excel.

  • Creating automated business reports and annual financial statements for the clients of the trust company.
  • Embedding of a graphic (chart) in an existing Word 2010 document (template).
  • The chart (embedded in the Word template) contains data from a Microsoft Excel 2010 spreadsheet.
  • The choice of data and formatting of the chart is done using VBA code.
  • By default, the data is obtained via a file path, but the data source can be redefined manually.
  • The chart can be reformatted at any time using a different display type (eight predefined charts are available) or defined completely manually.
  • The entire logic was implemented using VBA.
  • Implementation of the customer requirements using Microsoft Word 2010.
  • Microsoft Visual Basic for Application and Microsoft Excel 2010
  • Testing and documentation (user and technical).

 

 

TECHNOLOGIES USED:
Order a similar project
Add your project
If you want us to perform your project, upload all the necessary data and we will be happy to discuss with you all the details of our cooperation.
Name
E-mail
Want to order
Upload your brief
For message
Send Message
Order a template
To install and configure the theme, you need to specify your billing details and hosting data (FTP, PHP admin logins, passwords). After that, our specialists will install the template and you can test it.
Name
E-mail
Want to order
Hosting data and databases
For message
Send request
Add your Review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World), Youtube url, text...
Name
E-mail
Upload your review
URL video-feedback Youtube
Write a review
Post a review
Add your review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World)
Name
Upload
Post a review

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.

+41 (0)56 552 01 85

+41 (0)58 590 10 04

+41 (0)44 442 01 80

+41 (0)56 552 01 86