Find Jobs
Hire Freelancers

Excel VBA & macro scripting for Windows 1O environment

$30-250 USD

Closed
Posted over 5 years ago

$30-250 USD

Paid on delivery
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system. Issues to be resolved: 1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable) 2) avoid memory leaks 3) ensure that data imported from source CSV's is fully loaded before running excel functions 4) provide notes so I can then make minor adjustments in the future if the base files change What the scripts need to do: A) import data from 2 CSV files. Must be stable for up to 100,000 rows of data and up to 20 columns of data. The CSV data is basic inventory from a POS system (SKU | Price | QOH Store 1 | QOH Store 2 | QOH Store 3, etc) B) merge supplied CSV data into single QOH report and save as CSV: SKU | Price | Combined QOH | Availability Text String C) CSV being generated will be overwritten every 3 hrs with new CSV from the excel script I will supply current Excel Files and support CSV files. The "HB" set works fine in Windows 7 environment, but causes memory leaks (so machine has to be restarted daily). The "TTL" set keeps failing to import all CSV data records before running remaining excel macros) currently running: Files/HB/POS Sync Files/[login to view URL] Files/HB/POS Sync Files/[login to view URL] Files/TTL/SCRIPTS/TTL-INV [login to view URL]
Project ID: 17550009

About the project

22 proposals
Remote project
Active 6 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
22 freelancers are bidding on average $165 USD for this job
User Avatar
Hello, I can help with you in your project Excel VBA & macro scripting for Windows 1O environment I have more than 5 years of experience in Data Processing, Excel, Visual Basic, Visual Basic for Apps, Windows Desktop. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD in 4 days
4.9 (429 reviews)
8.2
8.2
User Avatar
Hello , I have checked the files, read the issues and understood your requirement. I can rebuilt all macros to work on Windows 10 and resolve all the issues mentioned. I I have 5 years experience in developing macros in excel, word, google sheet etc. I can complete task within time with 100% accuracy. With Regards, Bhaskar
$100 USD in 3 days
4.9 (474 reviews)
7.6
7.6
User Avatar
Hi, As per your project description, I will rebuild the macros for you and will take care of these issues. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
$166 USD in 3 days
5.0 (103 reviews)
6.5
6.5
User Avatar
PhD in computer science having seven years of experience in Excel development.
$250 USD in 1 day
4.8 (94 reviews)
6.4
6.4
User Avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable
$155 USD in 3 days
4.9 (74 reviews)
5.9
5.9
User Avatar
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.
$45 USD in 1 day
4.9 (34 reviews)
5.2
5.2
User Avatar
Hello Mr I'm a Scripter expert I can help you with this task. I would like to know more about this project. I could probably use AutoIt or another lenguage to fix your corrent issue. Contact me by chat to get more information Best Regards
$222 USD in 10 days
4.9 (36 reviews)
5.1
5.1
User Avatar
Hi, I am VBA Developer...Expertised in VBA Macros & Web Scraping I can Scrape Any Website..either static or dynamic also i will finish any web scraping & Excel macro task in 1day only & also experianced in ecommerce wordpress sites developement Experianced in python programming.... Thankyou
$43 USD in 1 day
4.9 (49 reviews)
4.9
4.9
User Avatar
I have 12 years experience and 100% satisfaction is guaranteed.
$250 USD in 7 days
5.0 (18 reviews)
4.0
4.0
User Avatar
Hi, I can finish the required project please contact me for details thanks a lot .....................................
$177 USD in 3 days
5.0 (2 reviews)
3.3
3.3
User Avatar
Hello I have done similar to this project before. I am an effective web developer and can deliver exactly deadlines. Thank you for your time and consideration. I look forward to hearing from you. Good luck.
$155 USD in 3 days
5.0 (1 review)
2.1
2.1
User Avatar
I'm expert in Excel. Certainly I can help you in this project in a short time and with an excellent quality.
$250 USD in 10 days
5.0 (1 review)
1.1
1.1
User Avatar
Hi.. How are you? I saw your description carefully your project. Owing to my rich experience in VBA and macro , i can say i can do this perfectly. I have many top skills like Data Processing, Excel, Visual Basic, Visual Basic for Apps, Windows Desktop and so on. If you would like to choos me , i do my best. Thanks.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ever considered SQL express? Would love to know what benefit excel provides and the output you require. Aim to help you future proof. Relevant Skills and Experience Over 15 years experience in IT I myself once wrote macros in excel. There are other easier and more deployable options, but would like some further context.
$144 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, As I'm currently helping enterprise clients in accomplishing their goals for better productivity, operational insights and strategic goals, I'm in for new opportunities where I can contribute for other company's success. For the particular skills that you may have a requirement, what I can offer is on the likes of operational reporting, business intelligence, data privacy compliance and project management. Here's the summary of what I can further offer: • Effective team member with full understanding of the underwriting workflow processes and client needs. • Technically-savvy with analytical insight, effective project management, outstanding relationship building, training and presentation skills. • Well-versed in using Power BI and Excel/VBA to create highly engaging dashboards and reports. • Highly organized and detail-oriented with 15 years of progressive experience in the IT/BPO field.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam: I offer to make your macro Excel VBA. I am working in Windows 10 and already correct algorithm to avoid memory leaks. No problem to test one per one. I will deliver: macro revised and corrected in record management to avoid leaks. As the specified modifications. Support post-sales guaranteed. If necessary I will need to test your WIndows 10 to see logs from Event Viewer Time aprox.: 2 to 5 days. Full services: programming, PM, technical translation/writing. Expertise since 90s. Software architecture and engineering. Personalized service, full back-end and front-end programming. Background Samples at my portfolio tsftportfolio wordpress com, Office apps VBA, ERPs, scripting, ETL, DBA, SysAdmin, Wordpress, Python, .NET, Clarion, PHP, XP, MVC, ETL, Crawling, business systems are part of my skills and experience, including UML, BPMN as well as GIMP for graphic design. Remote Work -Online distance working -Online collaboration: easier system for you. Dashboard for tracking. -Sheduled meeting for requirements accordance. -Daily communication automatized workflow. -Extreme programming, Agile methods. Kind regards.
$250 USD in 3 days
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
McMinnville, United States
5.0
7
Member since Sep 20, 2013

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.