Find Jobs
Hire Freelancers

VBA Application

£20-250 GBP

Terminado
Publicado hace alrededor de 5 años

£20-250 GBP

Pagado a la entrega
Create a VBA application in Excel to help automate the business or organisational process you have decided to address, which must: 1. Have a graphical user interface within Excel such that a person who is familiar with Excel, but has no knowledge of VBA, can successfully operate your VBA application. 2. Demonstrate the key programming skills expected on successful completion of the module including use of:  Variables, Constants and Data Types;  Routines, Procedures and Functions;  Conditional Structures and Loops; and  Arrays. 3. Demonstrate a clear understanding of the importance of correctness, usability and readability in programming. Report (40%) Produce a report about your VBA application, which must include: 1. Introduction of your VBA Application: • The background and rationale to the business issue or problem, which you have decided to address using a VBA application. • You may refer to relevant literature, but keep coverage of the literature brief. • Clearly state the overall objectives of the VBA algorithm. 3. Discussion of the potential impact of the VBA Application:  How do you think the application of your suggested solution would impact a business or organisation? Would you, for example, expect it to lead to lower costs, higher efficiency, higher accuracy, etc.? Discuss the potential implications of implementing your application within a business or organisation.  Discuss how well you believe your proposed solution is likely to address the problem/issue and make some suggestions on the how your model’s limitations that you have identified may be addressed. 4. User’s Operational manual: Write an operational manual so that a user who is familiar with Excel, but has no knowledge of VBA, can successfully operate your VBA application. It should be brief: Bear in mind that well- written software needs less explanation. Note the following: • Screenshots are not essential, but are useful. • Any assumptions and limitations should be specified here. • An explanation of any warnings and/or messages given by the program should be given. It is not essential, but you might want to combine this with a troubleshooting section. 5. Technical Documentation: The technical documentation should describe the components of the application to a VBA-literate reader so that the VBA application can be maintained and enhanced in the future. It should include: • The purpose of each file (module, class, UserForm). • For each file, a brief description of the purpose of each routine, method, properties and event. This should be no more than a few sentences; often one will suffice. • A description of how the files are linked together. 6. VBA program code: Copy and paste the entire text (not a picture) of your VBA code as appendix to the report. Your report must not exceed 2000 words including everything except the VBA code text, bibliography and reference list. Submit to blackboard:  A single pdf document containing (i) your report and (ii) the entire text of your application VBA code copied from Excel. You must submit the pdf document to the Turnitin submission tab on blackboard.  An Excel file in xlsm format containing your VBA application. You must submit xlsm file to the ‘VBA Model Submission’ tab on blackboard.  If your application inputs a data set, for example a csv file, then you must also submit a sample data file to the ‘VBA Model Submission’ tab so that I can test your application with the input data.
ID del proyecto: 18495578

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello Majid, I have read your project brief, Is it an Academic assignment task ? i need some clarifications. Let me discuss more details in Chat. I have 5 years experience in Excel VBA programming and completed 400+ projects. I never ask for payments in front. You can release the agreed milestones once the task is completed and you're happy with [login to view URL] my reviews to confirm my work quality With Regards, Sai
£50 GBP en 3 días
4,8 (91 comentarios)
5,8
5,8

Sobre este cliente

Bandera de UNITED KINGDOM
Southampton, United Kingdom
5,0
3
Forma de pago verificada
Miembro desde may 27, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.