Excel 2016 VBA Macro to report folder and files paths.

$10-30 USD

Completed

Posted

almost 5 years ago

$10-30 USD

Paid on delivery

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.

Project ID: 20760370

About the project

5 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@vsprybhanu

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 example file and understood. I have developed similar macro that accessed folder, subfolder and files. I am experienced Data Analyst and Macro Developer and have done mostly Excel VBA Programming jobs. So, can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra

$30 USD in 1 day

4.8

(89 reviews)

5.7

5 freelancers are bidding on average $46 USD for this job

@narsim3128

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, scripting,excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope Looking forward to hear from you. Regards

$100 USD in 3 days

4.9

(43 reviews)

5.7

@enghamza12

****** 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 ⭐⭐⭐ ✅DSP and Image Processing ✅Face Detection / Recognition / Classification & Object Tracking ✅ STATISTICS, R, Probability ✅Mathematics: GA, NN, CNN, Machine & Deep Learning ✅Physics: Mechanics, Nuclear physcis, electronics, Optics. ✅Signal processing: FFT/DSP, Computer Vision ✅Mechanics: FEA/CAD/CAM, Robotics, CFD ★★★ Software tools I am using: ★★★ ✅OpenCV, OpenGL ✅Matlab & SIMULINK /Simulation ✅Solidworks, Ansys Fluent, Solidworks ✅Androied,JacaFx,Larval @ If you keep in touch with me, you will be satisfied with my best result! ❤Thanks❤

$50 USD in 1 day

5.0

(1 review)

1.7

@Mehadi0721

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 I am the best person for your project. With respectfully Mehadi Hasan

$20 USD in 7 days

0.0

(0 reviews)

0.0

@pamitl0432

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 sheet, excel, PDF, word, Photoshop, Excel Vba and research. your work will be finished on time and as per your specifications.

$30 USD in 3 days