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

I need it to where when someone inputs an item number, the corresponding product number will auto-populate

My pivot table data needs fixing. it's only showing 2 of the shifts when there are 3 different ones in the data range. Also I want the time formatting fixed in the chart to show HH:MM Am/PM if possible. Also I need help with general polish of the data importing macro. The file has a database connection on a VM so team viewer or any desk would be required for testing

I need to deploy a simple form that allows a user to enter a designated prefix and select a two-letter suffix (from a dropdown list of country codes) and then through a script, generate random numbers (not from a database although I have an excel worksheet that will let me create 1500 random numbers at a time) and populate eight labels per sheet with two logos inside each barcoded label field plus the bar code itself and the human readable number - and surrounding fixed text in the margins of Avery label sheet Nr. 64501. The random number to be generated for each uniquely numbered bar code label needs to follow a designated algorithm noted in the file I've attached Once the script generates the numbers (no need to have a database of pre-prepared numbers - they should be created new ...

We are using access to capture data and then use a form to print out the data and present it to our customers. We would like to update our access system and freshen up the form so it looks more in-brand and also we would like to easily add individual images to the form.

I have a VB Script application that no longer ends. It basically takes a daily downloaded CSV file, dumps it into MySQL and then quickly updates a database with the values from the dumped CSV. This file use to have 400,000 entries and ran fine. Now that it is 600,000+ it doesn't stop unless I end it.

I'm looking for an experienced freelancer to design a custom software or spreadsheet for our Profit and Loss, sales and management meetings. The project timeline is 1 to 2 month, with existing plans needing some alterations as opposed to a new design from scratch. It should be built in Google Sheets, forms or something else. for maximum efficacy and convenience. We have 2 software which will feed us information in cvs format or api. 1st is a accounting software will will feel all p & L info we need all sales , profit and lose. And expenses into a graph format and week, months , quarter, half yearly and yearly formate for every thing for comparison. Sales and job tickets software which will give us feed for every day sales and jobs and staff info, same format in graph 3rd is m...

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

Hi, I have created a macro in i am unable to schedule the flow through power automate browser version. The flow that I require is: at a particular time excel file is opened, the macro is ran the macro execution is complete, the excel is closed . (please note:cannot use the power automate desktop flow for the above)

I have details and files.i need excel VBA is simple make within vba code. deadline Tomorrow max budget 10-30

HELLO, We need to do visualisation of our future project. 3 houses from outside and inside. Plus shot video from above like complete

retreiving data from the internet and populate the relative field in ana excel sheet the data are financial data, ratios and information rewgarding companies and stocks. The excel sheet has to be like a one - stop page where the same information are shown of any ticker that will be selected

I have already developed an excel sheet with real-time data. But I want to develop that excel sheet up to the next level by putting some formulas and make it work like automated work sheet

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

Inventory and sales purchase sheet which automatically allocates the details into each client's sheet

I'm looking for an experienced Excel developer to help create an exciting new project. This project is an Excel based numerology system that will be used on a desktop platform. I need help adding multiple pages with specific features such as spreadsheet automation, data filtering and pivot table creation. The end result should be an efficient, user-friendly application to aid individuals in unlocking the power of numerology. I'm looking for professionals who have experience in Excel development and can provide me with the highest quality project. The ideal candidate would understand the complexity of this project and have the necessary skillset to turn my vision into reality. If you have the expertise and are excited to work on an interesting project like this, then I'd lo...

Hi, We have Power Point plugin developed into VB.Net VSTO We need some enhancement on it kindly ready the below changes. 1 - When we are clicking the search button it is fetching the JSON from Image website. 2 - Now we have to show the fetched image link into pan (Pan is already showing in plugin). 3 - also need to some UI design, it should look fancy. Note : Plugin should be look like attached SS

I want editor for you tube fast

*Job Description: Menginput dan memfilter data listing property *Skills: -Familiar dengan google maps -Mahir menggunakan excel dan spreadsheet -Komunikatif *Kualifikasi: -Minimal pendidikan D3 -Semua jurusan

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 some help for my excel file

