We have a folder structure with around 20-30 subfolders containing numerous excel files and jpgs in each.
The task is to analyze the folder content based on folder name (and parts thereof), number of files, change date, and data within the files. 90% is a direct cell value, but some info needs to be calculated (like number of characters in a certain cell range).
The VBA should go through the folder structure and write some 10 – 15 key info in a separate Excel file (in a table structure). The structure is user and day, i.e. we need to now the number of certain files meeting certain criteria at a given date.
On a new run eg 2 days later, any changes of users to the files in the folder structure should generate an updated table with new key data.
More detailed instructions are issued to the awarded party.
Budget is 50 to 70 USD.
We will select based on relevant experience in the field and number of reviews.
38 freelancers are bidding on average $71 for this job
Hi Need more details , like ..write some 10 – 15 key ...exact meaning. I can do this via Ms Access with Excel automation. I can detail more in private chat. Best, Zurab
I can help you here, but I recommend using Python for this, not VBA. I will write you a script that will run automatically and do exactly what you are wanting. Let me know if you would like to discuss further.