Visual Basic for Apps Jobs

Visual Basic for Applications, commonly abbreviated as VBA, is a form of Microsoft Visual Basic for creating code within applications. A Visual Basic for Apps Developer can help their clients by creating automated solutions and customizations inside of applications. In general, these developers are computer savvy and bring an innovative approach in working collaboratively with a client's project requirements.

VBA gives developers the flexibility to use a scripting language for projects which would otherwise require writing code to build an application. With an understanding of industries and businesses, a VBA Developer can create business logic that automates common tasks or tie multiple applications together. Actively working with data to create outputs, visualizations and reports through Excel and Sharepoint are some of the daily tasks of the VBA professionals.

Here's some projects that our expert Visual Basic for Apps Developer made real:

  • Created automated solutions in Financial Spreadsheets that synchronize financial data between departments
  • Developed complex workflows with document management systems to automate dashboards and reporting capabilities
  • Built applications that facilitate data gathering, storage and extraction to facilitate business process automation
  • Worked with clients on projects to create custom interfaces that automatically populate documents with their specified fields
  • Developed powerful macros for Excel spreadsheets used for company accounting and record keeping

With the knowledgeable guidance from our Visual Basic for Applications Developers, clients can make cost-effective decisions by automating labor intensive processes and streamlining the way their businesses work. If you have a project that requires the skills of a reliable Visual Basic Application Developer, you can post your job on Freelancer.com to make sure your project is fulfilled in the most efficient way.

