Visual Basic for Apps Jobs

My Excel macro is not functioning as expected. It goes to debug right at the start of execution, with run time error 13, type mismatch. I'm looking for a freelancer who can fix this issue. Ideal candidates should have: - Proficiency in Excel and VBA programming - Experience in debugging Excel macros - Ability to deliver quick and efficient solutions i am in Arizona and ok to access my computer to run and fix. I had this macro installed years ago and no problems until now. There may also be 2 other macro problems, but may be part of this one.

I need a VBA project for Excel that automates data entry tasks, with a few simple user forms and a connection to an Access database. Key Requirements: - Data Entry Automation: The main goal of this project is to streamline data entry tasks. - Automation Tasks: The VBA automation should handle importing data from Access, validating user input, and creating new records in Access. - User Forms: I require some simple input forms in the Excel VBA project. VBA Project Security: It is crucial that this VBA project is secure and only I can access it.

I'm in need of an Excel wizard who can create advanced macros for me. The task involves: - Developing complex algorithms to automate tasks within Excel - Integrating these macros with databases Ideal candidates for this project should have: - Extensive experience with Excel, particularly in creating and implementing advanced macros - Proficiency in developing complex algorithms - Skills in database integration with Excel - Strong problem-solving abilities

I'm in need of a skilled Excel expert to create a countdown timer for me. Key Requirements: - The timer should count down to a specific event. - It needs to update every second. - Upon reaching zero, it should trigger a sound. Ideal Skills: - Proficiency in Excel and its formulae. - Experience with creating interactive Excel sheets. - Ability to integrate sound triggers in Excel. Please ensure your proposal includes relevant examples of your work.

Job Description: We are seeking an experienced Excel Add-in Developer to help migrate our current VBA-based solution to a centralized, cloud-based system. The goal is to replace our local VBA code with a secure and maintainable Excel Add-in, allowing for easier deployment, updates, and IP protection. Key Responsibilities: Convert existing VBA macros into an Excel Add-in (JavaScript-based or COM Add-in). Move core business logic and data processing to a cloud server or API. Ensure the Add-in securely connects to the server to handle data processing tasks. Create a centralized deployment method for the add-in across multiple workstations (using Microsoft Admin Center or another deployment method). Integrate features like data uploads, auto categorization, and financial report generation wi...

I need an experienced developer to update my Windows XP software so it can run smoothly on Windows 10/11. The software is built on MS Access and needs to be able to import contacts from a .csv file (in a specific format). Key requirements: - Modify print settings to support Epson receipt printers. This includes: - Custom print layout adjustments - Printer driver updates - Update the custom print layout for receipt formatting Ideal candidates should have extensive experience with: - Software development and updates - MS Access - Windows OS (Windows XP, Windows 10, Windows 11) - Custom printer configuration - .csv file data imports Please note, the specific features required for Windows 10/11 compatibility have not yet been determined. Your expertise in identifying and implementing n...

I'm looking for a skilled professional in Excel VBA/Macro and PowerBI for data analysis and visualization tasks. The ideal freelancer should be able to: - Analyze complex datasets - Create insightful visualizations using PowerBI - Use Excel VBA/Macro for advanced data manipulation Please note that specific automation tasks in Excel have not been defined yet, but a high level of proficiency in Excel and experience with VBA/Macro is essential.

I need a bug fixed in my app, the same one reported by the Play Store platform, so I can continue publishing. It's something related to accessibility... I couldn't get it fixed because someone else destroyed the app. The bug is in the attached screenshot! ------------------------------------- Preciso que seja corrigido um erro no meu aplicativo, o mesmo informado pela plataforma da Play Store para poder continuar com a publicação. Se trata de algo relacionado com a acessibilidade... Não consegui corrigido, pois outra pessoa que destruiu o aplicativo. O erro está no print em anexo!

I'm seeking an Excel expert who can help me automate tasks primarily focused on data entry and cleanup. Your responsibilities will also include automating the generation of reports, executing complex calculations, and creating dashboards, buttons, and macros. Ideal Skills: - Proficient in Excel - Experience in automating data entry and cleanup - Ability to generate reports and perform complex calculations - Skills in creating dashboards, buttons, and macros Key Tasks: - Automate data entry and cleanup - Generate reports through automation - Execute complex calculations automatically - Create dashboards, buttons, and macros for ease of use Your primary focus will be on enhancing the efficiency of data entry and cleanup processes. If you have a keen understanding of Excel's auto...

I'm looking for an expert who can help me create a VBA automation in Autodesk Inventor for generating multiple variations of bevel gears. Key Requirements: - The automation needs to vary gear size and ratio as well as the tooth profile. - Ideally, the freelancer should have experience with gear design and can assist with setting up standards for these designs, as I currently do not have predefined templates or standards. Skills and Experience: - Proficient in Autodesk Inventor and VBA programming. - Prior experience in gear design and automation. - Ability to create efficient design solutions. - Familiarity with gear design standards and ability to help establish custom templates.

