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 55,512 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
    25 jobs found, pricing in USD

    I'm in need of an expert who can create an application or a piece of code that will retrieve and display real-time stock prices for publicly traded companies from Google Finance to an Excel sheet. Key Requirements: - Have the ability to pull real-time data for company stocks from Google Finance - Automatically update this data within an Excel Spreadsheet - Create a user-friendly interface, allowing me to navigate and use effectively Ideal Skills: - In-depth understanding of Google Finance - Proficient in Excel with demonstrable experience in creating and using scripts/macros - Strong background in data extraction and manipulation - Experience in real-time data handling - Financial market understanding. The application or code developed should allow seamless updates, ensuring I...

    $66 (Avg Bid)
    $66 Avg Bid
    26 bids
    Interact with Dahua SDK 6 days left
    VERIFIED

    I need to be able to interact with a Dahua brand fingerprint reader. I need to be able to enter, consult and delete fingerprints by software. All this from a VB.Net application I think the SDK can be found at this link:

    $113 (Avg Bid)
    $113 Avg Bid
    49 bids

    I'm looking for a specialist in MS Access VBA to create a solution that will automate the generation of shipping labels from within our database. The ideal candidate should have extensive experience in this area and be able to deliver a highly efficient and reliable tool.

    $5 - $10 / hr
    Sealed
    $5 - $10 / hr
    22 bids

    I am looking for an experienced macro coder to automate data analysis tasks for our existing business using MS Excel. The ideal candidate should have expertise in MS Excel and macro coding. The main tasks for this project include: - Developing a macro to automate data analysis processes - Implementing the macro in MS Excel - Ensuring the macro effectively analyzes and processes data - Providing documentation and instructions for using the macro efficiently Skills and Experience Required: - Proficiency in MS Excel and macro coding - Strong understanding of data analysis techniques - Experience in developing macros for business purposes - Attention to detail and ability to accurately analyze data If you have the necessary skills and experience, please submit your proposal.

    $7 - $33
    Sealed
    $7 - $33
    37 bids

    I am in need of an expert who can develop an Excel macro that would accurately compare my coordinates, given in excel, with a set of uploaded KML files. The purpose of this macro is to assess whether these coordinates lie within specified coverage areas. If they fall outside, the macro should have the capability to adjust these coordinates up to 1km. Therefore, the professional who takes on this project would ideally have the following skills and experiences: - Expertise in Excel macro development - Proficiency in working with KML files - A sound understanding of geo-mapping concepts The expected deliverable is a fully functional Excel macro that offers precision in comparative analysis and requisite adjustments. Looking forward to your bids!

    $135 (Avg Bid)
    $135 Avg Bid
    61 bids

    I have an Excel 2003 file with VBA code that generates PDF pages from the data. However, I'm facing issues when it comes to completeness of the PDF pages. See attached 2 photos please. Key Issues: - Some generated PDF pages are missing text Additional Details: - The Excel data is structured across multiple sheets I'm looking for a VBA expert who can help me troubleshoot and fix the issues with the VBA code in Excel 2003. The ideal freelancer for this project should have: - Proficiency in VBA, especially within Excel 2003 - Experience with generating PDF files from Excel data - Ability to troubleshoot and identify issues in a VBA code - Strong attention to detail to ensure the completeness of the generated PDF pages If you have the necessary skills and experience, please feel ...

    $115 (Avg Bid)
    $115 Avg Bid
    46 bids

    I'm in immediate need of an Excel expert who can deliver fast turnarounds and handle large, complex data sets. The ideal candidate will have experience in data analytics, financial analysis, or accounting. Tasks: - Creating VBA code - Developing macros - Creating data dashboards VBA Code Usage: - Automating repetitive tasks - Manipulating and analyzing financial and geographic data Ideal Skills and Experience: - Expertise in Excel, VBA, and macros - Proven ability to work with large, complex data sets - Experience in data analytics, financial analysis, or accounting If you have the necessary skills and can start right away, please reach out.

    $10 - $100
    Sealed NDA
    $10 - $100
    31 bids
    Timesheet analysis 4 days left
    VERIFIED

    i need to analyze a set of timesheet and determine the following output shifts where start time are earlier or later than rostered time (in minutes) shifts where end time are earlier or later than rostered time split shifts - where the end of one shift and commencement of the other shift is more than one hours but less than 10 hours challenges .. the data set -... broken shifts .. shifts worked passed midnight..

    $86 (Avg Bid)
    $86 Avg Bid
    66 bids

    I'm seeking an Excel VBA expert to code for data analysis, automate repetitive tasks and generate reports. I have a design template that I would like you to adhere to, making suggestions where you deem necessary for its improvement. This project involves extensive use of Excel spreadsheets that contain the specific data files to be accessed. Ideal Skills and Experience: - Extensive knowledge of Excel VBA - Proficiency in data analysis and report generation - Skilled in automation of tasks within Excel - Ability to work with existing design templates - Familiarity with accessing data from Excel spreadsheets - Have an eye for potential improvements within the design framework

    $16 (Avg Bid)
    $16 Avg Bid
    18 bids

    I'm seeking a proficient VBA developer capable of writing a code for an essential task. Your primary role will involve creating multiple PDFs from pivot tables. - The operation will source data from a pivot table in Excel. - The PDFs should encapsulate the entire pivot table without missing a single row or column. - Your VBA skills should allow not only text extraction from PDFs but also converting PDFs to Excel format. An essential skill for this role includes VBA with a successful history of PDF manipulation tasks. Having prior experience with pivot tables will be highly beneficial.

    $12 / hr (Avg Bid)
    $12 / hr Avg Bid
    18 bids

    I'm in need of a VBA script that can communicate with a Google Script, sending two text strings to it. The Google Script will then search for the first string in the sheets within column A. The VBA script needs to interpret the Google Script's response - returning true if the string is found and false if it is not. Key Requirements: - The VBA script should be designed to run multiple times a day. - The VBA script should display a message box in case of any errors. The ideal freelancer for this project should have: - Proficient in VBA and Google Script - Strong understanding of data communication between Excel and Google Sheets - Experience in handling error messages within VBA scripts

    $34 (Avg Bid)
    $34 Avg Bid
    23 bids

    I'm seeking a VBA expert to enhance my Excel sheet by coloring selected cells based on specific cell formulas. Key Requirements: - The code should target specific cells, not the entire sheet. - The VBA code must reference the cell formulas to determine the color, not the cell values or conditional formatting rules. Please ensure that your bid includes: - A summary of your relevant experience with similar VBA projects. - An estimated timeline for completion.

    $14 (Avg Bid)
    $14 Avg Bid
    19 bids

    We need an Excel expert to enhance and unify two existing spreadsheets into one comprehensive system capable of advanced calculations, multi-page reporting, and data analysis. The final spreadsheet should: - Integrate 14+ tabs and have the flexibility to expand as needed. - Automate report and proposal generation. - Maintain a structured 'data-bank' for ongoing and future use. - Include enhancements in data collection, formula creation, and automated PDF transformation. Essential skills: Advanced Excel, Macros, Data Analysis, Microsoft Word integration.

    $1040 (Avg Bid)
    NDA
    $1040 Avg Bid
    67 bids

    I'm looking for an expert in Excel VBA to modify an existing project. Key aspects of this job will include: - Modifying existing code: Your role will involve adjusting the current setup of my Excel VBA project. The import file layout has changed and so the current import script will not work. This will need to be modified / re-written in order to accommodate the new import file layout. It should be straight forward. The way the current file is set up is as follows: The first sheet is where the imported information is filtered and then stored with the latest information being at the top. In addition to this a time and date of import cell will be populated. The second sheet is a list of variables for the third sheet. The third sheet houses the button for an operator to select to run t...

    $167 (Avg Bid)
    $167 Avg Bid
    53 bids

    I'm in dire need of an expert with proficiency in VBA and mail merge in Microsoft Word 365. The critical aspect of the project is maintaining superscript formatting, specifically on date ordinals, during the mail merge process. Key Responsibilities: - Rectify the issue causing mail merge to lose superscript formatting of date ordinals - Merge data into multiple letter templates Ideal Experience: - Expert in VBA - Extensive experience with Microsoft Word 365 - Prior experience with mail merge and superscript formatting Please bid if you've tackled such issues before and you're confident in your skills to execute this task. Looking forward to our collaboration.

    $13 (Avg Bid)
    $13 Avg Bid
    10 bids

    I need a VBA macro that can perform a permutation match in Excel. Requirements: - The macro should be able to perform both Exact matches and Combination matches. - The aim is to highlight the matches and occurrences in the worksheet without generating a report. - The macro should be optimized for speed and efficiency when dealing with large datasets. Ideal Freelancer: - Proficient in Excel VBA and has experience in creating macros for data matching. - Understands permutation matching and how to implement it in Excel. - Prior experience in optimizing VBA for performance would be highly advantageous. - Ability to communicate clearly and willingness to make adjustments based on feedback.

    $121 (Avg Bid)
    $121 Avg Bid
    50 bids

    I'm looking to hire an Excel expert who can create a macro that not only converts Excel XLS spreadsheet data to PDF reports but also embeds JPEG photos within these reports. The ideal candidate should be comfortable with the following: - Working effectively with Windows operating system. - Capability of creating sophisticated macros that can convert Excel to PDF. - Automatically linking JPEG images from a specific folder using filenames referenced in the Excel sheet. This project requires strong skills and experience in advanced Excel functions, macro creation, image manipulation and dealing with XLS spreadsheets. The success of this project lies in creating robust, reliable and efficient macro that simplifies my PDF report generation process.

    $528 (Avg Bid)
    $528 Avg Bid
    101 bids

    I'm looking for a freelancer with a solid background in handling numeric data in Excel and experience with custom sorting rules. Key requirements: - The Excel file contains numeric data that needs to be sorted - The sorting needs to be done based on specific, custom rules that I will provide Ideal skills and experience: - Proficiency in Excel and handling numeric data - Experience with custom sorting in Excel - Attention to detail to accurately apply the custom rules In your application, please highlight your relevant experience with similar projects.

    $12 (Avg Bid)
    $12 Avg Bid
    50 bids

    I am seeking an experienced freelancer who can assist me in creating a VBA (Visual Basic for Applications) code licensing model for my CorelDraw codes. This project is similar in functionality to eCut. Here are the specifics: 1. Licensing Model: I am interested in setting up a per-user licensing model. Each user that subscribes to my service should obtain an individual license to use my VBA code. 2. Subscription-Based Access: The system should allow users to take out a subscription to gain the benefits of using the licensed codes. 3. Feature Limitation: In the licensing arrangement, I aim to limit access to specific code functionalities. Details about which functionalities will be restricted will be discussed during project development. The ideal candidate for this job should have: -...

    $1185 (Avg Bid)
    $1185 Avg Bid
    34 bids

    I need a Mainframe macros script to automate the generation of daily summary reports. The main purpose of the macros is to track the job's start time, end time, and status, and to provide a notification in case a job abends. Key Requirements: - The script should generate a daily summary report with timestamps for jobs. - It should be able to track the start time, end time, and status of each job. - In case of a job abend, the script should send a notification. Ideal Skills: - Proficiency in Mainframe programming and experience with creating macros. - Understanding of data tracking and timestamping. - Ability to automate report generation and notifications.

    $32 / hr (Avg Bid)
    $32 / hr Avg Bid
    5 bids

    I am on the hunt for someone highly adept at managing and manipulating Excel data. The job entails the merging of 6 to 10 tabs into a single, functional entity. The system would then need to allow for text data input into one primary tab which then consequently populates to the other related tabs. The data across the tabs are dependent on each other hence should reflect corresponding changes. I will need to talk to someone over teams or the phone to further explain what's needed. Ideal Skills and Qualifications: - Advanced Excel skills, especially in tab management and data consolidation - Excellent grasp and application of data dependencies - Capable to run tests to ensure data is correctly populating across tabs - Prior experience handling similar Excel projects. Bid if you ar...

    $428 (Avg Bid)
    $428 Avg Bid
    47 bids

    I'm looking for a skilled Excel VBA developer to create a comprehensive tool that can help me with my sales and purchase processes. This tool should be able to handle generating invoices and receipts, as well as tracking inventory. Key Features: - **Invoicing & Receipts:** I need this tool to automatically populate customer information, include an itemized list of purchased products, and calculate the total amount along with taxes. - **Inventory Management:** The tool should have the capability to track product name and quantity, as well as price, cost, and supplier information. Ideal Skills: - Proficient in Excel VBA and advanced functions - Prior experience in developing similar tools or applications - Attention to detail and ability to create a user-friendly interface

    $12 / hr (Avg Bid)
    $12 / hr Avg Bid
    14 bids

    I'm looking for a skilled Excel VBA developer to create a comprehensive tool that can help me with my sales and purchase processes. This tool should be able to handle generating invoices and receipts, as well as tracking inventory. Key Features: - **Invoicing & Receipts:** I need this tool to automatically populate customer information, include an itemized list of purchased products, and calculate the total amount along with taxes. - **Inventory Management:** The tool should have the capability to track product name and quantity, as well as price, cost, and supplier information. Ideal Skills: - Proficient in Excel VBA and advanced functions - Prior experience in developing similar tools or applications - Attention to detail and ability to create a user-friendly interface

    $13 / hr (Avg Bid)
    $13 / hr Avg Bid
    16 bids

    I am seeking a VBA Excel expert who can effectively create a data entry form with a dropdown menu for selecting Date and Time. Precise knowledge of automatic calculations and error validation in Excel is beneficial. Furthermore, the project entails the development of a meeting management system within Excel, specifically designed to oversee meeting dates and times. This project demands strong skills and expertise in VBA, pinpoint accuracy, and attention to detail. • Outstanding proficiency in VBA Excel • Advanced knowledge in creating and modifying dropdown menus • Experience in creating scheduling/management systems • Precision and thoroughness in error validation • Demonstrated ability to meet deadlines.

    $94 (Avg Bid)
    $94 Avg Bid
    27 bids

    Tenho um arquivo VBA, porém preciso de alguém que tenha experiência com a criação e aplicação de macros para proporcionar que o produto final esteja funcional. Trata-se de uma aplicação para ser usada em uma unidade básica de saúde para cadastrar os pacientes e manter estes dados arquivados em planilha. Também com essa aplicação a unidade de saúde deve conseguir organizar o arquivo de prontuários médicos, podendo procurar os prontuários por número, nome do paciente, estante, prateleira, cor da pasta etc. Existe também uma tela de login para os usuários da aplicação, onde só poderão acessa-lo com usuario e senha previam...

    $180 (Avg Bid)
    NDA
    $180 Avg Bid
    16 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