Get Files information in Excel Worksheet from a Folder|| File System Object || VBA Automation

[@RaviKumar-pr2by]

Excellent Sir..Thanks U Solve it..

[@PKAnExcelExpert]

Thanks🙏

[@dflychem]

Excellent! Straightforward explanation.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mehboom7495]

I am very happy to conect u sir really i am new in this chanel nut really amazing sirrrr...super thankyou sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@realgoodscoobysnacks]

@@PKAnExcelExpert How can I put an Excel VBA macro together that can go through all Word docs in a folder and pull document properties. Is it something like how you set the macro up in this video. I have been struggling with this problem. I think it may require BuiltinDocumentProperties code. but I don't know how to employ it to go into a word and copy a doc property such as "Total editing time" from many word documents and put it into a report in excel like you did in this video. Please help if you can. Thanks

[@rajeshmuthu9881]

Really it is very useful. Thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alaaahmed6050]

Excellent Video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@FR-bn5fd]

Thank you very much!

[@abdulsafwan711]

Is that possible if folderpath is more than 254 characters.?

[@MohammadMohiuddin-bd]

Sir, thank you for create this video. Could you please create a video, how import data from excel file with some specific column & data.

[@sakibtalukder-6890]

Thank You Sir

[@PKAnExcelExpert]

Most welcome

[@rockyadam09]

Thanks this is very useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ibm98852]

Awesome keep rocking

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DurgeshYadav-gu6tt]

sir can we get the duration of a list of .wav or .mp3 files into ecel through VBA

[@dattatryakorde9584]

Sir can we take file path name or object names

[@aguarunaagua]

Excelente

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Twenty-rl5lc]

It's very useful info bro I have small , same macro can we get inside of file how many rows data.

[@charlesdawnbeltran9603]

If a I have pdf files inside a folder and I want to know what are pdf versions of those file. Is it possible as well? Thank you

[@abcd2-k4s]

Sir with command button I want to PDF Excel files not macro

[@mkradeshaha3365]

Sir how to create excel range to jpg vba button click file save multi image

[@MohAboAbdo]

Thanks ... Thanks ... Thanks ...

[@PKAnExcelExpert]

Thanks for watching

[@ashishbhatt06]

How can we add Authors name of file ?

[@nirmaysawant1234]

Hii PK ! I tried this code and faced Run Time error 91 on this part of the code Set fo = fso.GetFolder(sh.Range("H1").Value) kindly help resolving this issue

[@archanarozini6045]

That means he has saved the file location in his worksheet at location "H1".

[@manikandaprabhu4415]

Hi Sir! Thank you so much! I want to know how to merge excel files ! Can you please post video on this

[@mayanksakaria6238]

Hi sir, Your videos are really awesome, I have learned many things from that. This is regards of a project that i am making in my company about automating letters using excel.. For example : if there is a letter template given on certain loaction and i need excel to open that and amend the required fills or empyt fills and create a letter in ms word.. Please help. Awaiting your prompt reponse

[@mrtechguru341]

Nice. Bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ranjithkgupta1632]

Sir I have a task in my office, can you help me. There are few hundreds of Excel files with different Mobile numbers in various folders. If I enter a Mobile number in Search box in start menu then it will display a list of Excel files in which mobile number is there. Now my boss wants to prepare a Excel sheet where if he enters one or multiple mobile numbers then in next sheet all the File Names with its location in Computer should get updated in which those Mobile numbers are there.... PLEASE LET ME KNOW OR TEACH ME HOW IT CAN BE DONE..

[@PKAnExcelExpert]

Hi Rinku, I will definitely try to make such video very soon.

[@ranjithkgupta1632]

Thank you so much Sir for considering my query. I will be waiting for the result. If that works then it's a promise I will do something to make you happy, like donation or doing something for needy.😊

[@kirankapruwan8892]

Very informative video. But one thing I can't understand. New keyword used for declaring object for fso. But not for folders and files. What is the significance of new keyword and why not used for folders and files objects.

[@davidhudson2497]

Very useful, what would I need to add to the code to include the file length. As in Name, Type, Length? Thank you.

[@accu96]

length? what's that?

[@davidhudson2497]

@@accu96 Length = the amount of hours: Minutes: seconds . As in the File header.. Name, Size, Length, Date, Type

[@accu96]

@@davidhudson2497 You mean the playback time length? In a playable file, like a music or a video clip file.

[@davidhudson2497]

@@accu96 Yes, but filename, file type, length (Time) etc. Detail about the file or files.

[@accu96]

@@davidhudson2497 As far as I understand, it's not possible. You can refer to the list of the properties.

[@anilkumar-zf8rp]

please upload the vidios in Hindi. or give links.