Create excel macro to turn excel file into a formatted .txt file

VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check https://www.freelancer.gr/projects/Data-Processing-Excel/data-translation-excel.html and feedback at https://www.freelancer.gr/u/paris2785.html I can start right away. For any questions, please let me know. Paris

Hi, My name is Jon and I will be happy to help you with the project. Hoping to hear back from you soon

Hi Mate. I have read the description and I can write this macro within a day. I have been doing VBA macros for years. Kindly message me prior to offering the project. Usman.

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.

A proposal has not yet been provided

Excel/macro developer since 1997. The task isn't hard. However, some clarifications are going to be needed. The file name: it will just have the time stamp (BTW, quite doable), no other text? The formatted row: the delimiter between fields cannot be both spaces and indents. Should be indents only. Pls clarify. The total row: I imagine it should have an indent between the 2 calculated numbers. Best would be to see a sample, if you have one. Can do. Regards, Svet.

I have excellent Macro experience [10+ years] . Please check my past reviews and ratings. I assure you 100% accurate & quality job. Please provide more details so that i can give you a demo work. If you are 100% happy with my demo work then you can award me this full project . I am sincere,honest and hardworking independent freelancer . I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi

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 usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards

Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel. I have successfully completed similar projects for 'Sadebow'. You may have a look at review provided. Please revert back for any questions/clarifications. Regards! Vikas

Hi, I am working as a Software Engineer from last 3 years. Currently I working on projects solely based on Windows platform and MS office applications specially Excel and VBScripting So,I am good option to go with. Looking forward to hear from you. We can start as soon as you award this project to me. Thanks Abhinov

Hello, Thank you for explaining the job so well. From your explanation I understand that : If the excel file is in the following format Company Name: ABCDEF CustID Amt CT01 $22.25 CT02 $32.21 CT92 $47.00 CT03 $88.75 The output txt file shall be formatted like H000ABCDEF CT01 $22.25 CT02 $32.21 CT92 $47.00 CT03 $88.75 4 $192.21 Is this alright? If not if you explain the changes, I'll happily do the work for you. I did several short jobs like these in the past. I'll create a macro, so when you run it, all it shall ask for is the location you want to save the file, and when you chose the txt file shall be automatically saved in the corrects format. And yes, the file name shall contain the date and the time stamp. That's not a big issue at all. So if you are interested to explain me more, or want any clarification from me, then do drop me a few lines. I'll be glad to help you out. Thanks & Regards Raad

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder

Consider it done!!!, as a 12 year experienced VBA developer I will deliver high quality results, you wont be disappointed, take a look at my profile and see what other employers are saying about my past work... thanks for considering my proposal.

Hello I am an Excel VBA expert. I can quickly set up this macro for you (in Excel 2010) to create the text file output in the specific format. The development will take me an hour and I can start work on it immediately. Best regards, Brent

A proposal has not yet been provided

Hi. Looks like fast and easy task. Can you provide a sample of Excel file and sample of txt file? Regards, Eugene

Hi Can you clarify the header is like "H00coyname" where H is fixed, 00 depends on coyname length, coyname is company name as provided in Excel file with or without space separator. The rest of the rows are fixed in field length, text right justified. The amount field will be "1234" when in Excel file it is $12.34. Please advise position of total $ amount Plase also advise rows count

If you award me the job, i will start doing the job now in order to finish as soon as possible. I will leave you satisfied. Thank you in advance ps. We can discuss about the price too. I can do much lower.I just need to start soon

Hi. I have extensive experience with VBA macro automation for Excel. I am confident that I will be able to deliver up to your requirement in no time. Please let me know how soon I can start working on your project.

A proposal has not yet been provided

hi, would be glad to collaborate and provide such Excel VBA script for generating described txt file thanks Victor