Excel 2016 VBA Macro to report folder and files paths.

$10-30 USD

Fullført

Lagt ut

nesten 5 år siden

$10-30 USD

Betalt ved levering

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.

Prosjekt-ID: 20760370

Om prosjektet

5 forslag

Eksternt prosjekt

Aktiv 5 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@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 om 1 dag

4,8

(89 omtaler)

5,7

5 frilansere byr i gjennomsnitt $46 USD for denne jobben

@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 om 3 dager

4,9

(43 omtaler)

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 om 1 dag

5,0

(1 omtale)

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 om 7 dager

0,0

(0 omtaler)

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 om 3 dager