Закрыт

VBA + PHP excel

Hi,

I have an excel spreadsheet that works as a software for company valuation. This software should be accessed only by those clients that are active in our database. So, what I need is the following:

1) Once you open the excel, all the spreadsheets should be hidden, only showing the first one with a form for the client to type his/her username and password.

2) Then, the VBA should connect to a SQL and validate: that the user exists, the credentials (username and password) are correct, the current day is not greater than the expiration date of the licence and the number of active licences is lower than the total number of licence that the client purchased.

3) if 2 is OK, then increase the number of active licences in the SQL by one.

4) Once the VBA allows the user to enter, display only four sheets (these sheets will always have the same name). In one sheet, lets call it Dashboard, the client will be able to type the ticker of a company (lets suppose: AAPL), then the VBA should download and paste in the remaining three sheets three files that we have hosted in our VPS... these files will be hosted always in the same folder and the name is [login to view URL]

Thats it.

Once the client closes the workbook, the VBA should connect to the DB and decrease the number of active licences by one.

Навыки: PHP, Excel, Visual Basic, Архитектура ПО, MySQL

О клиенте:
( 23 отзыв(-а, -ов) ) Madrid, Spain

ID проекта: #32639279

7 фрилансеров(-а) готовы выполнить эту работу в среднем за €38

(125 отзывов(-а))
6.0
varimaxanalytic

Hello, I am professional freelancer with a Master's degree in Data analytics making me a suitable person for your project. I have more than 8 years of professional experience in Data analysis. Besides, I have skills i Больше

€25 EUR за 1 день
(3 отзывов(-а))
3.6
(7 отзывов(-а))
3.6
Rugues

Hi, I am an expert in VBA, excel, macros, programming and ensure that the objective is achieved. I have read the project description and will discuss on how it would be achieved if contacted. I am readily available for Больше

€19 EUR за 7 дней(-я)
(15 отзывов(-а))
4.5
aruls1962

What you want can be achieved by google sheets. I am an engineer with a lot of experience in the manufacturing industry. I have been developing systems from the ground up in Google Sheets for the last 7 years. You Больше

€100 EUR за 3 дней(-я)
(7 отзывов(-а))
3.4
pravash13hassy

I'm confident that I will thrive in this position, seeing that I have all the skills that you are looking for.

€25 EUR за 5 дней(-я)
(0 отзывов(-а))
0.0
haziqsiddiq

Hello, my name is Haziq Siddiq from Malaysia. After carefully reading all the requirements, I think I'm a suitable candidate to do this job because I'm an Investment Management student. Even though I didn't have workin Больше

€19 EUR за 7 дней(-я)
(0 отзывов(-а))
0.0