Excel 2016 VBA Macro to report folder and files paths.

$10-30 USD

Imekamilika

Imechapishwa

almost 5 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

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.

Kitambulisho cha mradi: 20760370

Kuhusu mradi

5 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@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 ndani ya siku 1

4.8

(89 hakiki)

5.7

5 wafanyakazi huru wana zabuni kwa wastani $46 USD kwa kazi hii

@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 ndani ya siku 3

4.9

(43 hakiki)

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 ndani ya siku 1

5.0

(1 hakiki)

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 ndani ya siku 7

0.0

(0 hakiki)

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 ndani ya siku 3