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.
Bu iş için 38 freelancer ortalamada $71 teklif veriyor
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day
Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project Daha Fazla
I am postgraduate with more than 7 years of experience in advance excel based templates and tools, MIS reporting, business automation, dynamic dashboards, VBA, Excel macros, financial modeling and data processing. Plea Daha Fazla
Hi Sir, I went through your requirement. I understand at high level Need to analyze files in folder /subfolders and produce some output. This is fairly straight requirement. I can complete this job within hour or two. Daha Fazla
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
Hi there, Give through your requirements and clearly understood what you need. I am a Microsoft Certified Professional in Excel and VBA as an Expert Kindly go through my profile. Awaiting your response and samples Daha Fazla
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.
Hi there, I am really interested in working on your project. I will design and develop a macro that will run through you folders and capture information therein. I am available to create a macro for you that will do th Daha Fazla