Find Jobs
Hire Freelancers

VBA / Access / CSV professional wanted to create tool

€8-30 EUR

Закрито
Опублікований over 5 years ago

€8-30 EUR

Оплачується при отриманні
Here are a few details: We are an online trade and handle all business processes through a merchandise management system. I regularly pull the statistics as a CSV file from the system. This includes the following files: - Current stock (CSV) -Sales of the last 14 days (CSV) -Article Database (EXCEL) The first two CSV files I read about the query function in Excel. I then made a little "program", if you want to call it that, tinkered. I also worked a bit with VBA. However, the tool is very limited. The queried files must always have the same file path and must not be named differently. The files must not deviate from the internal structure, that is lines and columns must always have the same format. I use the tool to get the requisite order quantity for our various stock items, of which we have many. I then pass on this list to our supplier. Why am I doing this? Of course you can also carry out orders on minimum stocks, which can be set in WaWi. But because of our large number of different items, I also need to know how much I have to reorder from each item. This is not calculated by our WaWi. The whole thing should now look a little more professional and above all be universally applicable. I would like to Select files from any location on your hard disk and let them analyze. Also our article database is currently an Excel file. It now leads over 1000 lines and for such Excel is well known not designed. Access would then come into play here. Later, I would also like to have the income statement, etc. create over the program. It would be nice if you can integrate that later or maybe already. If necessary, I can send everything I can the "program" also like in its components. It would be best, but once everything to discuss locally, so I can show how I currently rule everything. But this would also be possible via Skype / Teamviewer. But it would be nice if I knew beforehand how much the effort will be and what price you can imagine. I am looking forward to your reply.
ID проекту: 17535005

Про проект

16 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
16 фрілансерів(-и) готові виконати цю роботу у середньому за €75 EUR
Аватарка користувача
Hello, I have the good knowledge of VBA / Access / CSV professional wanted to create tool. I have more than 5 years of experience in Excel, Microsoft Access, Software Architecture, Visual Basic, Visual Basic for Apps. I have reviewed your job and can deliver you the job with 100% satisfaction. Please ping me for more discussion.
€160 EUR за 2 дні(-в)
4,9 (620 відгуки(-ів))
8,6
8,6
Аватарка користувача
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
€19 EUR за 3 дні(-в)
4,8 (99 відгуки(-ів))
7,4
7,4
Аватарка користувача
I have read your description. I believe I can assist in your project. My passion is building Custom Access ands Excel Databases. I have built well over 300 custom databases in the past 19 years. I have taken all classes from beginner to expert 97 to 2013 in access and excel. I can send working samples on request. Some of the databases I have built include Production, Inventory, Scheduling, time-clock, Book-Keeping, facilities management, and many custom databases I am bidding on your project because I feel my experience and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you. What you get if you allow me to do your project. The Database to your vision. I will create the database and continue to change upon your input until it is what you in vision. I will offer lifetime support for the database; I will give all my contact information if chosen to complete your Project. I if there are any bugs or issues to the original Database I will fix free of charge. Thank you for your time.
€34 EUR за 40 дні(-в)
4,8 (44 відгуки(-ів))
6,7
6,7
Аватарка користувача
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current project via Ms Access for $750 USD during 2 weeks - very professionally and on time- only during coding I'll need each day communication with you. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
€23 EUR за 1 день
4,8 (86 відгуки(-ів))
6,6
6,6
Аватарка користувача
I have excellent command on MS Excel and MS Access VBA. I have completed complex projects in both before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
€80 EUR за 2 дні(-в)
4,9 (104 відгуки(-ів))
6,2
6,2
Аватарка користувача
Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I'd like more details so that I can give you my final timeframe and quote. I have done similar assignments previously, so check my profile for details. I'm looking forward to hearing from you. Regards,
€34 EUR за 1 день
4,9 (72 відгуки(-ів))
5,9
5,9
Аватарка користувача
- Based on the two CSV files CUrrent Stock, Sales for the last 14 days and the logic that needs to identify the the stock that needs to be reordered from the respective supplier can be generated. - Solution could be built on Excel or MS Access based on the complete understanding. - Have done very complex solutions in Excel and also in MS Access - Am not sure how WaWi works but we can have a threshold value set, for each item or make it generic so that at any point of time if the stock reaches the reorder level then we can list all those itmes for the day. - Have it segreggated to be sent to respective supplier. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
€160 EUR за 4 дні(-в)
4,6 (54 відгуки(-ів))
6,1
6,1
Аватарка користувача
Hi, I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further. Thanks, Marlou
€34 EUR за 5 дні(-в)
2,9 (8 відгуки(-ів))
4,3
4,3
Аватарка користувача
Hello, I'm VB expert, I think you will be satisfied, we can discuss eveything via Skype for free of course.
€29 EUR за 1 день
5,0 (1 відгук)
2,4
2,4
Аватарка користувача
Hi Sir I'm a new freelancer. As such I can do the task at minimal cost or even for free as I'm looking only for positive feedback. Please let me know your requirements Regards,
€8 EUR за 1 день
5,0 (8 відгуки(-ів))
2,0
2,0

Про клієнта

Прапор GERMANY
Söhrewald, Germany
5,0
14
Спосіб оплати верифіковано
На сайті з груд. 9, 2017

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.