Writing the VBA Excel
33 USD 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.
Applications 1
Client's review of cooperation with Vladimir Sokolets
Writing the VBA ExcelVladimir 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!
Freelancer's review of cooperation with Anton T.
Writing the VBA ExcelA great customer. Adequacy of all parameters. I recommend it.
-
5 days22 USD
1479 72 0 5 days22 USD
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.
-
3 days33 USD
124 3 0 3 days33 USD
Ready to fulfill your task. Experience in solving such tasks.
-
Winning proposal3 days33 USD
567 28 2 Winning proposal3 days33 USD
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.
-
Добрый день. Такой вопрос , возможно вам подойдет реализация на питоне или каком нибудь другом языке ??
-
Добрый!
Нет, только Excel, потому что этот макрос на корпоративных компьютерах будет работать
-
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 2 days 4 hours back ∙ 9 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 2 days 15 hours back ∙ 5 proposals |
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 10 days 5 hours back ∙ 10 proposals |
Kharkiv