Automation in Excel - open to bidding

Completado Publicado Oct 26, 2013 Pagado a la entrega
Completado Pagado a la entrega

I need an experienced Excel Programmer to develop an automation/vb script to do the following.

1. Import a txt file from a specified location (with the most recent timestamp) - which is in a format as listed below - YYMMDDXXXXX,TXT

2. Delete contents of last 2 Columns except last row (the number of rows may change from file to file)

3. Change Column C format to a Custom format of 16 zeros

4. Save file in format Company_Name (which will not change) - MM-DD-YYYY (2 days prior to date found in txt file) and save as Excel 97/2003 format.

Excel

Nº del proyecto: #5066148

Sobre el proyecto

37 propuestas Proyecto remoto Activo Oct 28, 2013

Adjudicado a:

elMancha

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I' Más

$30 USD en 1 día
(59 comentarios)
5.4

37 freelancers están ofertando un promedio de $84 por este trabajo

jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Más

$55 USD en 3 días
(647 comentarios)
8.3
zExcel

I'd be happy to write the macro for that, and can start as soon as you are ready ---------------------------------------------------------------------------------------------------------------------

$45 USD en 1 día
(250 comentarios)
7.6
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$80 USD en 0 días
(325 comentarios)
7.6
seaanddream

Hello; your 5-star excel and vba coding expert is ready to help your macro project. I had many similar tasks, all achieved with 5/5 rating, pls check my profile and feedbacks....ready to go ahead, upon your confirmatio Más

$45 USD en 1 día
(262 comentarios)
7.7
sswijaya

Hi, Let me help you with this. Could you send me a sample file of source file and output file? I can work on this and send you the result in a day. Looking forward for your quick reply. Regards, Susanto

$30 USD en 1 día
(58 comentarios)
6.4
mrbrave

Its hardly two hours work for experienced Excel developer...I have great experience in excel coding and complete this script within 2 hours....Lets start

$34 USD en 1 día
(221 comentarios)
6.6
bmartynvw

I'm a Microsoft certified developer with 18 years of experience. I can do this for you. Because of the nature of the work you have mentioned, I would recommend using OpenXML to do this, rather than doing this as an Exc Más

$247 USD en 30 días
(4 comentarios)
5.9
gangabass

Hi, this is really easy project for me. I can provide you complete solution in few hours and I'm sure you'll be impressed with my work. I'm talking about standalone GUI program where you can select source TXT file Más

$35 USD en 1 día
(84 comentarios)
5.7
nagybatonyi

I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the u Más

$35 USD en 20 días
(62 comentarios)
5.7
tomislav1975

VBA Excel expert with 100% Repeat Hire Rate I can make this very fast. Please check my reviews and portfolio as proof of my expertise.

$78 USD en 3 días
(34 comentarios)
5.3
manishadk

Hi, I am expert Excel VBA/VB programmer. I have already worked on such type of projects. I can come up with demo version for you if you provide some sample data. If demo version looks good then you can select me Más

$35 USD en 1 día
(15 comentarios)
4.0
Mat66

Hello, I have very good experience with such data processing and can do this quickly. Please let me know if vbscript is a requirement or if a vb.net console application would be ok as well. Also, please be aware tha Más

$50 USD en 3 días
(3 comentarios)
3.7
AccuPro

Hello, Automation expert here. Can complete your requirement in a day. However, allocated 3 days just to be safe. I take up projects only if I am confident of finishing them successfully. A few questions: 1. Are t Más

$150 USD en 3 días
(5 comentarios)
2.8
mailsmaity

Ready to work on this.. please assign to me. will deliver project with in time. looking forward to work with you

$55 USD en 1 día
(1 comentario)
0.6
asunku1986

I have built numerous excel macros for my current company. (Over 50) And I have done much more complicated and difficult functions in Excel. Your best excel tool will not only work functionally, but will be easy to use Más

$111 USD en 1 día
(0 comentarios)
0.0
nsaraa81

Hello, I can deliver the VB script with good quality and without any bugs. Best Regards, Saravanan

$111 USD en 5 días
(0 comentarios)
0.0
powerrider2013

Completed.. Hi every thing is complete other than the 3rd point mentioned. It is unclear for me. Rest of the things are done including the name of the file to be saved with. Let me know if you can award me this pro Más

$33 USD en 3 días
(0 comentarios)
0.0
sandasiri

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0
romliramlee

Expert on excel program is my added advantage and able to do the excel database program very well. Familiar with data entry and be able to source data from internet google yanoo etc...familiar with internet market mark Más

$155 USD en 3 días
(0 comentarios)
0.0
albertdlm

I am good at MS Excel and an expert with Excel Macros and VBA. I have developed many apps etc similar to the job required

$155 USD en 3 días
(0 comentarios)
0.0