Ouvert

Excel VBA & macro scripting for Windows 1O environment

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]

Compétences : Traitement de Données, Excel, Visual Basic, Visual Basic pour les apps , Bureau Windows

en voir plus : excel vba macro paste adjacent column, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell, excel vba macro charts, running excel vba macro sql server, excel vba macro scripter, download historical stock data excel vba macro, excel vba macro copy columns data, convert excel vba macro standalone application, excel vba macro download yahoo stock data, excel vba macro worksheet name, excel vba stand alone windows application, select column copy excel vba macro, excel vba macro freelance

Concernant l'employeur :
( 7 commentaires ) McMinnville, United States

Nº du projet : #17550009

22 freelance font une offre moyenne de $178 pour ce travail

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (go Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(606 Commentaires)
8.3
schoudhary1553

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 D Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(274 Commentaires)
7.5
SBITServices

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 i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(356 Commentaires)
7.3
abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(65 Commentaires)
5.6
usmanhassan123

PhD in computer science having seven years of experience in Excel development.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(38 Commentaires)
5.7
TechnoGuruu

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)
5.1
royalcalif

Let me review the spread sheet with data and your preferable format as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(72 Commentaires)
5.3
AlexandrUKR

i can send first version for your test within 2-4 days, please clarify possible next steps

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(20 Commentaires)
5.1
dany3j

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 inf Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(15 Commentaires)
4.0
rIbrarahmed

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)
3.9
Mfaisalshahzad00

I have 12 years experience and 100% satisfaction is guaranteed.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(13 Commentaires)
3.6
alhassanlatif

Hi, I can finish the required project please contact me for details thanks a lot .....................................

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
3.1
superbpartner

Hi,sir. I am super interested in your project - 'Excel VBA & macro scripting for Windows 1O environment' :) I believe that my 12+ years of experience in development makes me highly qualified for this project. I'm sure Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(6 Commentaires)
2.8
dataexplorer

"Hello, I am ready to work with Excel VBA & macro scripting for Windows 1O environment. I would love to chat with you to know more details about your project . Price Negotiable. Normally we collect 80-90% personal em Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
2.2
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
jcssoares

I'm expert in Excel. Certainly I can help you in this project in a short time and with an excellent quality.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
tsft

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 r Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
thinkbluesystems

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
drgold03

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0