Em Andamento

Excel CSV Text File Export

I work for a travel agency and? need a macro for Excel to export a customer's travel data data contained? in a .CSV file to a text file.?

There will? be 11 fields in the .CSV file comprised of cost center,? space, date of issue,? lastname/firstname,? amount, invoice number, flight segment city codes, credit card? #, ticket number, space, date of travel.? ? All fields except for the amount need to be enclosed by quotation marks.? The? "amount" field should also be? a fixed decimal format ([url removed, login to view]).? The "date of issue" and "date of? travel" fields should be formated as? mm/dd/yyyy, ie..06/06/2008 instead of 6/6/2008.

I had been able to find code to export the data? with quotes around everything, but no formatting for the dates and amount nor excluding the amount from being surround by quotes.? ? ? This was done with Visual Basic, so I'm looking for a more capable macro built with Visual Basic that can be saved in the [url removed, login to view] template in Excel as a macro.

## Deliverables

Here is a sample of how the exported text (.txt)? file should look:

"111 0590001","","06/23/2008","COLWELL/BLAINE",79.50,"991703","PDX SEA","CAXXXXXXXXXXX00957","7198600516","","07/10/2008"

"111 0590015","","06/23/2008","CALLAHAN/RICHARD",134.50,"991722","RNO LAS","CAXXXXXXXXXXX00957","7198600534","","07/10/2008"

"232 3910036","","06/23/2008","BEESLEY/DAVID",277.00,"991732","SLC ELP SLC","CAXXXXXXXXXXX00957","7198600542","","07/07/2008"

Habilidades: PHP

Ver mais: visual basic cost, php to excel export, m format in excel, how to format quotes, excel quotation template, excel macro how to, customer data excel template, csv codes, a format quotation, david data, credit card csv, quotation sample template, invoice template in excel, excel invoice template , customer data in excel, Visual Basic Excel, Ticket management, text file, nn, export from excel, excel-to-csv, excel visual basic, Excel to CSV, Excel Formatting, data to text file

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #3023136

Premiar a:


See private message.

$21 USD em 14 dias
(85 Avaliações)

2 freelancers estão ofertando em média $23 para este trabalho


See private message.

$25.5 USD in 14 dias
(81 Comentários)