Hi, I am working as Operation Head in a small machinery company. I would like to prepare a MS access based apps for managing my company operation. we have 6 machines are working my company, each machines are getting different type of jobs from different customers. I have to get following Datas to be entered to system and get some reports also. 1. Data entry of Jobs 2. Delivery status 3. Pending works of work to machines hours spend for work & employees

I own horses and want to monitor their progress …spelling …. Training…..racing result at different ages.. Want a database look for info entry. Something like horse name…DOB….Sire name ……Dam name….Sire and Dam Pedigree…race grade….distance…track…..track condition....weather….Finishing position….Race time…..First 3 horses to finish. Is that possible I can do in excel 365 iPad but not the fancy input stuff. Thanks

Need a simple Access UI to connect to the back end sql server databases using 1) ADO Connection 2) Ability to Save the connections in the Local Database 3) Data Select and DML operations 4) Pass Through Queries Execution

Database (via Excel) of the documentation related to our customers (Enquiry, maintenance, monitoring, generating reports, ...) here are some additional details and considerations but not all : 1- Main Sheet which gathering all data together This sheet should serve as the central hub for all of your customer documentation include all relevant details for each document, such as the customer name and number, document code, name, description, date, amount, and expiry date, status of the document (e.g., accepted, pending, rejected), the name of the employee who processed the document, and any notes or comments that are relevant. 2- Customer Sheet: This sheet should contain all of the details related to our customers, including their name, address, customer number, relationship manager, and s...

One of our clients has many Access 2003 databases which they have adjusted many times. They would like to make some changes to these 2003 Mdbs and after all of their 2003 Mdbs have been adjusted they would like to upgrade all of their difference Access database to Access 2007.

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 want to login into website and extract some info and send it to whatsapp automatically

I need to have a VB program to to simplify interacting with site The Requirement: The application consists of a dashboard and four modules to build a simple interface to buy, sell, check price and check wallet to interact with Binance site GetPrice() SellCrypto() BuyCrypto() GetWallet() - MS Visual Basic program - Native Programing - Delivering Source Code - account credentials will be provided when project testing started - The required dashboard is attached as Ms Access program - Application database should be ms Access

I am looking to create a proforma Excel spreadsheet which will contain sales figures, with just one single worksheet required. This spreadsheet will need to be updated regularly, and I'm looking for a freelancer to help create it. The spreadsheet needs to be tailored to my data, so experience in creating an Excel spreadsheet is a must. I'm looking for a freelancer who can help create an effective and efficient spreadsheet so that my sales figures can be analysed quickly and effectively.

Dear coder, I have a little project in mind, but I am willing to pay good money if you can deliver. I need a visual representation of a specific options chain beeing bought and sold. The data is provided via the ibkr (interactive broker) api. For example: I want to analyze the spx option chain. The current strike price of spx is 4000, collect the data of the nearest strikes (100pts, 10 points steps, in this case 4000, 4010, 4020; 3990, 3980.. and so on). Now the cumulative amount of buying and selling of each strike as well as an combined set needs to be plotted on a simple diagram (x: time, y: cumulative amount). The diagrams need to be potting live, IBKR allows 50 refreshes per minute. If you are seriously interested in this project do not hesitate and contact me! sincerely...

I have 200 excel files.. where I want duplicate data to be merged together.. but they have categories which are unique .. i want them to be comma separated.. if its possible please check the attached file and do let me know..

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.

I have some excel base assignment, for which solution videos to be made (each video for 3 to 5 mints)

I'm looking to create an Excel spreadsheet that will streamline my cryptocurrency arbitrage trading. The spreadsheet will be connected to the Live API's of crypto exchanges, along with tracking data from multiple exchanges (approx. 10 exchanges initially). Specifically, the spreadsheet will focus on tracking the price of different cryptocurrencies. In addition, the spreadsheet will feature basic formula calculations. Ultimately, this spreadsheet will provide me the opportunity to more closely track the cryptocurrency market which will allow me to make more informed and efficient trades. It may need the buy and sell price added somehow to the spreadsheet also of crypto token pairs to become more accurate however this can be discussed during the creation of the spreadsheet. The m...

