Find Jobs
Hire Freelancers

Writing 3 VBA-macro's in Excel (Main: make a big UserForm; other: move files and a save as loop)

€30-250 EUR

Completed
Posted over 7 years ago

€30-250 EUR

Paid on delivery
Writing 3 Excel VBA macro's. - 2 small macro's related to files. - 1 big Userform to be made with a macro to fill the worksheet with the info from the userform. You can take a look in the attached files to have a better understanding of what is requested. The info is in Module1 of the file. [login to view URL]: Save the worksheet. Check if the file allready exists and if so, display a messsage that it allready exists (once) and save the file with a new name. Add _1 to the filename and try again. If _1 exists, add _2 instead. If _2 ... [login to view URL]: Make a Userform to make it more easy to input data. The excel contains images of how the Userform should look like and how it should react. [login to view URL]: Move files from one folder to another, only if the name does not start with "xxxxx" (variable).
Project ID: 12321115

About the project

46 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
€130 EUR in 3 days
5.0 (122 reviews)
6.6
6.6
46 freelancers are bidding on average €140 EUR for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
€100 EUR in 7 days
5.0 (668 reviews)
8.7
8.7
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€200 EUR in 2 days
4.9 (566 reviews)
8.5
8.5
User Avatar
Hi, I am good at Excel and vba. I have gone through the file and description. Looking forward to discuss in the chat.
€150 EUR in 2 days
5.0 (1231 reviews)
8.5
8.5
User Avatar
Hello, I am visual basic programmer, specialize in creating automated macros for excel. I can create for you desirable user form and save data as you like. If you are interested, just pm me
€133 EUR in 5 days
5.0 (160 reviews)
8.2
8.2
User Avatar
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on skype as well to discuss more: ashish260287 Thanks and Regards, Ashish Singhal PLEASE CHANGE THE ATTACHED FILE'S FORMAT TO XLSM BEFORE USING.
€155 EUR in 3 days
5.0 (290 reviews)
8.4
8.4
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
€150 EUR in 3 days
5.0 (508 reviews)
8.0
8.0
User Avatar
Hello sir I can achieve this project perfectly please contact me for more details about the project best regards
€55 EUR in 3 days
4.8 (43 reviews)
7.6
7.6
User Avatar
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. Best regards
€150 EUR in 3 days
5.0 (336 reviews)
7.5
7.5
User Avatar
Hi, I have 4 years experience in Excel VBA programming and created numerous VBA tools with userforms. The first request is clear and so is the useform (except for hard to read handwriting - sorry). Could you please explain the last one more detailed? Regards, Balint Kolosi
€140 EUR in 3 days
5.0 (132 reviews)
7.1
7.1
User Avatar
Hi there. Checked your doc. Nice drawing :)) I can build the macros as you like. Whats your operating system? OSX or Windows? (I ask especially, because file saving procedures on Mac and Windows are different due to different structure) Let me know if you are interested
€315 EUR in 4 days
5.0 (142 reviews)
7.2
7.2
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
€789 EUR in 7 days
5.0 (32 reviews)
7.2
7.2
User Avatar
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
€88 EUR in 1 day
5.0 (100 reviews)
6.9
6.9
User Avatar
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. The major part of your project is User Form and my price is for that. I have excellent knowledge and experience of creating User Form and its elements Command Button, Drop Down, Check Boxes, Option Buttons etc. in excel VBA. I have also expertise in Data Validation, Save Files and check whether the file name exist or not. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
€120 EUR in 3 days
4.9 (142 reviews)
6.2
6.2
User Avatar
I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Finance Management Statistics Data Processing Data Collecting (Using Macro) MS Office C++ HTML VBA Mathematics Excel VBA Macro Automation User Forms Data Analyzing PivotTable Chart Graphic Presentations Data Presentations And any task related to Excel Feel free to contact me.
€30 EUR in 3 days
4.9 (82 reviews)
5.8
5.8
User Avatar
Hello, I can create the macros and the userform for you. If you are interested please open a chat with me. Kind regards, Sorin
€155 EUR in 5 days
5.0 (77 reviews)
5.7
5.7
User Avatar
Hi, I have gone through your project files and would like to take an opportunity to work on it. Being highly experienced in writing VBA Macros, I can help you with requirements of creating userform, moving files and folders as mentioned. Waiting for your response for further communication, and I assure you of project quality and time deadline. Thanks.
€66 EUR in 3 days
4.8 (112 reviews)
5.9
5.9
User Avatar
Dear Sir, I am based out of Jersey City, NJ, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, 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.
€155 EUR in 3 days
4.8 (86 reviews)
6.1
6.1
User Avatar
Hi, i can help you with this project, please let me know more about it :) .
€100 EUR in 3 days
5.0 (30 reviews)
5.4
5.4
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
€66 EUR in 1 day
4.9 (62 reviews)
5.5
5.5
User Avatar
Most of the reviews on my profile are for excel and I am willing to work on your project. My reviews speak for my quality work. Thanks Varun
€133 EUR in 3 days
4.8 (70 reviews)
5.5
5.5

About the client

Flag of BELGIUM
Brugge, Belgium
5.0
4
Member since Dec 7, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.