From 53,003 reviews, clients rate our Visual Basic for Apps Developers 4.88 out of 5 stars.
Hire Visual Basic for Apps Developers

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    22 jobs found, pricing in USD

    I am seeking an expert to streamline the process of generating organizational charts, currently done manually using MS-Visio. The goal is to automate this process through the import of a single Excel file. Key requirements include: • Automating the creation of org charts from Excel data in MS-Visio. • Implementing conditional formatting based on role features. Examples include: o Differentiating between national and expat roles with distinct shape colors. o Using varied shading based on work location. • Ensuring org charts are formatted for A3 size paper. • Incorporating vertical band lines to demarcate different organizational levels. I will provide a sample Excel dataset that accurately represents my organizational data, with color codes for conditional formatting. I ...

    $158 (Avg Bid)
    $158 Avg Bid
    27 bids

    I'm seeking a skilled freelancer with a strong command of Excel and Visual Basic to transition a complex Excel project to Visual Basic using Visual Studio 2022. Key requirements: - The primary task is to automate and improve the functionalities of the existing Excel project, by converting it to Visual Basic code. - I'm looking for a reasonable price for this conversion. Please ensure: - You've done similar projects before and can provide relevant examples of your past work. - Your experience with both Excel and Visual Basic is substantial. - The Visual Basic code should be structured and organized in a way that aligns with my specific requirements. Please start your bid with "done" to ensure you've read through my requirements.

    $125 (Avg Bid)
    $125 Avg Bid
    48 bids

    I'm looking to automate a data collection task. I need a VBA macro developed that can copy user comments from 'Website 1' and paste them into an Excel file. Here are some key details about this task: - Information Type: The focus here is strictly on user comments. I need these comments to be the only information brought from the website into the Excel file. - Spreadsheet Organization: Each comment should be placed into a new row. This will allow for a clear review and analysis of the information. Ideal freelancer for this job should have: - Robust experience with VBA macro creation - Strong understanding of data extraction - Knowledge of formatting in Excel, especially when integrating data from web sources - Comprehensive understanding of web scraping laws and ethical ...

    $18 (Avg Bid)
    $18 Avg Bid
    17 bids

    I'm in need of an Excel expert to create a process flow macro that will help in understanding the workflow of my operations. This workflow is a multi-pathway process with limited decision points, rather than a high complexity process. Skills and Experience Required: - Proficiency in Excel 2019 - Strong understanding of process flow creation on Excel - Ability to create multi-pathway process flow macros - Attention to detail to limit workflow errors Your task will involve creating a macro that makes workflow understanding effortless. Your creativity and expertise in process flow are major assets for the project.

    $12 (Avg Bid)
    $12 Avg Bid
    8 bids

    I'm looking for a professional who can develop a VBA script to extract data from specific Excel files stored in a Sharepoint folder. The extracted data should then be organized and saved into a local VBA file on my desktop. Ideal Skillset: - Experience with Sharepoint paths and access. - Proficient in VBA scripting You must have solid experience working with sharepoint paths via VBA.

    $15 / hr (Avg Bid)
    $15 / hr Avg Bid
    40 bids

    I am in need of a proficient Excel and VBA developers to assist me with a variety of tasks on an ongoing basis. Key Responsibilities: - Data Analysis and Reporting: You will be responsible for creating custom reports. This will involve data aggregation and filtering, and ensuring the reports are designed in a way that can be easily understood by stakeholders. - Automation and Macros: You will also be required to automate data visualization tasks. This should help in improving efficiency and reducing manual errors in the reporting process. - Formula Creation and Optimization: Your role will also include optimizing existing formulas and creating new ones as required. Ideal Skills and Experience: - Proficient in Excel and VBA programming - Strong attention to detail - Experience in data ana...

    $18 (Avg Bid)
    $18 Avg Bid
    17 bids

    I need an experienced VBA programmer who can help me retrieve text and numeric data from an API and insert it into an MSSQL table. Key Requirements: - Retrieve text and numeric data from an API - Insert the retrieved data into an MSSQL table - Program should run once a day Timeframe: - I would like this to be completed within a month. Ideal Candidate: - Proven experience in VBA programming - Familiarity with using APIs to extract data - Strong knowledge of MSSQL - Ability to deliver within the specified timeframe

    $659 (Avg Bid)
    $659 Avg Bid
    85 bids

    I'm looking for an Excel expert who can automate data analysis and reporting based on my sales funnel's conversion rates. This task requires extensive experience in: - Data Analysis: Knowledge and practical use of Excel functionalities for interpretation of complex sales data. - Reporting: Ability to create clear, insightful reports which highlight key trends in conversion rates. - Excel Automation: Proficiency in automating data entry, formulas, calculations, and creating pivot tables among others. The successful bidder will be able to demonstrate a proven track record in such tasks. Efficiency, attention to detail, and clear communication are also key for this project.

    $19 / hr (Avg Bid)
    $19 / hr Avg Bid
    24 bids

    I'm in need of a skilled Excel professional to revise a formula by updating cell references. Your application should include your past experience and showcases of your previous work with formulas in Excel. Please make sure the modified version is compatible with Excel for Microsoft 365.

    $98 (Avg Bid)
    $98 Avg Bid
    75 bids

    I am in need of an Excel/Google Sheets expert to create a macro that can automate my daily data entry tasks. - The macro will need to handle: 1) Create Parent Master item creation sheet as per the requirements 2) Based on Parent Master format Child Master Item sheet which can be imported into ERP Software Ideal candidates will have: - Proficiency in Excel and/or Google Sheets - Previous experience creating automation macros - Understanding of data entry processes

    $76 (Avg Bid)
    $76 Avg Bid
    65 bids

    I am looking for an expert in VBA and Excel who can modify the existing VBA to display only the ticket IDs on an Excel sheet, eliminating the need for a double scan with the QR code scanner hardware. This streamlined view is expected to significantly enhance our ticketing operations and accuracy. - Display Data: Expect the refined VBA to display the ticket ID only, excluding the ticket holder's name, purchase date, and ticket type. - Ticket ID Composition: Our ticket IDs are randomly generated alphanumeric codes. Expertise in dealing with such IDs will be beneficial. - QR Code Scanning: The scanner hardware we use can read both physical and digital QR codes. A candidate with understanding of QR code scanning across both platforms would be ideal. Prior experience in similar project...

    $124 (Avg Bid)
    $124 Avg Bid
    25 bids

    I'm in need of a highly skilled Excel expert who can help with a one-time data organization task. The data I have is both numerical and textual, and I need it to be structured and organized efficiently, and I would like to use VBA, Macros, and Coding for this task. Key project requirements: - Organizing both numerical and textual data: You will be working with a mix of different types of data, and it's essential that you can handle and structure both efficiently. - Utilizing VBA/Macros and Coding: These skills are a must for this project. You will need to be comfortable developing and implementing scripts and codes to automate and streamline the organization process. - Familiarity with Tableau: While not mandatory, experience with Tableau will be a bonus. It can be helpful for v...

    $79 (Avg Bid)
    $79 Avg Bid
    28 bids

    I need a skilled computing application expert to assist me with various tasks. Please note that the specifics of the application and the tasks to be performed will be shared with the selected candidate. Key Skills and Experience: - Proficient in computing applications, especially Microsoft Excel, MATLAB, and Python programming - Strong understanding of data analysis, task automation, and modeling/simulations - Able to efficiently organize and analyze data, automate tasks, and create visualizations or reports Please apply if you have the necessary experience and expertise in this field.

    $142 (Avg Bid)
    $142 Avg Bid
    14 bids

    I'm seeking a particularly knowledgeable individual with Power Automate looping skills, specifically someone who can make heads or tails of Excel Sheets with ease. I also require someone with substantial Chrome experience. The project in question involves: I have list of client in excel which has user id password and security answer i want to automate login to chrome on particular side and download the report using power automate. it should read and fetch the user id password security answer from excel and save the report in specific folder then i want to do the same activity for each row in excel Ideal skills/experience: - Strong background in Microsoft Excel, particularly in creating financial reports - Familiarity with Chrome - Comprehensive understanding of Power Automate l...

    $15 (Avg Bid)
    $15 Avg Bid
    16 bids

    For this project, I need a VBA expert to automate repetitive tasks, create macros for data analysis, and develop custom functions. One of the key goals is to create an automatic quotation making system. Here's what you need to know: - The data for the quotations will come from customer information, product details, and pricing calculations - Quotations should be generated based on predefined templates, using a database of products and pricing and also by calculating prices based on user inputs Given the precision needed, proficiency in VBA is non-negotiable. Experience in automating similar business processes and designing quotation systems will be a big plus.

    $88 (Avg Bid)
    $88 Avg Bid
    15 bids

    I'm looking for a skilled Excel professional to create a user-friendly and interactive template that can help me track and calculate legal risks based on the total number of hours my employees have worked. The key features of the tool should include: - **Dynamic Shift Selection:** The tool should allow me to switch between different shifts, and should automatically adjust the legal risk indicators based on the data entered for each shift. - **Graphical Indicators:** The template should present the legal risks in a clear and visual way, using graphical indicators. This will help me quickly assess the risks for each shift and take necessary actions. - **Automatic Updates:** The tool should be designed to automatically update the risk levels as I input and edit the shift data. This ...

    $172 (Avg Bid)
    $172 Avg Bid
    35 bids

    I am currently facing an issue with a VBA macro that I'm using to send emails. The problem is that images intended to be embedded in the email body are instead appearing as attachments. Key Project Details: - The email client being used is Gmail. - The email body format is in HTML. Required Skills/Experience: - Proven experience in VBA macro development. - A strong understanding of Gmail's email systems. - Proficiency in HTML formatting within emails. - Ability to troubleshoot email attachment issues. Please ensure to highlight relevant experience in your application.

    $16 (Avg Bid)
    $16 Avg Bid
    8 bids

    I have a macro that sends emails automatically through Outlook. The emails have images embedded in the body of the email, but when they are sent to a Gmail account, they are being received as attachments. I need someone who can help me resolve this issue. Key Requirements: - Fix the macro so that the images appear correctly in the email body for Gmail recipients. Skills and Experience: - Proficiency in Outlook macros and VBA. - Experience with email formatting, particularly embedding images. - Understanding of email client nuances, specifically with Gmail. It would be ideal if you could explain your approach to solving this issue in your bid. Looking forward to working with you.

    $27 (Avg Bid)
    $27 Avg Bid
    8 bids

    I need an expert to design Excel macros that will automate data entry to seamlessly update my Daily Tracker, which tracks our schedule and performance. Key requirements: - Proficient in Excel and Outlook - Experience in automating data entry - Able to accurately perform formulas and calculations - Experience in data analysis and reporting The macros should not only automate the data entry for the Daily Tracker but also send it through Outlook email daily. The ideal freelancer for this task is skilled in Excel macros, Outlook, and track performance metrics. This project would require automation to ensure efficiency and reliability in data management and reporting.

    $139 (Avg Bid)
    $139 Avg Bid
    12 bids

    Hello, Im looking for someone who knows VBA, macros inputboxes,etc. Its quite simple: I need one page wich contains different buttons that when you click it appears an inpit box with a question. Answers should be colected in another page easy to see and to make monthly summarys. It will be used for a restaurant so buttons page will be divided by two "Medio día" y "Noche" and used daily to register cashflow from the restaurant. Please contact for more details. Its a simple job compared to usual projects on the page. I think 3 days is more than enough but as Im not in a hurry you can take up to 2 weeks. Maximum Budget 150 usd (of course depens on budgets and details)

    $126 (Avg Bid)
    $126 Avg Bid
    32 bids

    I'm looking for a qualified and experienced professional to create an automatic employee scheduler in Excel. The tool is designed to manage the shifts of 20 people across two different locations. Key Features: - Employee Scheduling: The scheduler should be able to manage shifts for 20 employees. - Time-Off Management: Time-off requests should be handled on a 'first come, first served' basis. - Public Holidays: The tool should have the capability to include public holidays in the scheduling. However, I need an option to manually input these holidays as required. Ideal Skills and Experience: - Proficiency in Excel and VBA: The scheduler should be built in Excel with VBA for automation. - Experience in designing employee scheduling tools: Previous experience in creating simi...

    $141 (Avg Bid)
    $141 Avg Bid
    99 bids

    I need a VBA expert to automate my Excel-based task. The job involves collating brand forecast data from different sheets in mulitple Excel file, SKUs data for the brands from product master and historical sales data by SKU. The key tasks include: - Splitting the forecast on historic sales for each brand - Consolidating the data into a single Excel file for all the sku for upload Key skills for this job include: - Advanced knowledge and experience in Excel VBA - Experience in data collation and preparation The final deliverable should be a single consolidated Excel file, prepared for upload with the data appropriately split and formatted. the file needs to be dynamic for future changes

    $45 (Avg Bid)
    $45 Avg Bid
    23 bids

    Recommended Articles Just for You

    If you want to stay competitive in 2021, you need a high quality website. Learn how to hire the best possible web developer for your business fast.
    11 MIN READ
    Learn how to find and work with a top-rated Google Chrome Developer for your project today!
    15 MIN READ
    Learn how to find and work with a skilled Geolocation Developer for your project. Tips and tricks to ensure successful collaboration.
    15 MIN READ