Find Jobs
Hire Freelancers

Modify a VB Script and Excel Macro

$10-30 USD

Completed
Posted almost 7 years ago

$10-30 USD

Paid on delivery
We want to schedule some spreadsheets to automatically open, refresh query data, then save and close. This will require a Visual Basic script and Excel Macro running in conjunction with each other. You should be aware that there is a lot of data to be refreshed and also a lot of calculations that occur subsequent to the data refresh, so the spreadsheet cannot save and close before everything is done. In one case, we need to save the spreadsheet as an excel file and also save one of the sheets as a csv file. We have code developed, but we need someone to tweak it so that everything works properly. We've attached images of what we have already.
Project ID: 14520903

About the project

16 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
That code looks similar. I think I wrote that code for someone. How Do I know? Well, Do you see the "~~>" in " ~~> Change Path Here" That is my style of coding. :) Found it :) [login to view URL] I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). I have done more than 170 projects. In fact my reviews will speak for myself... Rest of the details post discussion Relevant Skills and Experience You can see it for yourself :) [login to view URL] [login to view URL] Proposed Milestones $35 USD - For project completion
$35 USD in 1 day
4.9 (178 reviews)
6.6
6.6
16 freelancers are bidding on average $58 USD for this job
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
$90 USD in 2 days
4.9 (209 reviews)
7.2
7.2
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience Relevant Skills and Experience Lets discuss more online on chat. Proposed Milestones $45 USD - Initial
$94 USD in 0 day
4.9 (141 reviews)
6.4
6.4
User Avatar
update macro based on requirements Relevant Skills and Experience Excel/VBA/Macro Proposed Milestones $50 USD - Completed macro
$50 USD in 1 day
4.8 (155 reviews)
6.5
6.5
User Avatar
I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience designing and developing Excel spreadsheets filled with formulas and VBA code. Proposed Milestones $90 USD - I would approach your project by creating a draft spreadsheet and send it to you for review. When can we chat or talk? I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3).
$90 USD in 1 day
4.9 (130 reviews)
6.5
6.5
User Avatar
Hi I would like to work on your project. I hope you will be fully satisfied after completing this project with me. Relevant Skills and Experience VBA Proposed Milestones $30 USD - project
$30 USD in 1 day
5.0 (53 reviews)
5.6
5.6
User Avatar
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find my previous work samples. Please let me know if we can discuss further on this. Relevant Skills and Experience vba macro excel Proposed Milestones $35 USD - project
$35 USD in 1 day
5.0 (20 reviews)
5.1
5.1
User Avatar
A proposal has not yet been provided
$50 USD in 1 day
4.9 (48 reviews)
5.4
5.4
User Avatar
Hi, I have went through images. There are small bugs that has to be reprogram to make it more efficient. I have 7 years of experience in this field. You can read client reviews on my profile Relevant Skills and Experience Excel, VBA Proposed Milestones $30 USD - Final Looking for your response.
$30 USD in 1 day
4.9 (24 reviews)
5.3
5.3
User Avatar
Experienced Data Analyst and Macro Developer. Relevant Skills and Experience I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. Proposed Milestones $35 USD - final
$35 USD in 1 day
4.8 (59 reviews)
5.2
5.2
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$25 USD in 1 day
4.9 (25 reviews)
4.3
4.3
User Avatar
I agree that VB script is the way to do this. Examples are available in technical discussion groups. Relevant Skills and Experience Engineering degree. 16 years of working in IT industry in USA, UK & New Zealand. Now I teach VB for Excel to graduates who join IT companies. Proposed Milestones $5 USD - Your acceptance of my detailed requirements document after initial chat to gather full requirements $5 USD - My proposed plan for changes in VB accepted by you $10 USD - Draft solution delivered to you $5 USD - Final solution with your corrections done Additional Services Offered $10 USD - List of enhancements $10 USD - Effort estimate for enhancements When can we have initial chat ? Can you kindly share the VB script ? I can study them & come back.
$25 USD in 5 days
5.0 (1 review)
0.8
0.8

About the client

Flag of CANADA
Barrie, Canada
5.0
14
Payment method verified
Member since Jan 3, 2015

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.