Freelance projects

Freelance projects

Writing the VBA Excel

Desktop Apps — incorrectly specified categories?

34 USD

Client's review of cooperation with Vladimir Sokolets

Writing the VBA Excel

34 USD

Vladimir works very quickly and can offer solutions to the assigned task. Everything is done in the best way and much faster than the agreed deadline. I strongly recommend it to everyone!

5.0

Anton T.

Reciprocal Feedback

3 December 2021

Freelancer's review of cooperation with Anton T.

Writing the VBA Excel

34 USD

A great customer. Adequacy of all parameters. I recommend it.

5.0

Project translated automatically. Log in or register, to view the original Description of the macro: There is the Advertising Department, it every month expands on the network folder of the contract with the counterparts in pdf format with the obligatory condition that the file name will be THE EXACT NAME of the counterpart (all names and codes are indicated on the separate partner tab in the excel file: Company 1 + code, Company 2 + code, etc.)But the Advertising Department keeps them not structurally - as it came and anywhere in any folder.And if you need to find a contract, it will be very difficult.There is a Department of Finance that must find these contracts and save them separately by the method: all contracts and documents in the pdf format, you need to save in a separate folder (the name of the folder will all be equal to the tax number of the company code).The algorithm of the macro: 1) the user opens the file; 2) indicates the way to the network folder where you need to search for the necessary documents in pdf format; 3) Macros shall draw all the documents found in the pdf format; 4) Then the user selects a local or network folder - where you will need to copy all the found documents according to the criteria: - A file found that contains the exact name of the counterparty (according to the partners tab), this file will need to be saved in the company's tax code that corresponds to the company on the partners tab.If the counterparty code folder does not exist, you will need to create the counterparty number folder automatically.If the found files do not contain the exact counterparty name according to the partners tab, then they must be displayed separately or lighted the cell so that the user can move them manually.5) This macro will be launched several times a month, and therefore this feature will copy and supplement the contract folder.I need a dop.The option: If this file was found last time, then the macro must miss it (if this option will be difficult in implementation, then you can simply replace all contracts).All found and copied files to be saved on a separate tab to record all previously saved documents: name, date.In the Excel file with a macro, where points 1.2,3 are already implemented.You need to update the file or create it from zero.If you think something can be simplified or changed, the suggestions are welcome.If any functions are complex, and they can be done manually (e.g. create all maps with counterparts codes in advance, not more than 150 pieces of them).Write it too.by Dedline: 06.12.2021, Monday, 12:00 The cost: Call the fixed cost for performance. The cost of the hour and their number.

Proposals 4 Discussions 2

Vladimir G.

72 0

Projects 62
Rating -
Rating 1 479

Budget: 1000 UAH Deadline: 5 days

Hello to Anton.
You can make the VBA program on Access, the file table can be exported to Excel easily if you need it.
Just there are tables, and you need to process and store lists, Access is more suitable.
You can talk to LS.

Vladislav Chahur

3 0

Projects 3
Rating -
Rating 124

Budget: 1500 UAH Deadline: 3 days

Ready to fulfill your task. Experience in solving such tasks.

Vladimir Sokolets

Winning proposal

28 2

Projects 25
Rating -
Rating 567

Budget: 1500 UAH Deadline: 3 days

Almost everything you describe can be automated. There are a few questions to be clarified, but this can be done in the process of work. Write and discuss.

Anton T.
Kharkiv, Ukraine

Projects 3
Rating -
Rating 96

Writing the VBA Excel

Client's review of cooperation with Vladimir Sokolets

Writing the VBA Excel

5.0

Anton T.

Freelancer's review of cooperation with Anton T.

Writing the VBA Excel

5.0

Vladimir Sokolets

Vladimir G.

Vladislav Chahur

Vladimir Sokolets

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Desktop Apps

Linux mentor

Microsoft Power Platform/Power App