ビジュアルベーシック Jobs

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:01")) Shell ...

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The ideal candidate needs to have a keen...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration • Laying ...

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

I have a large set of data in Excel that requires thorough cleaning and organizing. - Tasks include: - Removing duplicates - Standardizing data formats - Data validation and verification - Identifying and correcting errors - Sorting and categorizing data Ideal Skills: - Proficiency in Excel or similar data management tools - Experience with data cleaning and organization - Strong attention to detail and accuracy The volume of data is significant, so I'm looking for someone who can work efficiently without compromising the quality of the work.

I urgently require an intermediate Visual Basic developer to enhance an existing system, focusing on the creation of user interfaces and the development of our database applications. The main tasks to be undertaken would include: - Enhancing UI for optimal user interaction - Optimizing our database application operations The ideal candidate would have proven experience in Visual Basic portal enhancements, an understanding of database structures and interfaces, and a knack for user-centric design. Your ability to perform automation of repetitive tasks would give you an upper hand. If you believe you could make a significant contribution to my project, please do place your bid.

I am looking for a freelancer who can help me sign my restobar business on Grab Food app by creating a menu template on MS Excel. The menu is currently available as a picture and needs to be converted into a simple spreadsheet format that meets Grab's requirements. Key Requirements: - Convert picture based menu into an Excel sheet for Grab Food app - Keep the menu descriptions short and simple - No need for special formatting or design elements, just plain text Ideal Skills: - Proficiency in MS Excel - Accurate data entry skills - Familiarity with food service industry or Grab Food app would be a plus

I'm seeking a detail-oriented freelancer for a text data entry project. The primary task is to input text data into a spreadsheet accurately. Additionally, these data must undergo sorting for seamless navigation and understanding. Key Responsibilities: - Text data entry into a spreadsheet - Implement effective sorting to organise the data Ideal Skills: - Proficient in Microsoft Excel - Strong attention to detail - Experience in data sorting techniques - Excellent typing skills The ideal candidate will possess a solid knowledge of Excel functionalities and data sorting. I look forward to connecting with passionate individuals eager to take on this task.

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for convenient PDF to Excel conversion.

I need a professional adept at advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpatient pharmacies, which need coverage. Key functionalities of the required Excel Spreadsheet: 1. Worker Availability: - The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanc...

I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.

I'm in need of an Excel Calculation Expert. I have data spreadsheets that need to do the calculations using Excel Your primary task will be to: - I've dataset (excel file), that needs to do the calculation using excel - Once it done then you need to write report as per following requirement Deadline: 10 hours or less

I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folde...

I'm looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and reliable,...

Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your proposals!

I'm looking for a freelancer who can create a comprehensive, user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple businesses. The system should serve as a plug a...

More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.

I'm in need of a desktop software that can analyze a specific type of data within a PDF table. The software should: - Read and extract data from a PDF table - Compare this data against another table - Identify and save matching data in the form of an Excel file. The tables in question will contain numerical data only. Ideal Skills and Experience: - Proficiency in developing software for Windows - Experience with data extraction from PDFs - Strong capabilities in data comparison and analysis - Knowledge in Excel formatting - Understanding of numerical data handling.

Hello, I've an anticheat made in C# with those packages: - BouncyCastle.NetCore.2.2.1 - EasyHook.2.7.7097 I need to have it 100% finished and integrate it into my game in dll form which is made in visual basic 6.0. Or transform the c# code into another language.

Preciso de um profissional que saiba desenvolver processos automação RPA, que integra site e arquivos excel em processos rotineiros.

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrumental in a...

I'm looking for a skilled developer who can assist in building a desktop application for Windows using Visual Studio 2019. The main task of this project is to create a robust file management system within the desktop application. Key Requirements: - Proficiency in Visual Studio 2019 - Strong experience in desktop application development - Expertise in file management systems Prior experience in building similar systems will be a huge plus. Please submit your proposal with a brief overview of your relevant experience and a rough estimate of the time you'd need to dedicate to the project.

I'm looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and reliable,...

I'm seeking a proficient scriptwriter to design an Airtable script that can effectively combine data from a single table that consists of parent-child relationships. The main task for this script will be to focus on combining data from the parent-child and combining it onto 1 row each. Specifically, the required updates will involve: - Combining Parent and all children data onto same row - Taking DOB field and splitting into a Month field and a Year field - The end result should be a base where I can upload a new CSV and it outputs the desired result into a new table that I can download a csv from The ideal candidate for this role is someone well-versed with airtable scripting and data management, specifically having a strong knowledge of number fields. Your experience with manipu...

I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Excel is highly beneficial.

I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.

I'm seeking a skilled professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can ...

Tengo un software de facturación al que se le pueden importar facturas en lote subiendo un Excel con un formato concreto de filas y columnas para que sea capaz de reconocerlo y generar las facturas de forma correcta. Necesito poder hacer esto de forma automática, es decir, teniendo un archivo de origen xls en un formato, poder extraer los datos para montar otro archivo xls con el formato que necesita el software de facturación para leerlo correctamente.

