Käynnissä

Excel 2003: two text extraction macros needed

FIRST MACRO: XML EXPORT (TMX)

Given a xls file with two columns of text, the macro generates a simple TMX file ([url removed, login to view]) with the content of said columns and prompt where to save it.

REQUIREMENTS: Must be able to cope with cells with very long text and line breaks, must be able to handle long files without freezing, must accept Unicode text.

SECOND MACRO: SELECTIVE ELIMINATION OF COLUMNS

Given a folder with several xls file, the macro must browse each workbook and sheet, deleting all columns that don't contain specific key words in their heading.

Requirements: Must provide a dialogue box where file folder, key words and the line containg the header can be set, must be able to handle long files with several sheets without freezing, must accept Unicode text.

Delivery: Beginning of next week would be nice. Thank you.

Taidot: Excel

Näytä lisää: excel tmx, xls header, en save, text macros, xml excel, two, save to excel, macro excel, macro + excel, line sheet, freezing, en excel, cells, excel specific, text box excel, xml file excel, text line breaks, http text, excel text columns, excel macro save, simple text excel, file extraction excel, excel macro simple, excel line, excel workbook macros

Tietoa työnantajasta:
( 1 arvostelu ) Genova, Italy

Projektin tunnus: #505215

Myönnetty käyttäjälle:

excelmodeler

I can develop the two macros for you with my current level of expertise. Being a coder and an excel modeler this task is easy for me and I can provide the complete solution within 2 days.

50 $ USD 2 päivässä
(1 arvostelu)
1.4

6 freelanceria on tarjonnut keskimäärin 108 $ tähän työhön

mshamir

i am ready to start

112 $ USD 6 päivässä
(0 arvostelua)
0.0
OttomanAhmad

i am sound user of excel sheets, I can perform your project as well as you require. plrease refer me.

45 $ USD 3 päivässä
(0 arvostelua)
0.0
evgendkv

Hi! I can do both macros by Monday. Regards, Eugene.

200 $ USD 3 päivässä
(0 arvostelua)
0.0
codeguru101

I am a VBA expert. I have very good experience with Excel Macros. I will provide quick & professional service.

40 $ USD 1 päivässä
(0 arvostelua)
0.0
ProfService

Can do this task. Please check PM. Thanks.

200 $ USD 10 päivässä
(0 arvostelua)
0.0