1
Юрий
no recommendations
no complaints
Project title: Write a macro for R7-Office
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer, Electronic money
Acceptance of requests: from 2024-12-07 until 2024-12-17
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer, Electronic money
Acceptance of requests: from 2024-12-07 until 2024-12-17
Project description:
The services of a macros writing specialist are required. Macros with basic functions under the ASTRA LINUX " R7-office xlsx are required:
1. Create folders on both the PC and the local network. There is an xlsx file that lists the names of folders, let’s say in the column "B". In the cell "A1" indicates the path to the folder in which you need to create folders according to the names in the file.
2. Copy folders, similar to task 1 only in cell A2, indicates the way where you need to copy folders.
3. Removing folders, similar to task 1
4. Formation of hyperlinks. Similar to task 1, in the column "C" you need a hyperlink with the text "Go" and "quot;".
5. There are 2 xlsx files in the column "A" unique numbers, but in the files these numbers are randomly located (do not match the lines). Only 1 is open. It is necessary for a macro to open the second file, find a string with a unique number in the second one by a unique number of 1 file and copy the data from the cell in the column "D"" to the cell "D"" of the first book, close the second file without saving.
6. There is a file with folder addresses similar to task 1, you need to display all files located in folders on sheet 2. (number in order, full file path, folder name, file name with extension, file name without extension, extension name, file hyperlink to file, folder hyperlink, file name, file name)
The services of a macros writing specialist are required. Macros with basic functions under the ASTRA LINUX " R7-office xlsx are required:
1. Create folders on both the PC and the local network. There is an xlsx file that lists the names of folders, let’s say in the column "B". In the cell "A1" indicates the path to the folder in which you need to create folders according to the names in the file.
2. Copy folders, similar to task 1 only in cell A2, indicates the way where you need to copy folders.
3. Removing folders, similar to task 1
4. Formation of hyperlinks. Similar to task 1, in the column "C" you need a hyperlink with the text "Go" and "quot;".
5. There are 2 xlsx files in the column "A" unique numbers, but in the files these numbers are randomly located (do not match the lines). Only 1 is open. It is necessary for a macro to open the second file, find a string with a unique number in the second one by a unique number of 1 file and copy the data from the cell in the column "D"" to the cell "D"" of the first book, close the second file without saving.
6. There is a file with folder addresses similar to task 1, you need to display all files located in folders on sheet 2. (number in order, full file path, folder name, file name with extension, file name without extension, extension name, file hyperlink to file, folder hyperlink, file name, file name)
