Excel 2016 VBA Macro to report folder and files paths.

Hi, I need a vba 2016 macro that allow me to select a folder (I use Windows 10) and report all folders, subfolders and files inside that folder, also, report the results in 3 different sheets(tabs):

Sheet "Paths"

Column "A": Full path to the folder (list all folders and subfolders)

Column "B": Path starting from user selected folder (list all folders and subfolders)

Column "C": Filename (including its extension)

Column "D": Extension only

Sheet "Exceeds"

Column "A": (based on sheet "Paths" column "A")

Path exceeds 215 chrs long

Column "B": (based on sheet "Paths" column "D")

Filename exceeds 36 chrs long

Column "C": (based on sheet "Paths" column "C")

Full path including filename with extension exceeds 255 chrs long.

Sheet "SpecialCHRs":

Files and folders that contains one of the following chrs (in red color):

á, é, í, ó, ú, ñ, °, |, ¬, ^

The result I am expecting should come as a VBA macro in excel 2016 spreadsheet.

It should support:

-Spanish characters (accent, ñ, á, etc.) maybe just using utf-8 fix this issue.

-OneDrive and Sharepoint folders (I think it is supported by default by windows)

Attached is an example of what I want.

Skills: Excel, Visual Basic, Excel VBA, Excel Macros

See more: vba macro excel unicode, excel vba macro paste adjacent column, vba macro generate report excel word, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel 2003 paste clipboard vba macro excel, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel word vba macro example, select printer excel using vba macro, excel macro browse folder import files list, cut files folder vba macro, excel based vba search music files folder arrange, excel pivot vba macro jobs, convert excel formulas vba macro, excel copy vba macro, excel 2007 vba macro programming

About the Employer:
( 26 reviews ) Santiago, Chile

Project ID: #20760370

Awarded to:


Hi, I can develop a macro to select specific folder (using open dialog box). Then macro will extract file name with path and extension from every subfolder and show according to your instructions. I saw attached exam More

$30 USD in 1 day
(75 Reviews)

9 freelancers are bidding on average $38 for this job


With respect to this project I would like to present myself as a candidate for your consideration. I have more than 10 years of IT experience. I have successfully completed few projects which involved Programming, scri More

$100 USD in 3 days
(38 Reviews)

( ͡ᵔ ͜ʖ ͡ᵔ ) Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Here are projects I have done recently using Excel VBA and formulas. ==== More

$20 USD in 1 day
(8 Reviews)

Dear sir. I have just read your requirements carefully. I am very interested in your project. Although I am new in freelancer, I have more than 8 years of experiences in VB & VBA. I'm an expert in Excel, algorithm and More

$20 USD in 1 day
(1 Review)

Dear Project manager, I have read your project description carefully. I have working experience on projects that require skills. I am interested to do your Job and will delivery of project well advance in time. I think More

$20 USD in 7 days
(0 Reviews)

****** ma shaa Allah ****** I'm are professionals in ✔️MATHEMATICS, ✔️MATLAB, ✔️SOLIDWORKS, ✔️ANSYS FLUENT, ✔️PHYSICS, ✔️COMSOL ✔️PDF to Doc or all format and versa I am a boss. ⭐⭐⭐ Major skills and Qualifications ⭐⭐ More

$50 USD in 1 day
(0 Reviews)

Dear Sir, I'm a Web Developer from Russian who is specialized in VBA. I have read your description with great interest. I have 6+ years of experience in Excel and VBA. if you hire me, i could satisfy. I hope you award More

$20 USD in 7 days
(0 Reviews)

***************Hi Master*************** I saw your requirements in detail. I have the career of 5 years' study of C++ and C# for the ACM_ICPC competition. Even If you don't hire me, I can give you my opinion related to More

$50 USD in 1 day
(0 Reviews)

Hi I have read the job description and I am very confident that can delivered the kind of work output that you like in the given time. I'm a data entry expert with over 2 yrs working experience in data entry, spread More

$30 USD in 3 days
(0 Reviews)