Completed

Excel File Programming

A friend of mine has an application inside an Excel file that allows him to select another excel file and process the data within to render a report. I need something similar.

I have a bunch of excel files with data attributes I can't capture when exporting to different formats. They appear as selectable dropdown menus in Excel. My ultimate goal is to capture each row/column with the dropdown-attributes and export it to Simple XML or some other easily delimited format.

Attached is an example data file. The sheet is labeled "Refinements". The attribute dropdown column is labeled as "Accepted Values (combo boxes)".

This is an example of the preferred export format for row 1:

<row>

<column>13400501</column_a>

<column>AC & DC Arc Welding Equipment</column>

<column>Vehicle Type</column>

<column>thesaurus_attribute_keywords</column>

<column>

<option>commercial-truck</option>

</column>

</row>

So in short, allow me to open these files and spit out the above results.

Thank you in advance, happy bidding!

Skills: Excel, Excel Macros

See more: excel programming tutorial, how to open vba in excel 2007, how to open vba in excel 2016, vba excel download, programming in excel 2016, excel programming examples, excel vba programming pdf, vba excel 2013, how to fix a corrupted excel file, getting c programming assignment done from a tutor, find a string in a file c programming, can i file a dba as a freelancer, best programming language to find a job, where do youlook to find packaging like boxes for a product in a business, you are required to copy some data from a text file and move it into an excel file according to my instructions

About the Employer:
( 126 reviews ) Woodland Hills, United States

Project ID: #15021285

Awarded to:

aarifakhtar

Hi: I can create a macro (VBA) tool in Excel which would allow you to import the input file with click of a button and then generate the output Relevant Skills and Experience Please note that over 80% of my completed More

$250 USD in 1 day
(148 Reviews)
6.8

35 freelancers are bidding on average $424 for this job

cgullapalli

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel vba, XML Form More

$250 USD in 0 days
(593 Reviews)
7.6
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex More

$250 USD in 1 day
(200 Reviews)
7.2
TonmoyRoy111

A proposal has not yet been provided

$250 USD in 3 days
(218 Reviews)
6.3
wsh2

Greetings Rick from Easton PA.. {smile} Highly experienced (25+ years) MsEXCEL Programming and Database expert with Guru / Mentor level technical credentials at [login to view URL] and vbcity.com. Relevant Skills an More

$373 USD in 10 days
(29 Reviews)
6.0
ShiaFirst

Hello, This project is quite easy for me, but I got couple of questions to clear before we proceed [login to view URL] message me to have a quick chat. Relevant Skills and Experience Excel, Excel Macros Proposed Milestone More

$700 USD in 15 days
(51 Reviews)
6.4
ponnarasiBabu

I read and understood your requirements and would like to discuss further. So i hope you would open a PM to discuss about the work . Regards, Ponsi Relevant Skills and Experience Excel, Excel Macros Proposed Milesto More

$500 USD in 3 days
(66 Reviews)
5.8
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana More

$250 USD in 10 days
(34 Reviews)
4.7
dvcontact

Hi, If you are looking for a professional and reliable Excel expert with proficiency in data analysis and macros, I'm your ideal candidate. Relevant Skills and Experience I'm highly experienced in advanced solutions w More

$300 USD in 10 days
(13 Reviews)
4.4
JLQ006

I've made similar projects before. A fairly simple project for an expert in excel automation Relevant Skills and Experience expert in excel automation Proposed Milestones $250 USD - Complete

$250 USD in 3 days
(16 Reviews)
3.7
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

$250 USD in 5 days
(9 Reviews)
3.8
$555 USD in 10 days
(9 Reviews)
4.2
chintuag

Dear Hiring Manager, I have read the project description and would like to work on it. I have recently closed 4 projects in excel using macros. I am a professional with 10 years experience in excel and have worked on More

$276 USD in 3 days
(5 Reviews)
3.5
hemsingh1

Hi, Mathematics, Statistics, MS Excel, MS Access & VBA expert with over 8 years of [login to view URL] the requirements and ready to start. Can update and work as desired. Thanks Relevant Skills and Experience MS Ex More

$444 USD in 3 days
(9 Reviews)
3.3
aubrey03

I am the right person for this. I am a Excel VBA expert. My specialization is process improvement but I can also reverse engineer Excel VBA projects and make improvements if necessary. Relevant Skills and Experience F More

$250 USD in 10 days
(14 Reviews)
3.8
startechoffshore

Hi there! Your project seems interesting to us and we believe we would be a perfect match for your requirement. Relevant Skills and Experience Excel, Excel Macros Proposed Milestones $250 USD - on completion of pro More

$250 USD in 3 days
(16 Reviews)
3.1
WorldAccountants

Need help with excel project Relevant Skills and Experience Hi, Please send a message on chat and I will be able to help you. Proposed Milestones $611 USD - Project

$611 USD in 1 day
(4 Reviews)
3.2
arshadnatasha

I can do this for $350 (negotiable) in 4 days (also negotiable) Relevant Skills and Experience I have taught Excel at college for 4 years and written many macros for complex projects. I can do this for you in one day, More

$350 USD in 10 days
(3 Reviews)
2.6
dongmei1993

I have many experiences for data processing and filling using excel vba and macro. I always guarantee high quality and trust when working with my clients. Relevant Skills and Experience We can understand each other an More

$555 USD in 10 days
(2 Reviews)
2.6
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i More

$277 USD in 3 days
(7 Reviews)
2.7
Moh6335

I have read your project derails and would like to work on your project Kindly visit the below mentioned link to have a glance at our portfolio https://www.freelancer.com/u/Moh6335.html Thanks Relevant Skills and Ex More

$400 USD in 3 days
(1 Review)
1.6