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 54,156 reviews, clients rate our Visual Basic for Apps Developers 4.86 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 AUD

    I need a proficient VBA developer to create a many-to-one mail merge in Word solution. The requirement is for a mail merge that sends personalised emails to key employees of a unique customer ID, consolidating all transactions for that customer. Key areas of the project include: - Referencing an Excel document housing a list of key employees all identified by a unique customer ID. - Each transaction in the mail merge needs to include a table with 11 fields/columns detailing key information such as transaction amount, date, and type. Ideal Skills and Experience: - Mastery in VBA coding - Extensive experience with Word and Excel Mail Merge - Solid understanding of transaction data Being able to deliver a smooth, error-free, and user-friendly solution is critical. I'm expecting a...

    $254 (Avg Bid)
    $254 Avg Bid
    33 bids

    I need a system that can automate the data entry of Excel sheet information into a Word document ive attached the word doc template with the colomume names that data needs to com from. The process involves: - Adding an MPRN before the number in the Excel cell. - Adding GT1 at the end of the file name. - Saving each populated form as a separate file. The system should also: - Send each form in a separate email. - Determine the email recipient based on the postcode. For this, you will need to check the postcode on to ascertain the correct email to send the form to. - Only include specific columns from the Excel sheet data in each email. Ideal skills for this project include: - Proficiency in VBA for Word and Excel - Experience in automating data entry and document generation - Knowledge ...

    $176 (Avg Bid)
    $176 Avg Bid
    47 bids

    I'm looking for an Excel automation expert who can help me in creating an automated Excel sheet for performing calculations and sending an email based on the data. Key Tasks: - Perform Basic Arithmetic and Financial Calculations: The automated Excel sheet needs to be capable of performing basic arithmetic calculations such as addition, subtraction, multiplication, and division. It should also be able to handle financial calculations like calculating interest rates, profit margins, etc. - Implement Email Sending Functionality: The sheet should have the capability to send an email based on the calculated data. Ideal Skills and Experience: - Proficient in Excel Macros: The freelancer should have a strong background in creating Excel macros to automate tasks in Excel. - In-depth unde...

    $137 (Avg Bid)
    $137 Avg Bid
    63 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.

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

    I am looking for a professional who can create a dynamic school timetable system. The ideal system should have the capability to: - Add and edit classes swiftly and smoothly, - Automatically schedule the classes, taking into consideration more than 20 different classes that the system needs to manage, - Freeze classes, - Facilitate combinations of classes, - Link teachers to the relevant classes, - Generate notifications for any changes in the timetable. The system must also be designed to accommodate a maximum of 40 students per class. Proficiency in systems development and a fond understanding of school systems would be ideal for this project.

    $216 (Avg Bid)
    $216 Avg Bid
    18 bids

    I'm seeking an expert in Microsoft Word, Microsoft Form, and POWER AUTOMATE -Visual Basic for automating my repetitive data entry, document formatting, and reporting tasks. I currently use Microsoft Word and Microsoft Form for these tasks but it’s costing me time and efficiency. Key Deliverables: - Designing ADVANCE MICROSOFT FORM INTEGRATE WITH POWER AUTOMATE TO automatically Generate MS word document - using OCR action in power automate Web scrapping with Power automate advanced microsoft form and VB programming - Compiling data into interactive reports Ideal Skills: - Proficiency in Microsoft Word & Microsoft Form & POWER AUTOMATE - Advanced understanding of Visual Basic - Experience in UI design & data management - Familiar with advanced automation tech...

    $776 (Avg Bid)
    $776 Avg Bid
    35 bids

    I'm looking for an Excel expert to fully automate some tasks for me. - Tasks to be Automated: The job includes automating data entry, data analysis, and report generation. I require someone with proficient knowledge of Excel functions and automation tools to get this done efficiently. - Number of Files: The automation is expected to be implemented across 1-5 Excel files, so you should be comfortable handling several files simultaneously. - Complexity of Data: The data sets that need to be automated are of moderate complexity with numerous variables. Your experience with similar data sets would be advantageous. Ideal skills and experience: - Microsoft Excel advanced user - Experience with data analysis and report generation in Excel - Familiarity with moderate datasets with numero...

    $634 (Avg Bid)
    $634 Avg Bid
    40 bids

    I'm seeking a professional with expertise in Excel automation to assist in generating a one-time Excel report from a set of PDFs. Key Responsibilities: - Automate data entry from PDFs into Excel - Create an Excel report that provides a summary of key metrics Ideal Skills and Experience: - Proficiency in Excel, including automation and data entry - Prior experience in creating Excel reports - Ability to work with PDFs - Strong attention to detail, ensuring accurate data entry and summary of key metrics Please note, this is a one-time project. The successful candidate will have the opportunity to work on future projects of a similar nature, should the initial collaboration be successful.

    $17 / hr (Avg Bid)
    $17 / hr Avg Bid
    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.

    $10 - $100
    Sealed
    $10 - $100
    31 bids

    I require a skilled freelancer to create a macro that will extract a Bill of Materials (BOM) from Catia and export it to Excel. The macro should pull the following details from the BOM: - Part name and number - Quantity - Material - Part picture - Part Weight - Level in assembly tree Once the extraction is complete, automation macros need to be built into the Excel file. The primary task to be automated is data entry validation. The ideal candidate should also provide samples of their past work creating similar macros for Catia and Excel. This past experience is essential for understanding the complexities associated with BOM extraction and Excel automation.

    $672 (Avg Bid)
    $672 Avg Bid
    32 bids

    I'm looking for an Excel expert who can create a macro to connect directly to our Investran database. Your primary tasks will be: - Establish a direct connection between the Excel macro and the Investran database - Read data from the Investran database and display it in an Excel spreadsheet - Write data to the Investran database as directed - Update existing records in the Investran database based on the changes made in Excel The ideal candidate should have: - Excellent knowledge and experience with Excel VBA - Prior experience connecting Excel to external databases - Familiarity with Investran database is a plus - Strong understanding of data handling and manipulation in Excel - Excellent attention to detail in data input and output

    $132 (Avg Bid)
    $132 Avg Bid
    16 bids

    I am in need of an Excel-based trucking rating program in excel which can streamline our freight charges calculations and rating process. Key Tasks: - Calculate Freight Charges: The system should be able to compute freight charges accurately by considering the weight of the shipment, assessorial charges, and different weight breaks. - Compare Rates: The system should analyze and compare rates from various sources. - Generate Invoices: The system should be able to automatically generate invoices based on the calculated freight charges. Ideal Skills and Experience: - Proficiency in Excel: The freelancer should have a strong background in Excel and VBA to create a robust and efficient system. - Knowledge of the Trucking Industry: Prior experience in the trucking industry would be helpful,...

    $1126 (Avg Bid)
    $1126 Avg Bid
    72 bids

    I'm in need of an expert in VBA Excel macros to develop a custom solution for generating customer information reports using LinkedIn. This macro should effectively capture and collate the following specifics from our data: * Customer Name * Location * Designation * LinkedIn URL It is crucial for the macro to handle large volumes of data seamlessly and produce an accurate and concise report. A working knowledge of advanced VBA functionalities is necessary, along with previous experience working on similar projects. Your familiarity with handling sensitive customer data and assuring its privacy is expected. Dedication to job accuracy and attention to detail will be tremendous assets. Your role will entail taking full responsibility for the macro right from creation to testing, ensur...

    $107 (Avg Bid)
    $107 Avg Bid
    15 bids

    Creating invoices on ms excel , part time job .

    $98 (Avg Bid)
    $98 Avg Bid
    36 bids

    I'm looking for an Excel expert to fully automate some tasks for me. - Tasks to be Automated: The job includes automating data entry, data analysis, and report generation. I require someone with proficient knowledge of Excel functions and automation tools to get this done efficiently. - Number of Files: The automation is expected to be implemented across 1-5 Excel files, so you should be comfortable handling several files simultaneously. - Complexity of Data: The data sets that need to be automated are of moderate complexity with numerous variables. Your experience with similar data sets would be advantageous. Ideal skills and experience: - Microsoft Excel advanced user - Experience with data analysis and report generation in Excel - Familiarity with moderate datasets with numero...

    $123 (Avg Bid)
    $123 Avg Bid
    35 bids

    I have a medium-scale project that calls for specific expertise in VB macro. I require assistance in: - Automating data entry: You should be able to craft a VB macro that can simplify and speed up the process of data input. - Generating reports: The ability to create, design, and automate reports using VB macro is crucial in this project. - Customizing Excel functions: There will be a need for custom functions in Excel 2016, created with the VB macro. Given these tasks, the ideal candidate would possess strong skills in VB macro coding and a comprehensive understanding of Excel 2016. Experience in handling medium-scale data projects with moderate complexity will be highly advantageous.

    $44 / hr (Avg Bid)
    $44 / hr Avg Bid
    51 bids

    I'm in search of an Excel wizard who can enhance our shared workbooks with macros for data analysis, report generation, and task automation. Main Responsibilities: - Implementing macros for sorting and filtering data, and calculating complex formulas. - Summarizing data in tables to generate comprehensive reports. The ideal candidate should have extensive experience in Excel's advanced features, specifically macros, and have stellar skills in data visualization techniques. You should be familiar with designing shared workbooks for multi-user environments whilst maintaining data integrity. If you're a problem solver who can create macros that simplify our workload, I would love to connect.

    $29 (Avg Bid)
    $29 Avg Bid
    26 bids

    I have a VBA macro that has several issues. It's not executing properly, giving incorrect output, and even throwing error messages. I need an expert in VBA to help me with the following: - Debug the code: Identify and rectify the root cause of the problem that is preventing the macro from executing as intended. - Test the macro: After debugging, run the code to ensure it works correctly without any issues. - Demonstrate the functionality: Provide me a demonstration showing that the macro is now correctly automating the repetitive tasks as I intended. Skills and experience required: - Strong expertise in VBA programming is a must. - Experience in debugging complex VBA code and fixing errors. - Proficiency in Microsoft Excel, specifically Excel 365. - Ability to clearly communicate an...

    $30 (Avg Bid)
    $30 Avg Bid
    50 bids

    I am in dire need of a proficient VBA MS Access developer who can skillfully craft a master details form. The selected freelancer should expect dynamic changes in the form, including the addition and removal of columns. The nature of the specific fields/columns to be added or removed hasn't been outlined, so the freelancer should be flexible and adaptive. Furthermore, since the organization preference of the details form hasn't been specified, the freelancer should be creative and have a knack for intuitive, logical organization. Core requisites for the task: • In-depth comprehension and proficiency in VBA MS Access • Exceptional adaptability due to the dynamic changes in the form • Creativity in the logical structure of the form

    $11 / hr (Avg Bid)
    $11 / hr Avg Bid
    25 bids

    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...

    $113 (Avg Bid)
    $113 Avg Bid
    45 bids
    Interact with Dahua SDK 3 hours 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:

    $170 (Avg Bid)
    $170 Avg Bid
    54 bids

    Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

    $45 (Avg Bid)
    $45 Avg Bid
    1 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