![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Vba Projects
Looking for freelance Vba jobs and project work? PeoplePerHour has you covered.
MS Access and Excel VBA developer
Hello, I am a European software developer specializing in custom software using MS Access and Excel VBA. I am looking for an experienced MS Access programmer to support various projects, primarily focusing on the development of customized MS Access applications. The ideal candidate should have proven knowledge in MS Access and SQL, along with strong skills in VBA programming. Good English communication is also required. If interested, please share your portfolio and experience. Best Regards Lutz
23 days ago16 proposalsRemoteReporting software in Access DB
I'm looking for a database professional, to help finish designing and coding my reporting software. Software has been started, and now I need to finish it. I have done a little coding, but I'm not fluent. Software needs to work on both 32 and 64 bit computers. Software is Access database for engine and storage. The software will need to be able to have both user input, and self calculate certain parameters. It will begin with the user login. If the user is an "Admin", they have access to the full software availability. If the user is NOT an "Admin", they have limited access to only certain features of the software. This will limit the "User" table to only be updated by a system admin, and not just anyone. The software I'm creating is for my job. It's to make my job a ton easier. The software must be able to print various reports, and automatically save the dB file, via upload to a given website, or FTP. This can be done once the majority of the software is functioning properly. I will attach all associated written files. I don't believe I need to start fresh, but am open to simple solutions. I've originally wrote this software in Excel VBA, but it's not secure. Any and all help appreciated.
16 days ago25 proposalsRemote
Past "Vba" Projects
VBA Script and VB ASP Web Code
I am looking to integrate the opensource Android SMS gateway found here (https://github.com/capcom6/android-sms-gateway) in to a project. Full documentation can be found on their git and API details I need someone who can write me a VB ASP procedure that will sit on an IIS server and: 1) can register a webhook with the SMS gateway software running on an Android phone somewhere on the local network. 2) receives SMS messages forwarded by the SMS gateway on that android phone, and store them in a table within an MS Access database. 3) Delete the webhook if we ever need to Key points: • All of the hardware involved will be on the local network. • Intention is to register the webhook once, then the server will run permanently in the background. • This is for an extension of existing project (moving from using 3rd party gateway to one on our own network) • Some long text messages will be received and need to be handled as such (trimming to the 500 character field length) • Errors need to be trapped and logged on the server as a log file. • The lighter and simpler the code, the better.. I'm looking for robust 24/7 operation that processes SMS messages quickly. • MS Access is currently a 2003 MDB but we're in the process of porting to a 2019 update, so something that works for both JET & ACE would be ideal. Anticipated workflow: {first time config} https://xxx/sms-start - this will prompt for a local host ID and the url of the Android SMS gateway, store this in a config on the web server, and will then use this information to register a web hook with the SMS Gateway server. Running this page and submitting it should overwrite the current config and prompt to create a new webhook on the SMS gateway. {day to day operation} https://xxx/sms-receive - When the Android server receives an SMS, it will forward it on to this address as a POST message. The server will then store the data in the MS Access database {if we ever stop using this server} https://xxx/sms-decommission - This page will use the information in the config file to delete the web-hook from the SMS gateway.
VBA/Macro Developer with Finance Modeling Experience
Create our own templates for every single financial model Create templates for the higher workflows or Analysis use cases that use the financial models (e.g M&A, LBO, Structured Finance, Risk, Portfolio Management, etc) Create templates for company profiles and other reports that get generated from the financial models Document and tag all fields and cells so that the information becomes part of the project Beacon glossary Create vba macros for every financial model Create vba macros for every other template (consider generating powerpoint presentations too) Document and test all the scripts and ensure they work flawlessly Create python scripts to extract and transform data from data sources or APIs in order to fill the financial models identified in Milestone 1. Create and test workflows from Data ingestion Data transformation Updating the financial models Generating amazing Excel Macros to present the models Generating the presentations if necessary Create Google App Scripts versions of the Macros (for Google sheets version) Investigate creating Excel Plugin for the templates
Excel VBA dynamic cell comments/notes
I need an expert in Excel VBA programming to allow cell comments/notes to be populated from other cells within a workbook. Please get in touch.
VBA coding to create functions in an Excel document
We have a working excel file that is used to within the company, we need to add some functionality to the existing code (already being used) to improve some parts of the document process. Using the latest version of Excel/VBA, I need to add some buttons/functions that add/remove items from drop down lists that are being call on in other parts of the document. By easily adding/removing items from one list, it adds/removes the option to select that item in another area of the documet. This update must work alongside the existing code already been developed. We dont want to recreate this again in a different version of excel... you must do it in the latest version.
Fix VBA Macro
Hi Mohammad Sadat Uddoula, I have a vba macro which has developed an error the macro is designed to merge a supplier file with the macro and make an Amazon friendly upload please see 2 files attached open stock updater Line 16 in stock updater - clear tables Then you will see import 211658 file click through each button until it fails at line 21 NOTE BUDGET IS MAXIMUM i have had quotes around this and below I am looking for best price Thank You Paul
opportunity
QuickBooks & Xero to Microsoft Excel Coding Expert Wanted
Are you an experienced coder with a knack for seamlessly integrating financial data from Xero and QuickBooks into Excel? We're seeking a skilled individual to develop a custom solution that will streamline the process of downloading financial information and populating predefined Excel templates. Key Responsibilities: 1. Develop a solution that allows users to select clients from Xero or QuickBooks directly within Microsoft Excel. 2. Enable users to choose specific types of reports such as Balance Sheet, Profit & Loss, Trial Balances, and more, all from within Excel. 3. Design a system that automatically feeds the selected data into predefined Excel worksheets, ensuring accuracy and efficiency. Requirements: 1. Proficiency in coding languages such as Python, VBA, or similar, with a focus on integrating APIs (Xero and QuickBooks). 2. Expertise in working with Microsoft Excel, including creating dynamic user interfaces and automating data entry processes. 3. Experience in developing custom solutions for financial data management and reporting.
pre-funded
I need some Excel VBA code correcting
Hi, I'm trying to finish a macro which will clear a selection of cell details, using ClearContents. I've got the selection of the cells written and runs fine, but keep returning an error on the second half of the macro - clearing contents. Error returning 1004 Code: Sub ClearContents() Dim rng As Range With Worksheets("Proforma") Set rng = Union(.Range("H13"), .Range("H14"), .Range("H15"), .Range("A23"), .Range("G23")) End With rng.Select rng.ClearContents End Sub Successful applicant will have VBA knowledge and able to provide the correct, working macro code. Thank you
pre-funded
Automate two Excel Files
I need to automate the following process in Excel using VBA. File 1 This is a reference file. See attached. Users can add/delete from this. File 2 File 2 is the Excel Master Template. In worksheet 1, there is a measure name in column A and a table with the 12 months of the year, split by quarter in columns B,C,D and E. The measures or tasks that people do in their day get manually input by TLs each month in the respective cell of the month against a measure line in cell B3, B4, C3, C4 and C13, C14 etc., TLs can manually update other cells that are not relevant to this exercise. In addition, there are 12 other tabs in this file, one for each month. Each of these tabs has its own tables with data in them that people manually enter. Format of these tables are the same for each month tab. These two files are saved in the same folder. TLs currently open File 2, go to worksheet 1 and manually insert the task or measure that they did each month. For example, they will update figures and text cell B3 for January and in C2 for February and so on. They can also update tasks that they hope to in future months. TLs update this same information again in the corresponding monthly tab. I want to automate this process using VBA. Pick the information from worksheet 1, say, cell B2, B3, B4 for January and copy the information into cell B33, B37, B28 etc., in the January tab. However, any other information that already exists in the monthly tabs in other cells that has been manually input should retain that information irrespective of the macro. They manually input the individual reference number and name in columns B1 and B2 of these monthly tabs. This needs to be automated using VBA using predictive text and populated to all the monthly tabs. In simple terms: Open file 2, pick reference data from 1 and populate cells in B1 and B2 in 12 monthly tabs. Then run VBA and take information from worksheet 1 and insert into specific cells in their coo corresponding monthly tab. Have a ‘Save As’ option defaulted to where File 2 was picked with the file name defaulted to the reference name picked. I use Office365 at work and my data is confidential. Therefore, I have created two dummy data files in Excel for you to work on. I have to replicate what you do in my work computer. Therefore, I must be able to re-type the VBA code at work. My suggestion is to create an Update tab for this as per File 2. Happy to look at alternatives. For someone with good VBA skills, this isn’t a difficult/time consuming job. So, if the VBA code need to change by a single line, I don't want you to charge me for an hours work! Timeline is roughly to have a demo version within three/four days and a permanent solution within one/two weeks max as I have to juggle any testing around my day job and possible yours. Thanks, Prasad.
opportunity
Modifications to Excel VBA Program
User requires enhancements to an Excel VBA program, String Match Correction, written for Excel 2010. The Program performs search, logic and comparison operations, metrics and scoring, and string manipulation between two Excel music data spreadsheets. The enhancements are required to accommodate a newly developed spreadsheet (Singles) and changes and additions to the field names of existing (AlbumCD and Tapes) spreadsheets. The task involves developing new VBA coding, integrating and modifying existing VBA coding to expand the automated spell checking, data comparison, metrics, scoring, and data editing features of the VBA Program’s functionality for the three Excel data spreadsheets, Tapes, AlbumCD, and Singles. Contact Buyer for spreadsheet and current UI views
Excel programming, table evaluation
We are looking for someone who can create a small macro or VBA script or something else for us to create an Excel table with evaluations from a text file. The data needs to be sorted automatically and simple calculations like multiplication and sums need to be done. The data is working hours that we have to evaluate every month. 1. The total monthly working hours per person should be calculated and be rounded down to a full hour. 2. 30 minutes should be subtracted from the daily working time. 3. The total monthly working hours should be multiplied by a fixed value. 4. Finally a fix amount must be subtracted.
Receive feed and do Data Manipulation
I wrote a VBA code and want that to be converted to a Web/mobile based app. The logic is outlined below but you can even look at my VBA code to get an idea. The basic requirements are 1.) To read, manipulate and update data 2.) Have a payment receiving options (paypal, credit card) for monthly, quarterly and yearly subscription based. 3.) Some required Graphs The received data will have minutes by minutes info of Date, Price, Open , High, Time Low, Time, % From this daily minutes rows daily high and low should be determined For example it needs to get real time forex feeds from yahoo finance website and add some logic to filter data and display it on my site with some graphs. Is that something you would be keen on? It is for student/personal use so can you let me know what your charge? The below website will show how to get data from yahoo finance and the other links will show how to display data https://www.youtube.com/watch?v=1O_BenficgE https://m.youtube.com/watch?v=kQo7nxxmwus https://marketmilk.babypips.com/market-movers https://market24hclock.com/Currencies/Daily-Highs-and-Lows The UI should be similar to the below for multiple currency heat-map https://moonance.com/ https://www.tradingview.com/markets/currencies/cross-rates-overview-heat-map/ When clicked Each currency should show something similar https://signalsbonanza.com/signals/ It should show a.) Daily Highs b.) Daily Lows c.) High - Low (its difference) d.) 1weeks High and Low e.) 1 months High and Low f.) 3 months High and Low g.) Direction - i.e Based on 1 week High it show show up or down directions i.e if last week high was 1 and today it is 1.3 then it is up direction (blue) but if today high is .8 then it show show down direction(red) h.1) Prediction- Based on history movement of forex High and Low it should approximately tell the next few days direction with Approx high and low range. (h.2) Testing - Use the historical and Economic calendar data, daiyfx IG report and see how good the next days prediction is happening and adjust the prediction to improve its accuracy. https://www.youtube.com/watch?v=1O_BenficgE https://www.dailyfx.com/sentiment-report https://www.investing.com/economic-calendar/ https://www.youtube.com/watch?v=n8iYQuaOTnU i.) Required graphs to be shown
Web scraping (URL) with VBA
Hello, I have an e-commerce website (not create by myself and no real database), I was able to extract main product information in CSV but I still need the URL 'page for each product to use for SEO and redirection. I would like a VBA macro using my website adress, using the product description, copy/paste them in google and extract the URL of the first product found (99% of chance to be mine). I can use VBA for some work but I cannot use it to be connected to google, internet... I can provide an excell sheet with website adress and product description, Column A : www.classic-red.fr Column B: product description in french, Column C: www.classic-red.com, Column D: product description in English. Expected, Column E: URL for french version, Column F: URL from english Version. Tell what you think and I am open to other ways as I am able to use it. regards regards, xavier
Excel Automation Expertise Needed
I'm looking for a highly skilled freelancer to assist me in automating tasks within Microsoft Excel. My goal is to efficiently manage and process basic data and return optimal results as well as a visual. related specifically to manufacturing foam blocks. Ideal Freelancer Skills: - Proficient in Excel VBA and macros - Experience with automation of data tasks - Knowledge of manufacturing industry a plus - Detail-oriented and analytical thinker Project Requirements: - Ensure accurate interpretation of manufacturing data - Generate solutions for rectangular and custom-shaped blocks processing Specific request: We are a foam manufacturing company and we cut foam to size from very large blocks on saws. We typically calculate the size to cut manually on the factory floor using the hard copy sheets (see attached). I would like to have an excel sheet to essentially mimic these sheets where you input the 3 sizes of the foam we'd like to cut and then the results will show the factory floor how to cut the block as well as showing a visual to the factory workers on how to actually make the cuts- basically creating these sheets in excel. Please let me know your thoughts on cost - this is likely more of a presentation basis than programming, but we will need some formulas and graphics to calculate and show the best way to cut the block and best way to to "yield" pieces from the block BLOCK SIZE IS ALWAYS 40 X 80 X 108 INCHES. There will likely be a couple iterations of this to get to completion.
I have a spreadsheet that requires VBA automation
I have a spreadsheet that requires automation. Can you help? I have MS Excel document where it presently shows tabs for: the following types of items: headware, miscellaneous, parkas, shirts, DEU tunics, FTU tunics, DEU pants, FTU pants, DEU boots, FTU boots On each tab, the headers are: inventory ID (its a number, mostly used for me to just reorder)., Name (title of the object for ordering), description (description of item), unit price (its based on a point system, not currency, and is presently ), quantity in stock, reorder level, and quantity to reorder. When I update this sheet, I want to scream. There is too many items (809 to be exact )and simply removing an item from each section as required, is extremely time consuming. I was thinking of making the sheet have another tab where you select "issue" or "return", type in the size and then it will auto removes or add it to each items count. I would also need another tab bulk new inventory to be added in (like 25 t-shirts, size small). But I have no idea how to do so.
Excel VBA Expert needed to create Macro
I'm looking for someone who has a very strong command of Excel; including VBA, Power Automate, and Power Query to support the work of my company's Information & Data Teams. The initial project is focused on writing a VBA Tool which will convert a matrix (manual raw data) into a column vector for use in another tool. The input and output formats are specified and we need a tool which automatically transforms the data.
Looking for a Python Developer for Stock Market Analysis
Looking for a developer who have experience in Indian Stock Market and can get live and historical data by using python (non API or API method to get data). Knowledge of python, excel, vba.
opportunity
VBA Expert - PDF Retrieval
Hi I need to retrieve print ready (large) pdfs from a local server and place them into a hot folder for printing. I would like to use an excel spreadsheet to dictate which pdfs are retrieved. Ideally the number of sheets required to be printed per pdf are also input at this time into the print server. Thanks Andy
opportunity
Developing a Container system in Windows on Cloud
I want to develop a container system in Windows for using VBA tools. I want to give clients a link where they can log in and run the VBA based tool. The link should be controlled by us and we should be in a position to see their activities.