Visual Basic的应用程式 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.

从62,703个评价中,客户给我们的 Visual Basic for Apps Developers 打了4.87,共5星。
雇佣 Visual Basic for Apps Developers

筛选

我最近的搜索
筛选项:
预算
类型
技能
语言
    工作状态
    21 份搜到的工作,货币单位为 HKD

    I need a proficient Excel expert to help automate data entry tasks using Excel 365. My specific need lies in automated entry of currency and numerical data. The tasks aim to reduce manual input and increase efficiency significantly. Key requirements: - Fluent in Excel 365 with solid experience in creating custom functions - Proficiency in automating currency and numeric data entry - Strength in manipulating Excel to minimize human error and optimize data accuracy - Strong understanding of how to automate task processes to enhance business operations The hired freelancer will create a functional Excel interface that accurately and autonomously carries out data entry tasks. Their work will directly contribute to more streamlined operations in my business. This is an excellent opportunity f...

    $3168 (Avg Bid)
    $3168 平均报价
    49 个竞标

    I need to modify a VBA code for a project I'm working on. Specifically, I am looking to add functionality to it, as the code is currently used to reset few PINs. I would like to include AD authentication to it. I hope to find an experienced freelancer who can help me out with this project.

    $743 (Avg Bid)
    $743 平均报价
    5 个竞标
    Excel Expert 5 天 left
    已验证

    I have an excel sheet, in which we need to do the changes. need someone with good knowledge of formulae and macros.

    $149 (Avg Bid)
    $149 平均报价
    96 个竞标

    IMPORTANT: I have modified the project slightly. Generally lighter and easier for programming. Version 2: I am seeking an expert with intermediate VBA programming skills who can collaborate effectively in order to accomplish my project requirements. Project details: I have an excel file. There are over 30 worksheets in the Excel file. In each worksheet, the following should happen when you press a key combination (for example: SHIFT+ALT+U): 1. A PDF file is created from the active worksheet. File name of the file must be generated from the active worksheet, cell C1 & pdf (Filetype) and cached in the PROTOCOLS subfolder. 2. FTP upload 1: The PDF is uploaded to a server in a subfolder (Subfolder name is in the Cell E6, worksheet SETT). The data for the server is in the "SETT&qu...

    $242 (Avg Bid)
    $242 平均报价
    17 个竞标

    I am in need of an expert in Excel with a strong focus in financial modeling and VBA programming. Key Tasks: - Developing a financial model to foreast the future financial performance of funds that was inivested. - Using VBA programming to build a complex model with multiple dependencies. the calculations is a mix of price units , distribution unit. Ideal Candidate: The suitable person for this project should be proficient in financial analysis and have extensive experience in Excel and VBA programming, particularly on creating complex models. A proven track record of successful financial forecasts is highly desirable. Accuracy and attention to detail are a must for this task. do not apply if you do not have experience in financial modelling and familair with shares only expert no ...

    $78 / hr (Avg Bid)
    $78 / hr 平均报价
    35 个竞标

    Must be based in Brisbane and can meet up. I am in dire need of a proficient Excel developer who can tackle a variety of tasks to enhance the functionality of my spreadsheets. My aim is threefold: 1. **Sophisticated Formulas and Functions** - Though I skipped detailing specific formulas or functions, my project will require in-depth knowledge and application of a wide range. Expertise in advanced functions is a must. 2. **VBA Macro Programming for Automation** - My primary focus here is on three critical areas: - **Data Entry Automation**: Streamlining the process of inputting information into the spreadsheet. - **Report Generation**: Crafting macros that can automatically generate comprehensive reports from the data. - **Data Validation and Cleaning**: Developing ...

    $682 (Avg Bid)
    $682 平均报价
    30 个竞标
    Financial Excel Wizard Needed 3 天 left
    已验证

    I'm on the hunt for a seasoned freelancer who thrives in creating Excel templates for financial data reconciliation. My project revolves around intermediate financial data that requires more than a simple two-way match. I work in insurance and need help to develop a reconciliation report template I can use for accounts between our system and he supplier. Would need at least two columns to match policy number and dollar amount. Specific skills and experience desired: - Proficient in Excel, especially in handling intermediate to complex financial data. - Experience in creating custom formulas and potentially working with macros. - Ability to implement error detection mechanisms, a plus. - Skilled in integrating data visualization tools within Excel, highly regarded. Ideal functiona...

    $2636 (Avg Bid)
    $2636 平均报价
    62 个竞标

    I'm in need of an Excel VBA specialist to create an easy-to-use workbook for data entry and validation purposes. This application will require the following features: - The ability to enter random rosters - Setting of pay parameters including different percent premiums for various shifts, such as afternoon (15% loading), night, Saturday, Sunday, Overtime and Public Holidays - Automated calculation of payroll based on the defined parameters and the entered roster The perfect candidate will have a solid understanding of Excel VBA programming, especially in creating automated calculations and formulas, as well as report generation. Familiarity with payroll calculations would be a great plus. This is a straightforward project for an adept Excel VBA coder. I look forward to seeing your b...

    $10716 (Avg Bid)
    $10716 平均报价
    58 个竞标

    I require an Excel Workbook that can support a wide range of rosters involving various pay parameters. The Workbook should allow for the input of any given roster, and automate the assessments of pay based on a variety of specifics: - Premiums associated with hours of work which include daytime shifts, night shifts, weekends and public holidays. - Calculation of pay parameters such as the hourly rate, overtime rate, and special shift percentages ( afternoon, night and weekend loadings). The ideal freelancer for this task should possess a high level of competency in Excel, particularly in the areas of advanced VBA programming, functions and calculations. An attention to detail is imperative to ensure all factors of the pay parameters are applied correctly and implemented accurately.

    $10223 (Avg Bid)
    $10223 平均报价
    41 个竞标

    I am seeking a talented freelancer to create a custom spreadsheet that is both highly functional and aesthetically pleasing. The ideal candidate will have a deep understanding of data entry, calculations, and how to generate insightful reports and visualizations. Here are the specifics of what I'm looking for: - **Key Functionalities Needed:** - Efficient data entry capabilities for both numeric and text data. - Advanced formulas and functions for various calculations. - Dynamic reporting and visualization tools to make sense of the data entered. - **Data Types:** - The spreadsheet should be capable of handling numeric as well as text data efficiently. - **Design Preferences:** - The design should be simple and clean, ensuring ease of use without sacrificing functionali...

    $1298 (Avg Bid)
    $1298 平均报价
    25 个竞标

    I'm currently in need of a Powershell script that reads data from an Excel 2019 spreadsheet and utilizes that data to create folders on OneDrive in a specified sequence. The sequence of folder creation will strictly adhere to the sequence laid out in the Excel spreadsheet. Furthermore, permissions of these newly created folders will also be determined by the corresponding data present in the spreadsheet rows. Ideal skills and experience for this project would include: - Proficiency in Powershell scripting - Experience with the 2019 version of Excel and its data management capabilities - Familiarity with the OneDrive API and its permissions setting mechanisms Clear understanding of these concepts is instrumental in the successful execution of this project.

    $868 (Avg Bid)
    $868 平均报价
    22 个竞标

    I'm in need of an experienced Excel expert. This task will require executing the following: - Data entry and formatting: The project involves migrating a substantial dataset from our existing software suite into Excel. These numerous records must be entered accurately and formatted appropriately for efficient use. - Creation of formulas and functions: To replicate the functionality of our software within Excel, you'll be asked to develop suitable formulas and functions. - Automation of data processing: Once data and functions are in place, you'll need to leverage Excel's automation capabilities to streamline the processing of this considerable dataset. The complexity of the software being replicated is moderate. The necessary Excel wizard should have a strong backg...

    $5053 (Avg Bid)
    $5053 平均报价
    43 个竞标

    I'm seeking a freelancer with a strong background in Excel VBA and payroll systems to update my payroll macro file crucially. This project involves enhancing the calculation formulas to adhere to the California prevailing wage requirements which are intricate and multifaceted. We already have a macro file that take timesheet and calculates regular pay/OT vs DBT per CA law **Key Updates Required:** - **Modification of Calculation Formulas:** The updates will specifically include adjustments to incorporate: - Different hourly wage rates. - Fringe benefits calculations. - Varied rates per job classifications. - Distinct holiday pay rates per job type. - Overtime (OT) calculation enhancements. **Ideal Skills and Experience:** - Proficiency in Excel VBA programmin...

    $7720 (Avg Bid)
    $7720 平均报价
    44 个竞标
    Excel Tax Sheet Overhaul 2 天 left
    已验证

    I'm looking for an experienced freelancer to enhance my existing Excel sheets focused on tax expenditures and revenues. The major areas of improvement include: - **Updating Existing Formulas**: Ensure all formulas are correctly calculating the current data and adjust where necessary for accuracy. - **Generating Summary Reports**: Develop a feature within the sheet that allows for the automatic generation of summary reports, providing a clear overview of the data at a glance. This task requires a one-time update to the sheets, but with an emphasis on creating a template that I can easily replicate and use annually without further assistance. **Ideal Skills and Experience**: - Profound knowledge in Excel, including complex formulas and data analysis tools. - Experience in designin...

    $1025 (Avg Bid)
    $1025 平均报价
    37 个竞标

    I'm looking for a talented freelancer to create a VBA script that automates the generation of reports from Excel spreadsheets on a monthly basis. This project requires precision and reliability, ensuring that the generated reports are accurate and timely. **Key Requirements:** - Develop a VBA script capable of accessing data from specified Excel spreadsheets. - Automate the generation of comprehensive reports with the data. - Ensure the report output is well-structured and presentable. **Ideal Skills and Experience:** - Proficient in VBA programming with a solid background in report generation. - Experienced with Excel functions, formulas, and data manipulation. - Ability to design and format reports for clarity and professionalism. - Strong attention to detail and a commitment to a...

    $63 / hr (Avg Bid)
    $63 / hr 平均报价
    15 个竞标

    I'm in need of an Excel pro to create a customized inventory and order spreadsheet for my business. Get ready to dive into the details, as this system is crucial to streamlining my operations. Key features I want to include are: - Inventory List: Have a clear overview of items in stock. - Par Levels: A systematic way to reorder items when stock drops to a certain level. - Cost of Stock On Hand: An overview of the financial value of my stock. - Automatic Order Generation: Let par levels trigger the order process automatically when current stock dwindles. Ideally, you're someone who doesn't just know how to handle Excel formulas, but can also create an intuitive layout that's clear, efficient, and user-friendly. Speed is of the essence, so if you're up for the ch...

    $767 (Avg Bid)
    $767 平均报价
    62 个竞标

    I'm seeking an experienced freelancer to develop a Microsoft Excel spreadsheet tailored for managing material prices, generating bundled item quotes, and calculating material list and labor totals. This spreadsheet is crucial for streamlining my project management and quote generation process in a user-friendly manner. **Requirements:** - **Creating Material Bundles:** Custom functionality to bundle various materials into predefined sets for ease of quoting. - **Generating Quotes:** Ability to automatically generate quotes based on the bundled item lists which include price calculations for both material and labor efforts. - **Producing Material and Labor Totals:** Feature to produce comprehensive lists showing total material requirements and labor estimations derived from the...

    $97 / hr (Avg Bid)
    $97 / hr 平均报价
    75 个竞标

    I'm on the lookout for a strong Excel VBA developer to assist in several upcoming projects. **Ideal Skills & Experience:** - Proven expertise in Excel VBA development, specifically in Automation and Macro creation. - Strong understanding of data analysis principles that complement automation efforts. - Ability to not only execute tasks but also provide strategic recommendations for process improvements. **Responsibilities:** - Develop and implement custom macros to automate repetitive tasks, ensuring both accuracy and efficiency are improved. - Collaborate closely with our team to understand process bottlenecks and devise VBA-based solutions to address them. - Provide insights and suggestions on how to best leverage Excel VBA functionalities to meet our project objectives. 10-3...

    $70 / hr (Avg Bid)
    $70 / hr 平均报价
    45 个竞标

    I'm in need of an expert to create a fully automated Excel program that I'll be using daily. This task is crucial for streamlining my daily operations and requires precision and expertise. **Essential Requirements:** - **Spreadsheet Automation:** The program should analyze data and generate reports without any manual intervention. I'm looking for a solution that significantly reduces my workload by handling these tasks effortlessly. - **Usage Frequency:** This Excel program is not a one-time affair but a daily tool crucial for my operations. Hence, reliability and efficiency are key. - **User Interaction:** The ideal program should operate with minimal user input. Once set up, I expect it to run seamlessly, only requiring me to review the outcomes. **Ideal Skills and Ex...

    $704 (Avg Bid)
    $704 平均报价
    20 个竞标

    I'm seeking a skilled professional who can proficiently develop a dynamic VBA code for a monthly performance report. Key Task: - Implement code in VBA, demonstrating your deep understanding of its syntax and structure. Report Details: - The report is specialized in performance test results. Familiarity with this data field is desired for the effective extrapolation of key insights. Data Calculation and Representation: - The code should be able to calculate and report percentage values. Knowledge of statistical reporting and mathematical functions within the VBA framework is a must. Your mastery of VBA, keen understanding of data particularly in performance test results, and ability to perform complex calculations are crucial for the success of this project.

    $23 / hr (Avg Bid)
    $23 / hr 平均报价
    16 个竞标
    Dynamic Spreadsheet Design Pro 7 小时 left
    已验证

    I'm in need of a proficient freelancer who excels in both Excel and Google Sheets, to help bring my data management to the next level. Combining aesthetics with functionality, I aim to create a custom workbook that is not only efficient but also pleasing to the eye. **Core Requirements:** - Mastery in applying advanced formulas and functions to manipulate data effectively. - A keen eye for formatting and design to make the workbook intuitive and user-friendly. - Experience in creating custom workbooks in both Excel and Google Sheets, ensuring seamless functionality across platforms. **Project Specifics:** - The workbook should consist of multiple tabs, each designated for different sections, to categorize data systematically. - It's imperative that the freelancer is adept at us...

    $1064 (Avg Bid)
    $1064 平均报价
    25 个竞标

    专为您推荐的文章

    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