Visual Basic Jobs

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.

We use excel for our timesheets and need to be able to enter two zip codes and calculate the distance/time between the two zip codes. We pay employees travel pay for anything outside of 60 mile radius of 46217. We would want this formula to subtract the initial 60 miles that the employee does not get paid. The excel sheets run inside office 365. Let me know your fixed price for this task :)

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

I am looking for an expert with experience in creating interactive charts in Microsoft Excel. I have a PDF which needs to be converted in Excel. The main thing is to create charts according to the data present. The selected freelancer will just have to create charts. There are about 25 pages. My budget is between 25-30 USD. I need it next 5-6 hours. Attention to detail is a must; so I am looking for someone who can help me create an accurate chart. Please start your bid with "Charts" so that I can see you have read the project details completely.

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

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 would like to replicate a long term forecast graph currently used in Excel, and transfer over to work management sheet. I need to allocate numbers of people required on a daily basis against a project list. Current excel format is attached. I would like to replicate on Monday.com. I can send a link to my Monday worksheet once known this is possible

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

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 programmer with expertise in Visual Basic for Applications (VBA) to create a system for cylinder heating. This code must be able to receive and process user input, as well as present data visually. The deliverable must showcase your proficiency with VBA and should be of the highest quality. If you feel that you are up to the task and possess the necessary qualifications, I welcome you to submit a bid.

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.