I am having a old client server project that was developed in Visual Basic 6. It connects to windows server via winsock to receive live OHCL quotes . It uses asp.net to receive historical data from server stored in Ms sql server. The tables of the sql server were deleted . We need help to run the project and make it working. No new code to be done. Only the old running condition to be established. Sample code of the form having winsock and historical data calling is attached along with the aspx file that used to fetch the historical data from server

You have one sheet stock symbol graph. I asked for separate tab or many tabs. When you add stock new tab of monthly, yearly 1,5,10 years of data. This is the error I am facing when I click on get data server link failed A1 cell have symbol which you desire to see data down cell have start and end date down cell have daily, weekly and monthly data adjestment and code is source with these cells now issue is when first time to making code it shows the data in front of you but then you change the symbol or date it tells connection failed to server main page similar page I added.

I am looking for someone to customize an excel spreadsheet for my business. I need it to include sales data, and I would like to add in some Excel formulas to make it easier to read and analyze. I do not need any calculations, however, I might consider adding in some graphs and charts with conditional formatting on them if it helps. All in all, I need the spreadsheet to be customized for the type of data I'm working with and formatted for easy readability. Can you help me with this?

I am looking for an experienced Excel Expert who can understand and transfer data from one format to another. The data set is large, with more than 10 columns. The format of the data can be either tabular or non-tabular. I also need the data to be partially analyzed and interpreted. The successful freelancer must have extensive experience in making sense of large data sets, be detail oriented and have advanced Excel skills. We have a software where customers are bringing in Data from multiple sources but they want to import the data into our System. We have data imports via spreadsheet for Customer, Job Sites, Work Orders and Units. I would like someone who is experienced in excel, who can understand the data that is provided by the customer and is able to translate that data accurately...

We have an old Visual Basic 6 code that used to work some years ago. The project is a client server model. We need someone who can read the code of (Mainly 2 forms of the project ) and explain us what are the function and how the code works. Need an Indian developer only ready to explain over skype or phone via remote access. We have pay at an hourly rate . Sample file attached.

As a client I am in need of a Freelancer who can assist me with editing an existing GTS Excel Spreadsheet. I do not have an existing spreadsheet that needs to be updated nor do I need any new formulas or calculations to be included in the spreadsheet. Additionally, I do not need the spreadsheet to be integrated with other applications. I am simply looking for someone who can take my existing GTS spreadsheet and make changes and edits based on my requirements.

Καλησπέρα. Έχουμε κάποιο Χρηματιστηριακό Πρόγραμμα το οποίο ως πρωτόκολλο επικοινωνίας στηρίζεται στον Athex Gateway (ODL API) και με βάση οδηγίας από το Χρηματιστήριο θα πρέπε&...

I NEED TO CREATE A REGISTRATION FORM, TO CREATE BOMS USING A DATABASE.

The sheet that we have is working well except there are 2 things that keep coming up repeatedly we would like you to go into the trust settings so you change it that it trusts all the macros so it doesn't keep having the pop menu/box each time we open the sheet. The other issue is although we have cells locked we get the occasionally get #REF or #NAME?. The password to unlock the excel sheets is botox.

I want to connect two of the cells between 2 Excel sheets, as well update both, if data has been entered in either of two cells. Cell A4 in Sheet 1. Cell B7 in Sheet 2. Suppose, if 100 is entered in cell A4 in Sheet 1, then B7 in Sheet 2 should be updated with 100. And if 80 is in cell B7 in Sheet 2, then cell A4 in sheet 1 should be 80 also. Using Microsoft 365 Need to solution to this and the ability to replicate this myself as we need to create more sheets and link it with the summary sheet and for obvious reasons we cannot approach the developer everytime we make a new sheet.

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