VBA Devloppment

150.0 GBP

150.0 GBP peopleperhour Technology & Programming Overseas
7 hour ago

Description

I am reaching out for your expertise to develop a VBA macro that will automate the management of an interactive form in Microsoft Word. Below are the details of my request and the expected outcomes.
Context:I am working with a Word (.dotx) template used to generate personalized offers. This template includes specific tags for managing optional sections and merge fields for inserting dynamic data.The tags in the document are as follows:[COMMUN]: Sections common to all offers.[OPTION ...]: Tags indicating optional sections (complete list below).The merge fields to be handled are:[DATE VALIDITE]: A date in the format DD/MM/YYYY.[NOM_CLIENT]: The client's name.[PROJET]: The project type.Request:I would like a VBA macro that automates the following tasks:
Dynamic UserForm creation:
The form should include:Checkboxes for each optional section (tags [OPTION ...]).TextBoxes for the merge fields [DATE VALIDITE], [NOM_CLIENT], and [PROJET].A button to validate the user's choices and apply the changes to the document.Management of optional sections:
Based on the checkboxes selected in the form, the corresponding sections should be included or removed from the document.Merge field replacement:
The form's text fields should allow the user to input values that will replace [DATE VALIDITE], [NOM_CLIENT], and [PROJET] in the document.Expected Outcome:An interactive UserForm:
Displays checkboxes for each [OPTION ...] tag present in the document.Contains text fields to populate the merge fields.A personalized document:
Sections corresponding to [OPTION ...] tags are included/excluded based on the form selections.Merge fields [DATE VALIDITE], [NOM_CLIENT], and [PROJET] are replaced with the entered values.Clear and maintainable VBA code:
The code should be structured to allow easy addition or modification of options or fields in the future.Complete List of [OPTION ...] Tags:[OPTION JDF][OPTION VOLIGEAGE][OPTION BARDAGE AJOURE][OPTION BARDAGE RL][OPTION BARDAGE CLIN Partie fermée ou brise vue][OPTION BARDAGE AJOURE Partie fermée ou brise vue][OPTION OSSATURE Partie fermée][OPTION TOITURE DEMI CROUPE][OPTION TOITURE ŒIL DE B][OPTION TOITURE TOITURE BETON][OPTION TOITURE TOITURE TC][OPTION TOITURE TOITURE ARDOISE ART][OPTION TOITURE TOITURE ARDOISE N][OPTION TOITURE TOITURE PANNEAU TUILE][OPTION MONTAGE][OPTION MACONNERIE]Technical Notes:The form should be generated dynamically to adapt to additional options or fields in the future.A scroll bar should be added if all the checkboxes cannot fit within the visible window.The form should open via a simple macro (e.g., AfficherUserForm).Expected Deliverables:A .docm file containing the VBA macro and a functional example based on a Word document template.A brief explanation of how the code works.Thank you for your valuable help. Please don’t hesitate to ask if you need clarification or additional details.
Best regards,

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Hi all, I have a wordpress website which we are ready to take this to the next stage in it's development and are looking to work with someone who would be able to work with us especially where more developments are more technically demanding. We envisage a series of small steps rather than one major rebuild. We would also hope that we could build a partnership so that a deeper understanding of the site can be gained. The site is used by a small team who are not particularly interested in the technology but would like to be able to be a 'little' more active with the site - to this end our initial goal would be to take some 'back end' functionality and to create a user friendly 'front end' for it. As a primary example - being able to create blog posts (news) either via a well designed webpage or by email. Our membership is primarily 'elderly' and we are keen to find someone with the suitable empathy and patience. This initial project is priced with that goal in mind. Other projects will develop over time - again - a partnership is preferred over a 'one off' assignment. Good communication skills would be a definite bonus - to this end I will endeavour to reply to all offers that have clearly read this project description but will not respond to automated replies (and hope that this doesn't offend). Payments will need to be 'approved' by the society so we are not able to enter into 'open ended' projects. If the budget for this task is insufficient (or too generous) then I'd be very happy to negotiate but we do intend to spend more over the next few months. The work is not particularly time sensitive. Start proposal with "wpNinja" to make sure that you read it all. The site makes use of WPMembership plugin (https://wordpress.org/plugins/wp-members/) and we would like to develop our use of this such that we are able to use this to manage our membership as fully as possible
200.0 GBP Technology & Programming peopleperhour Overseas
4 hour ago
Full-Stack Developer (AI-Driven Data Reporting System) Our website is a knowledge platform that provides academic insights through video content from leading universities and institutions worldwide. We are expanding our platform by developing an AI-driven interactive reporting system to offer users real-time, personalized insights across various fields such as political science, law, and economics. We are seeking a Full-Stack Developer to lead the development of this AI-Driven Data Reporting System. This platform will deliver interactive, web-based reports that incorporate our existing video content, data from external sources like the IMF, and AI-powered insights. Key Responsibilities As the lead developer for this project, you will: Backend Development: Design and build a robust Flask/FastAPI backend to handle API queries and data retrieval from external sources like the IMF. Implement OpenAI API integration to provide AI-driven summaries, insights, and contextual recommendations. Create and manage a PostgreSQL or MySQL database to store structured data, video transcripts, and metadata. Ensure secure API endpoints for dynamic content retrieval. Frontend Development: Develop an interactive reporting interface using modern frameworks like React.js or Next.js. Build a three-column layout that dynamically updates based on user inputs: Column 1: AI-powered search and results. Column 2: Suggested experts and videos from our content library. Column 3: Related reports, papers, and real-time data insights. Data Integration: Automate the retrieval of real-time data from APIs such as the IMF, World Bank, and other relevant sources. Integrate our video content and transcripts into reports to provide deeper insights. Implement dynamic link embedding to pull relevant video links from our sitemap.xml. Interactive Features: Implement dynamic, scenario-based modeling where users can adjust variables and explore outcomes in real-time. Build a conversational input box for users to ask follow-up questions and receive contextual AI-driven answers. Deployment and Hosting: Containerize the application using Docker. Deploy the solution on Railway.app or similar managed hosting platforms. Ensure secure HTTPS integration using Cloudflare. Required Skills & Experience Technical Skills Backend: Python (Flask/FastAPI), PostgreSQL/MySQL, RESTful API design. Frontend: React.js, Next.js, HTML, CSS, JavaScript/TypeScript. AI Integration: OpenAI API, Whisper API (optional). Data Integration: Experience with real-time data APIs (IMF, World Bank, etc.). DevOps: Docker, Railway.app, Google Cloud Run, Cloudflare SSL. Nice-to-Have Skills Experience with AI-powered content summarization. Familiarity with video processing APIs like VimeoAPI. Knowledge of content management systems (WordPress).
200.0 GBP Technology & Programming peopleperhour Overseas
1 days ago