COMMUNICATIONS ARCHIVE SPREADSHEET CUSTOM PROGRAMMED ON VBA
Our customer wanted to just save on a specific folder, messages and related attachments received and sent for a specific project and then have a spreadsheet that listed all the files with the possibility to easy filter and serach by date, description and keywords and link to the files themselfs. We organized to him the folder configuration to repeat for every project and we developed a VBA customized spreadsheet. The system was orgnaized with 3 main folders, (SENT, RECEIVED, IDT) where to save sent messages and related attachments, received messages and related attachments and document trasmittals forms. Pressing the button the spread sheet was updating the list listing one line for each document on the three folders. For each document automatically was filled date of the document, name of the file, extention,hiperlink to the file and in witch folder the document was.The customer had to add key words of the new files every new update to easy search them as he preferred.
ATTICO design offers engineering services in the mechanical and electrical fields. We develop specific design tasks, as well as the entire design process of the product. We develop mechanical electrical and 3D schematics using all the most common softwares in the market (Autocad/Autodesk, Creo, SolidWorks, Spac, E-Plan). My team and I are experts in office packaging tools, especially Excel, where we develop in VBA language-specific macro programmed speadsheets to customize design tools based on the needs of customer product design. We experienced also many italian-English translation works for technical and non documents. ATTICO design can proudly share over ten years experience and now a higly expertize pool of engineers to cover different design fields as: MV-LV Electrical distribution switchboards design Home product design Raylway on-vehicle industrial design Excel-VBA design-management spreadsheets development We hope to grow a trustful professional relationship with you. Thanks for checking us out! ATTICO