Excel 2016 VBA Macro to report folder and files paths.

$10-30 USD

Đã hoàn thành

Đã đăng vào

hơn 4 năm trước

$10-30 USD

Thanh toán khi bàn giao

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.

Mã dự án: 20760370

Về dự án

5 đề xuất

Dự án từ xa

Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@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 trong 1 ngày

4,8

(89 nhận xét)

5,7

5 freelancer chào giá trung bình $46 USD cho công việc này

@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 trong 3 ngày

4,9

(43 nhận xét)

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 trong 1 ngày

5,0

(1 nhận xét)

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 trong 7 ngày

0,0

(0 nhận xét)

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 trong 3 ngày