I am in need of some short VBA macros that will automate some tasks in Excel.

₹1500-12500 INR

Completed

Posted

over 5 years ago

₹1500-12500 INR

Paid on delivery

Hello, I want to streamline some tasks for my colleagues so I want them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followed by the contents of cell A1 and the time now in hour and minute format" From a second button: export a specific range within a sheet in that new file to a pdf of the same name and it be automatically emailed to a specific group of addresses with a preset title and preset text in the body of the email. From a third button send a specific sheet in that new file to a pdf of the same name and it be automatically emailed to a specific group of addresses with a preset title and preset text in the body of the email

Excel

Excel VBA

Project ID: 18305957

About the project

19 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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:

@nvchien94

I am VBA expert and I can help you to solve this task. It is can be completed very fast I think. Contact me and we can discuss more. Thank you.

₹2,500 INR in 1 day

5.0

(229 reviews)

6.6

19 freelancers are bidding on average ₹5,538 INR for this job

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.

₹7,777 INR in 3 days

5.0

(194 reviews)

7.1

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

₹7,000 INR in 3 days

4.7

(96 reviews)

6.4

@macroPOL

Hello, I am Excel and VBA expert. I can do this project. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan

₹10,000 INR in 3 days

5.0

(94 reviews)

6.1

@paulodayto08

Hi Good Day! A serious freelancer here! I can help you to complete this project in 2 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!

₹2,750 INR in 2 days

4.8

(83 reviews)

5.6

@dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

₹5,000 INR in 3 days

5.0

(45 reviews)

5.2

@prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.

₹3,333 INR in 3 days

4.4

(46 reviews)

4.8

@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 request

₹3,500 INR in 3 days

5.0

(10 reviews)

3.9

@mythtaker672

-Computer Engineer with 5 years of professional Excel/Access/Outlook VBA experience -I can complete this in 3-4 hours -Continued free support even after project completion

₹1,500 INR in 1 day

4.1

(3 reviews)

2.2

@claudiasofamata

Hi, you have an interesting project and I would like to work with you, my name is Claudia Mata, I am an Excel specialist, work with dynamic tables, macros and VBA, I can support you in your project, I am responsible, deliver quality projects in a short time.

₹3,333 INR in 1 day

5.0

(3 reviews)

1.7

@mhetre1s

I am an expert in Microsoft Excel Spreadsheet formulas and Visual Basic (VBA) programming for Excel files. I am willing to do the first project at low cost in order to demonstrate skills, earn good feedback and possibilities of future work association. Samples of my work in Excel and Excel VBA can be viewed on my portfolio.

₹1,500 INR in 5 days

0.0

(0 reviews)

0.0

@pritampareek1991

Hello, It's a pleasure to discuss with you regarding the project. I've gone thru your job rand understand what you want exactly. I've also checked your given the Project Description. I'm able to help you for the same and happy to work with you. As i was an operation manager in a call center with some repudiated Telecom company. Just want to know when you would like to schedule the interview?

₹7,000 INR in 3 days

0.0

(0 reviews)

0.0

@ss247

What email client will be used? Gmail ? will you require SSL ? Will the template be stored in the same folder or a new location? Is it compulsory that ranges and sheets be converted to pdf before emailing? (if yes some scripts may need to reside on the pc and not completely inside excel.) also dependant on OS in question. I can do some scripts for Windows 7 8 10. Sending the entire workbook is possible and I can incorporate a pin that can be given to each user separately that allows them individual access to the spreadsheet. This using formulae and not the built in passwords and encryption from excel. Im new to Freelance but I have a skill and work ethic.

₹13,888 INR in 6 days

0.0

(0 reviews)

0.0

@HDellam

Hi Dear, I would like to work on your request, I have a prominent experience with your request as I have been doing that for an aerospace company, My salutations

₹2,250 INR in 3 days

0.0

(0 reviews)

0.0

@adrianzimme

Cordial greetings! I graduated in Information Technology (computer science), postgraduate in business management, postgraduate in Marketing and postgraduate in neuropsychology. I am unemployed and I need this opportunity a lot! I can do it with excellence and with a lot of responsibility. I love working with excel and database.

₹11,111 INR in 10 days

0.0

(0 reviews)

0.0

@KDRaychura

Right now, i am working in SAP with Excel so I know VBA coding very well. i am done many projects related Excel macro and SAP for our clients like 'Durr', 'Unilever', 'Nalba tech', 'Petronas' etc. if you need then I can email my resume as well. Also I am interested in ur project. let me know your thoughts.

₹3,333 INR in 1 day