MYPE inserted sample data in this example, not to disclose any confidential information.

Client : Saft Batteries (a Total company), Strategy and Transformation Department

Project duration : 6 months

Location : Levallois-Perret

Project background : Creation of an Excel interface for data input, with several validation control, for a cloud-based group reporting solution

This User Interface (UI) has been developed with VBA (Visual Basic For Applications). The user can create, update or delete actions just by clicking on buttons and selecting values in a list. When the user clicks on a button, a message box informs him of what is going to happen, with the possibility to cancel.  Data Validation procedures (values restricted to Text, or Integers...) were created, to improve stability & safety of the overall system. Many variables had to be created to create this interface : "FileType", "FirstEmptyRow", "NewAction"...

This project is another proof of MYPE's expertise to develop tailor-made interfaces and customized reporting tools with VBA.

Client Benefits :

- automated intuitive interface allows you to input data in a few clicks

-time spent by the user is 10 times faster  than traditional Excel file

-system safety : all zones that must not be activated by the user are locked

vba.PNG

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

Microsoft-Partner-Network-Logo_transpare

© MYPE.  All rights reserved

  • Facebook - Gris Cercle
  • Twitter - Gris Cercle
  • LinkedIn - Gris Cercle
  • YouTube - Gris Cercle