24FreelanceFreelance marketplace that never sleeps
Response period is over

Write a macro for R7-Office

383 views 0 responses#40655
BudgetNegotiable
FormatOne-time projectno prepayment
PaymentBank transfer, E-money
Responses acceptedResponse period is overuntil 17.12.2024
Responses0category average: 0.3
Views38312 in 14 days

Project description

Translated
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)
Software development Bank transfer, E-money

SafeDeal Escrow Protection

Payora SafeDeal Astrina Shield Verified

Funds are locked in Payora USDT (TRC-20) escrow and released to the freelancer only after delivery approval.

24
Twenty · tip

How to write a response that gets picked

  • Open with the client’s task, not with a story about yourself.
  • Link one or two similar works from your portfolio.
  • Name a price and a deadline — and what exactly they include.
  • Ask one clarifying question: it starts the conversation.

Responses 0

Response texts are visible only to the client.

Same category

Similar projects

All projects in the category
Warehouse inventory app with barcode scanner

Warehouse inventory app with barcode scanner

Looking for a developer to build a mobile warehouse inventory app with barcode scanning, receiving, dispatch, stocktake and reports.

Software development24.09.20260236
0responses
Website accessibility audit against WCAG

Website accessibility audit against WCAG

We need an independent WCAG accessibility audit of our website: keyboard, contrast, screen readers and a clear report with fixes.

Software development24.09.20260236
0responses
Good to know
How do I respond to this project?

Log in as a freelancer, describe how you will solve the task, name your price and deadline. The client reads responses and starts a dialogue with the best ones.

Who can see my response?

Only the client who posted the project and you. Other freelancers do not see your text or price.

Where can I find similar work?

New projects in “Software development” appear every day. All projects in the category

What this page answers