Find Jobs
Hire Freelancers

Excel Structured Report from XML File through Data Model and VBA script

£250-750 GBP

Cancelled
Posted almost 6 years ago

£250-750 GBP

Paid on delivery
STEP 1: Import and sort 2 XML and 2 CSV files into 1 structured report split over 2 cost centres (1 XML and CSV for each cost centre) XML Data will change daily (will have the same file name and location) VBA code written to pull in the XML file, refresh all data and export the report saved as .xls STEP 2: Use the saved daily reports to automate the production of both a weekly overview and annual running total of specified data.
Project ID: 17052802

About the project

35 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel macro enabled project very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
£555 GBP in 10 days
4.7 (19 reviews)
5.3
5.3
35 freelancers are bidding on average £406 GBP for this job
User Avatar
Hello, I can help with you in your project Excel Structured Report from XML File through Data Model and VBA script. I have more than 5 years of experience in Excel, Excel VBA. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
£500 GBP in 10 days
4.9 (347 reviews)
8.0
8.0
User Avatar
Dear Client I am an experienced VBA programmer and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I have reviewed your project and ready to proceed to it. Will be waiting for your response to discuss the further details of the project. Warm Regards Z
£750 GBP in 7 days
4.9 (156 reviews)
7.9
7.9
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please send me a message so that we can discuss more.
£500 GBP in 5 days
4.9 (393 reviews)
7.6
7.6
User Avatar
Hi there,I am Miljan,VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
£555 GBP in 10 days
4.9 (131 reviews)
7.4
7.4
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
£400 GBP in 5 days
5.0 (262 reviews)
7.0
7.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
£500 GBP in 4 days
5.0 (127 reviews)
6.5
6.5
User Avatar
Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chrys
£450 GBP in 5 days
4.9 (69 reviews)
6.5
6.5
User Avatar
I am a professional Freelancer. I would like to work on this project. I have done a lot of similar project of this. Feel free to let me know if you would like to look a sample
£250 GBP in 5 days
4.8 (140 reviews)
6.6
6.6
User Avatar
Dear Employer, I'm ready to work on xml file to excel structured project. Relevant Skills Excel, VBA, XML Milestones 206 GBP - project requirements done and delivered 206 GBP - last milestone after full checking and testing I can achieve the results that you are asking for.
£413 GBP in 10 days
5.0 (119 reviews)
6.6
6.6
User Avatar
- Have good expertise in Excel automations. - Can import both the XML and CSV files and have them sorted split across the Cost Centres - Also have the reports based on the imported XML and CSV files. - Will provide button clicks to import the XML and CSV and also for report generation for the Production on the Weekly Overview and Annual total. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl Sample HighComplex Projects using Macros: (via Freelancer) - Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. +...
£250 GBP in 4 days
4.7 (49 reviews)
6.0
6.0
User Avatar
Hello. I have great experience with xml, csv data processing using VBA. I can make the best solution for you!
£400 GBP in 10 days
5.0 (42 reviews)
5.5
5.5
User Avatar
Hi, I am Nallakumar. I have more than 11 years of experience in Excel Automation. I need the sample, xml, csv files and the templates of the output data required from your end. I can give you a first version for testing inn 48 hours after awarding the work. Thanks, Nalla
£400 GBP in 3 days
5.0 (7 reviews)
5.2
5.2
User Avatar
Hi! I'm interesting your project very well. I am good at Excel and I'm a good Algorithmer. And also I have many experience and good skill about VBA development. Let's go ahead with me
£250 GBP in 10 days
5.0 (6 reviews)
4.4
4.4
User Avatar
Hi, Please provide more details. I have completed very similar projects at the past. I need to see the files and more details. Best Regards, Serdar Yalcin
£250 GBP in 10 days
5.0 (21 reviews)
4.4
4.4
User Avatar
Hello I am a highly skilled data processor ,i can implement the script you described in java i've done this several times before could you please clarify more the project over chat Thank you in advance
£250 GBP in 10 days
4.7 (26 reviews)
4.8
4.8
User Avatar
Hey there, From the sounds of it, you need someone to create ETL process with the Excel file. You need an Excel expert who can write optimized formulas and create VBA to get what you want. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfully completed many Excel projects for random clients. Always on time and budget. I hope to get your answer. Best regards, Rafel
£250 GBP in 10 days
4.9 (16 reviews)
4.5
4.5
User Avatar
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script, PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook, PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex ,Costco, etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details .Thank you :)
£277 GBP in 5 days
5.0 (49 reviews)
4.6
4.6
User Avatar
Hi there! I can do this work for you in good time and good price don't worry about anything Just award the project and get it done fast! PM me to discuss further Thanks!
£255 GBP in 2 days
4.9 (14 reviews)
4.3
4.3
User Avatar
Hello, I have done several excel VBA programs just like this one you need. I can create a VBA program that will connect to the files you've mentioned, sort, join or process (if required) the data, save a daily xls file into a folder and another program that will import those files and create automated reports. Just in order to ensure this to you by sending a video sample of how I can do this, could you please share the 2 xml and the 2 csv files with me? Thank you.
£277 GBP in 7 days
5.0 (10 reviews)
4.0
4.0
User Avatar
I can do your Excel structured report using VBA, please contact to discuss in detail and move further, thanks. Relevant Skills and Experience Excel, XML
£555 GBP in 10 days
4.6 (1 review)
2.4
2.4

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
2
Payment method verified
Member since May 27, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.