Kapalı

Write a VBA code to convert excel file into a standardized format (EDI or Excel)?

I work in the container shipping industry. Currently we are receiving Terminal Departure Reports (TDRs) from terminals all over the world after a port of call.

My company is adopting a global standard format known as the TPFREP, where it can be uploaded into our systems either in EDI or excel format. However, not all terminals in the world today are able to produce the TDRs in the TPFREP format, hence a number of locations worldwide are still sending their TDRs in their own formats.

The task is to be able to write a VBA code to convert the TDRs from those terminals not able to support TPFREP, into the standardized TPFREP template (either in excel or EDI formats).

To do this, the macro must be generic enough to read a variety of formats from the terminals, pick up the right information to populate the TPFREP template so that it can be uploaded.

Beceriler: Excel, Visual Basic

Daha fazlasını gör: vba code create pdf file access 2007 report, convert tdb file ascii format, convert exe file fla format, open edi file in excel, convert edi to excel, convert edi file to csv, convert 834 file to excel, convert 835 file to excel, convert 837 file to excel, convert excel to edi format, convert edi file to excel online, convert photoshop file vector format, convert stl file igs format, convert tif file vector format, write html code upload xls file web page, excel file word format, can convert illustrator file html format, vba code convert html excel, excel vba code convert sql vba, excel vba code convert

İşveren Hakkında:
( 0 değerlendirme ) Singapore, Singapore

Proje NO: #17783396

Bu iş için 33 freelancer ortalamada $214 teklif veriyor

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(633 Değerlendirme)
8.3
deepbluetech

Hi, I am an Excel macro expert and would be happy to take on your project. Kindly provide sample TDR format files and the expected TPFREP format Excel file. Regards, Arul

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(198 Değerlendirme)
7.3
schoudhary1553

Hello, Hope you are doing well. I can help with your project Write a VBA code to convert excel file into a standardized format (EDI or Excel). I can assure you the quality job. I have good experience in Excel, Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(275 Değerlendirme)
7.6
asin1987

Dear Employer, I understand your need of writing VBA code on Excel but I need to discuss few things, please message me so that we can discuss in detail. Thanks and Regards, Ash

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(112 Değerlendirme)
7.0
TonmoyRoy111

Dear client I understand the scope of work involved in the project. I can write the macro code for you which will solve the purpose you mentioned. Please share sample files to understand the nature of the data. Roy

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(264 Değerlendirme)
6.5
archanaoswal

I can write a macro to do the necessary format conversions in Excel. I have even worked with EDI format before. https://www.freelancer.com/projects/php/Write-code-convert-the-Excel/?w=f I have excellent command on Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(75 Değerlendirme)
5.7
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on excel using VBA/macro and completed several tasks of generating required excel format from given input, based on it I can help you with Daha Fazla

in %bids___i_period_sub_35% gün içinde61%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(88 Değerlendirme)
5.7
finecodervw

Hi, I am very confident on handling this writing of generic macro using VBA to convert various terminal formats to standard format. If possible, please share the variation of the formats to understand the degree of Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)
5.5
usmanhassan123

PhD in computer science having seven years of experience in Excel development and visual basics

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(39 Değerlendirme)
5.8
SShtv

Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my works. Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(60 Değerlendirme)
5.7
vmadhavan15

am not a random bidder.. Please ping me if you are intersted with my proposal and share more detail along with smaple formats.. thank you..

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)
4.8
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can arrange data into various formats. I have excellent knowledge and experience of Manipulating Data of Multipl Daha Fazla

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)
5.2
aubrey03

I am an Excel VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(51 Değerlendirme)
5.1
liveexperts123

.......................................................................................................................................................................

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
4.1
vijayvizzu7

Hi, I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. I am sure i can handle your requst

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
3.8
dataexplorer

"Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working her Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
3.3
rayyankabir

Hello, I see your requirements and what I need to do. For logic and process flow, we can discuss over chat. I have 10+ years of experience on Excel, VBA, Access and outher Office applications. Please ping me and le Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
3.3
in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.8
sumitnavani

Hello, I have experience in developing these kind of tools, I will be able to deliver it quickly. I am doing it at very low cost because I need good ratings on freelancer.com

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
mesutarianshad

link an example file please

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0