Visual Basic pentru aplicaţii Jobs

I am in need of a VBA developer with webscraping skills to create a VBA macro for a project. The VBA developer should have intermediate level expertise and be proficient in MS Excel VBA. The project involves building an automated VBA macro that can scrape data from the web, extract it and store it in a suitable format. The macro should be able to pull data from multiple webpages and process them efficiently. Additionally, the macro should also be able to parse HTML documents, identify useful data and process them accordingly. The desired outcome is a program that can be used to robustly scrape data from the web in an automated way, and store it in the desired format. The project requires the developer to apply their skills to create a customised product with an adequate user interface ...

We are seeking a highly skilled and motivated individual to develop a protection system for our Excel tool to be distributed on licence agreement. The successful candidate will have sound knowledge of Excel features, VBA, and will be a problem solver in the IT environment. Responsibilities: • Develop a code to identify the computer where the Excel tool will be used and obtain the PC's serial number with the computer owner's agreement. • Create a VBA code that prevent tabs to be viewed without activation key. • Create or source a key creation tool to unlock the Excel document once pc’s serial number matches that obtained in step 1. • Write a macro or VBA into the Excel document that will validate the serial number on the computer trying to open the docume...

I need an VBA developer need to create a macro from Pivot table to put Vlook Lookup to10 different excel sheets in a single work book and need to upload the macro and input file in the same share point. I need to run the macro in share point as well. My budget is 600 INR so quote on this limit.

I need an excel Gantt chart that updates from a table that has recurring tasks. I need the chart to be a visual aid to interpret the data from the table. I record dates of start and finish in the table via App sheet and then. Ideally if it could also overlay a forecast i create too. its for management of a grazing cattle farm, there will be 16 paddocks ( which would be like tasks on a normal gantt chart) There is also approximately 7 mobs of cattle. attached is a copy of the data and a rough layout of the gantt chart. The different colours on the chart represent different mobs of cattle. The numbers on the chart are to help me analize how many days since the cattle left the paddock. The date out column in the data needs to automatically update to represent when that mob moves to a new padd...

Hello! I am looking for someone to help me with an existing VBA script for Excel and Outlook. Specifically, I need help completing an automated script for both programs. I currently have a partially completed script, so the work isn't from the ground up and much of the foundation is already in place. I'm looking for the right freelancer to take on this task and help me complete the script, ensuring that it works as intended. If this sound like the project you're interested in, please reach out - I'm excited to hear from you! If you can communicate in Chinese, it will be an added bonus. Thanks!

I need vba expert who will design my excl font page as my sample with data scraping from yahoo

Open my excel spreadsheet and picture. Example - 1. Mark “ B2 ” DIA as 25 but “PAP” is 32 x 25 ELB (THAT IS WRONG TYPING ) When I type incorrectly in the pap area, the "ELB" must appear in red. (like this “ 32 x 25 ELB “) Pipe DIA and ELB must have the same first letter; if the letter is not the same, it needs to be changed to red. (see my picture) Example - 2. Mark "B8" has a diameter of 25 but "PAP" has a size of 25 x 25 x 32 (WRONG TYPING ) When I type incorrectly in the pap area, "BULL TEE" should appear in red.. (like this “ 25 x 25 x 32 “) Pipe DIA and Bull Tee's Last Letter must be equal; if not, it must be red. (see my picture Can you do all rows in excel vba

I am looking for a VBA Expert who can help me with a project that requires coding macros. I have a specific goal in mind that needs to be achieved and I would need the expert to work on it for 1-3 days. The right candidate should be good at Excel and have experience with dashboard generation. The below is the sample project requirement. You will be interviewed based on your performance to provide resolution to below illustration. Whomsoever- want to apply create the macro in attached file ''compare data" two data and bring difference in other tab. It should be professional and can use dashboard or chart..

I am looking for an expert in VBA coding and Excel that can help me automate a project. In particular, I am looking for someone to help me code a project that has an intermediate level of complexity. I do have a rough idea of what I would like to achieve but I am open to suggestions to make the project as efficient and effective as possible. Prior experience with Macros, Custom Formulas, and VBA automation is required. Please complete the attached sample project for further interviewing process. To compare two data in which - The SSID is unique in both table and you need to generate difference of result in separate tab. You can create dashboard also of it to make more interactive.

I am looking for a freelancer to create a VBA code to create charts and do complex math calculations. This project is for personal use, and I require an advanced level of complexity for the code. The project must be done in VBA and no other programming language. If you think you are the right person for this job, I'd love for you to apply.

first page complete with the ability to add stocks. I provide the template. You have one sheet stock symbol graph. I asked for a separate tab or many tabs. When you add a stock new tab of monthly, yearly 1,5,10 years of data. Look at my example file attached.

Skills Required: - VBA - SQL - Any automation skills preferred! (python, google apps scripts) Deliverables: - develop an excel reporting solution that connects to our data warehouse and updates a set of charts and tables that we will work together to design. - we need to be able to automatically generate copies of this report for delivery to multiple clients, where the only difference is the data table connection (within the same database). Scope: - initially, we will develop 1-2 reports for a trial period. following that period we have up to ~30 excel templates that will need development, and may have additional opportunities for adjacent automation development work. When applying: If possible, please include an example excel report that you have developed in VBA that would allow for r...

i need multi system on excel VBA code adjust

I'm looking for a software solution for my project. The scope of the project is small, so I'm looking for something relatively easy to implement. I'm not sure if it should have customization options or not, but it should be able to handle the task. The project is to create a multi-system and the result should be a coloring of the cells and line alignment that looks different. I'm looking for a software solution that is either cloud-based, on-premise or a hybrid. It needs to have reliable features and should be easy to use. The pricing should be within my budget as well. I look forward to working with you to create the perfect solution for my needs. Must be an expert on EXCEL VBA

I need to send 250 meetings invites to different external users with different attachments . Need vba script so as to automatically send invites via excel from outlook .

I am looking for an experienced freelancer to build an Google Sheet based on Excel and macro. Script must save the google sheet with a new name and export a .csv file. File attach is excel Experience with Excel, macros, and Google Sheets will be essential for this project. The successful freelancer should have skills in Excel, VBA Macros, and working with Google Sheets. They should have experience converting data from an Excel format to a Google Sheets format, and be able to provide a demonstrated history of successful conversion projects.