I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.

I am seeking a proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have example files I can share which can form basis of design. Ideal candidates will have experience ...

My bakery is now in it's fourth generation of ownership. My Dad started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database or commence anew based on existing requirements. This database is intended for exclusive us...

I need a deft hand at Google Sheets, capable of mastering complex spreadsheet formatting and implementing powerful formulas. Your role includes: - Applying conditional formatting to enhance data visibility - Using lookup and reference functions to optimise data organisation and retrieval Your skill sets should ideally include advanced understanding of Google Sheets, proficiency in the application of lookup and reference functions along with a design-eye for effective conditional formatting.

As a client seeking to improve my understanding of excel, I would like a skilled instructor to guide me through the basics of formulas and functions, data analysis and reporting, as well as formatting and conditional formatting in Excel. Although I don't have a specific completion time, expediency is appreciated. Skills and experiences that would be ideal for this job: - Advanced Knowledge of Excel - Excellent Teaching Skills - Flexibility to cater to learning pace No preference was selected for the type of learning medium, so offering a blend of online videos, live training sessions, and written instructions could be beneficial to cover all bases.

I'm looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and reliable,...

Estamos buscando un programador que nos ayude a desarrollar la conexión desde un sistema contable desarrollado en Visual Basic 6 (VB6) a proveedores de Facturación Electrónica de ECUADOR a través de APIs diseñadas como servicio web REST. Todos las operaciones son en formato JSON, incluso los errores. Ejemplo de api: De preferencia desarrolladores con experiencia en Facturación Electrónica de Ecuador y que se comuniquen en español.

I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, derived from the 2048 total objec...

I'm experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's discuss a potential solution ASAP. Please include your past experiences in de...

Necesito resolver esta tarea de Excel para un empleo, no he podido tener tiempo para realizarlo. Dentro del Archivo está el link para acceder al documento de Excel en el que hay que trabajar.

I'm in need of a developer skilled in VB.NET isometric view for a collage project. The project focuses on product design, more specifically, fastidious design of industrial equipment. Key points to include are: - Implementing isometric view within VB.NET framework - Use of isometric view for detailed visualisation of PIPING designs - Must incorporate the theme of ISO study in the collage A deep understanding of VB.NET and experience in PIPING ISOMETRIC.

crear un instalador con cual pueda instalar selenium vba a computadoras de 32, 64 bits (debera poner el diriver chrome actualizado segun la arquitectura de la computadora), con sus driver Chrome actualizado segun la última version del navegador. - Agregar la librería de referencia de selenium vba a excel Todo esto de manera automática, sin presentar alguna interaccion por parte del usuario extra, aparte de la tipica instalacion selenium: Chromedriver:

I need a Excel macro that can scrape data from a https://www.ebay.com. The Excel macro should be set to run whenever want to update the data in my spreadsheet. Excel should have Product Name Product UPC Product SKU It will then go to find that Product I want excel macro - list with the number of watches/shoes for that item

I'm having trouble with a runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models into Excel...

I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization tec...

I'm looking to develop a Microsoft Access database to manage and print cage cards for laboratory mice from an existing Excel file. The Excel includes columns like Cage ID, Strain, Sex, Age, Mouse ID, and Notes, among others. Each card should group mice by their Cage ID and include relevant details such as Strain, Mouse ID, Sex, and Requirements:Database Development: Create a database from the Excel Card Design: Design printable cards with the listed Functionality: Enable direct printing from Interface: Simple UI for selecting and printing cage provide a quote and timeline for this project, along with any similar work you've done.

As a developer, I need someone to assist me in uploading my custom-made Excel Add-in to the Microsoft App Store. This involves making the Add-in available in Microsoft Office Excel's Add-ins. Key responsibilities include: - Uploading the Add-in to the Microsoft App Store: The candidate is expected to have experience with the Microsoft App Store's guidelines and processes. This includes preparing the necessary documentation, setting up the listing, and ensuring compliance with the platform's rules. - Making the Add-in available in Microsoft Office Excel: The candidate should be familiar with the process of making Add-ins available and accessible within Excel. This involves configuring the Add-in to be easily discoverable by users and ensuring a seamless integration into the ...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrumental in a...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrumental in a...

I am in urgent need of a professional well versed with Excel Operations to help typify a vast array of data into an Excel sheet. The data includes: - Text - Dates - Numbers A key part of this project involves adhering to specific formatting requirements, which include: - The application of currency formatting - Utilizing bold or italic text when necessary - Highlighting certain cells This is a time-sensitive project that requires immediate attention, therefore the ideal candidate should be able to commence work ASAP. Your experience with Excel, data entry, and attention to detail will be highly beneficial in executing this project.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrumental in a...