Modification of an Excel-Macro

Hello Sir, 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 niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. PS: i have the solution already :) Best regards

A proposal has not yet been provided

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. The error is corrected. Besides that code for opening CSV has some pitfalls. It has no code to process wrong file path and cancelling the CSV file picker dialog. Added correct processing of those events.

Hi, I find the cause of the error and I ll fix in 30 minutes. Ready to start. Thanks ***************************************************************

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on projects.

I can do it for you quickly and exactly

Hello sir, I already did some changes in your code. Now your Macro is working flawlessly. Please contact me to show you what you need to do. It is very easy and clear. Hope to hear from you soon. Regards, Ivan

I have excellent command on MS Excel. I have completed complex projects in Excel before as seen in my portfolio. (like - built a reservation system in Excel that involved formulas and Macros to consolidate data from various sheets and pricing calculation.)

Hello, I'm an expert in VBA and VB.NET with almost 10 years of experience. I had a quick look at your code and noticed that you are referring to the sheet "Data" for both the source file (CSV file) and the destination file. But the sheet name in the source file isn't "Data" but "margintracker_1839167". If you change that in your code you should be fine. This one was too simple to charge any money for, so you get that one for free. I hope that in the future if you run into any other problems, or you want some code written, you contact me first to have a look at it. Best regards Wesley

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 55 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I have the solution ready for you. Regards

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

There must be simple path problem which can be solved within 1 day.

Hello! I'm experienced software developer. I can do this task quickly and professionally. Please consider my bid. Best regards, Alexandra

Hi, I was free to already fix problem in your VBA code. Please contact me so I can send you solution. Regards, Mladen

Hello, As mentioned earlier, I have fixed the macro. There's no provision for attachment for me right now. Otherwise would have sent you the fixed macro. So please ping me on freelancer chat. Waiting for your reply.

Vastly experienced in dealing with macros and error reporting. Time is not an issue, can be completed on your timeline. More interested in the exposure than the payment.

Hi, Good day! I am new to freelancer and this is my first bid. I am an experienced technical consultant with at least 8 years of experience with Excel Macro programming. I was able to open your files and I already know where the problem is coming from. It is an easy fix. Aside from that, I want to make your file more efficient. As you may have noticed, your file is consuming 18MB. This is a huge file considering the amount of data that you have. The reason for this is because of the formulas that are copied up the the very last available row in excel. Hope you consider my offer. You may add me as a contact so we can discuss the requirements further Thank you so much. Brian De Sagun

Hi, I have looked through your code and found the exact nature of the problem. I've corrected the code and ran the macro and it worked as expected. If my proposal is accepted I'll pass you the updated code and will also explain why the original code failed