I'm looking for a skilled Excel VBE coder to create a custom function for me. This function will be for data retrieval, specifically from my email recipients. The goal is to automate the process of gathering data from my emails and integrating it into my Excel workbook. This project requires: - Proficiency in Visual Basic for Applications (VBA) - Experience with Excel and VBE - Ability to create custom functions - Familiarity with data retrieval processes - Understanding of how to interface with email data Please provide examples of similar projects you've completed in your bid.

I need a Microsoft Excel spreadsheet designed for managing customer information. Key Features: - Individual pages for each client - Easy data visualization - Sections for recording and displaying notes as separate entries Data Input: - I will be manually copying and pasting contact details and personal info from a software program into this main spreadsheet Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience with designing user-friendly spreadsheets - Attention to detail for accurate data representation - Ability to create sections for data visualization and note-taking

I need a VBA coding specialist to develop a script that generates a unique numeric string based on randomly generated data. Key Requirements: - Proficient in VBA - Experience in key generation - Able to deliver a script that generates a unique numeric string Ideal Skills: - Strong problem-solving abilities - Attention to detail - Excellent understanding of data randomization techniques

I need a VBA script created for the Saxo Bank trading platform that will automate my stock trading. The script should be capable of implementing market orders. You should use the OpenAPI add in provided by Saxo to develop the VBA code. You can setup a free demo account on your own to also test the code. It should be able to: * Retrieve the live prices of the stocks * Buy and sell options direct from the the Excel spreadsheet. * Retrieve all the associated information about the stock option For instance, last traded price, bid ask, and volume. Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Saxo Bank platform - Strong understanding of stock market trading - Expertise in creating automated trading systems - Knowledge of implementing market orders...

I am looking for a VBA expert who can help me create a key generator that produces alphanumeric keys. These keys will be used for automation purposes, specifically as triggers for an automated system. Key Requirements: - Experience with VBA and key generation - Ability to create alphanumeric keys - Understanding of automation systems Please only bid if you can meet these requirements. Thank you.

I'm looking for an Excel expert who can build a macro that automates data entry and retrieval for generating reports. The macro will only need to source data from internal Excel sheets. Key aspects of the project: - The macro should facilitate seamless data entry and retrieval to enhance efficiency in report generation. - A deep understanding of Excel and macro development is essential. - Experience working with internal Excel sheets is a plus. Skills required: - Advanced Excel skills - Macro development expertise - Experience with data entry and retrieval - Report generation skills

I am seeking a skilled Excel VBA programmer to improve the automated calculations functionality of my Excel VBA form. Key Requirements: - Enhance the automated calculations within the VBA form to improve overall functionality and efficiency. - Prior experience working with Excel VBA and understanding of coding is a must. - Ability to work independently and proactively suggest improvements is a plus.

Please share your resume with relevant experience. This is for a year contract. I'm looking for a proficient MS Access and VBA expert to assist me in designing a database focused on tracking various financial data. Key Responsibilities: - Database design and setup: Create a comprehensive database to track income and expenses, payroll and employee data, as well as sales and revenue. - VBA programming: Implement necessary VBA scripts to automate tasks and enhance database functionality. - Data analysis and reporting: Assist in analyzing the data and generating reports for financial review. Ideal Candidate: - Extensive experience with MS Access and VBA programming. - Proven track record in database design, particularly for financial tracking. - Strong skills in data analysis and report...

I need an experienced Excel VBA programmer to create a script that will automate the following tasks for Material Requirement Planning (MRP): - Inventory Management: The script should monitor and manage the quantities of raw materials in the inventory. - Order Scheduling: The script should help in scheduling orders based on the current inventory status and production schedules. The script will need to process data concerning: - Raw Material Quantities: This will involve tracking the quantities of raw materials available in the inventory. - Production Schedules: The script should be able to use data from our production schedules to help in order scheduling. Data Input: The data for the script will be coming from a database connection, so it should be capable of efficiently processing in...

I need an experienced Excel VBA programmer to create a script that will automate the following tasks for Material Requirement Planning (MRP): - Inventory Management: The script should monitor and manage the quantities of raw materials in the inventory. - Order Scheduling: The script should help in scheduling orders based on the current inventory status and production schedules. The script will need to process data concerning: - Raw Material Quantities: This will involve tracking the quantities of raw materials available in the inventory. - Production Schedules: The script should be able to use data from our production schedules to help in order scheduling. Data Input: The data for the script will be coming from a database connection, so it should be capable of efficiently processing in...

Armar el esquema y ejecutar una capacitación para que los colaboradores de una empresa puedan aprender a crear macros, desde el nivel básico a intermedio-avanzado.

LAVORO URGENTE!! Ho necessità di impostare un piccolo linguaggio VBA nel mio Excel. Ho un file Excel contenente 4 fogli principali. Vorrei che: 1. Queste informazioni che inserisco su questi fogli vengano automaticamente copiate nel foglio X nella sezione giusta. 2. Nel caso in cui queste informazioni verranno eliminate/modificate in questi 3 fogli, saranno modificate anche nel foglio X. 3. Rispettare i colori Cerco qualcuno che parli bene italiano. Grazie