Excel Structured Report from XML File through Data Model and VBA script
£250-750 GBP
Paguhet në dorëzim
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.
Revised Description:
Step 1
Macro to automate the downloading and saving of Day report XML
Macro to automate the downloading and saving of Day report CSV
Set up Task Scheduler VBS script to automate the above at a set time daily
Step 2
Macro to import data from both XML and CSV reports into excel
Data mapping set up to organise and pull out the relevent data for final reports
Macro to automate the production of final day reports, exported as .xls to a specified folder
Set up Task Scheduler VBS script to automate the above at a set time daily
Step 3
Macro to pull together all day reports into a weekly report, exported as .xls to a specified folder
Macro to pull together all weeky reports into a Running Totals report, exported as .xls to a specified folder
Set up Task Scheduler VBS script to automate the above at a set time on set day every week
Step 4
The 3 final reports (Daily, Weekly and Running Totals) will be required fo 2 separate locations (Different source XML and CSV files)
Macro to produce a combined 'Running Totals' Report for all locations
Set up Task Scheduler VBS script to automate the above at a set time on set day every week
ID Projekti: #17052802
Rreth projektit
35 profesionistë freelancer dërguan një ofertë mesatare prej £406 për këtë punë
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 proje Më shumë
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.
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
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.
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 c Më shumë
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
Hello. I have great experience with xml, csv data processing using VBA. I can make the best solution for you!
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 f Më shumë
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
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
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
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 Se Më shumë
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!
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 fil Më shumë
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