@@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
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
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
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.
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..
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.😊
Excellent Sir..Thanks U Solve it..
Thanks🙏
Sir, thank you for create this video. Could you please create a video, how import data from excel file with some specific column & data.
Excellent! Straightforward explanation.
Thanks for your valuable feedback
Really it is very useful. Thank you so much
Thanks for your valuable feedback
I am very happy to conect u sir really i am new in this chanel nut really amazing sirrrr...super thankyou sir
Thanks for your valuable feedback
@@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
It's very useful info bro
I have small , same macro can we get inside of file how many rows data.
Thank you very much!
Is that possible if folderpath is more than 254 characters.?
Thank You Sir
Most welcome
Thanks this is very useful
Thanks for your valuable feedback
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
Excellent Video
Thanks for your valuable feedback
sir can we get the duration of a list of .wav or .mp3 files into ecel through VBA
how to get the visdeo length with this progarm. thanks very much
how to get the video length with this progarm. thanks very much
Excelente
Thanks for your valuable feedback
Awesome keep rocking
Thanks for your valuable feedback
Hi Sir! Thank you so much! I want to know how to merge excel files ! Can you please post video on this
Sir can we take file path name or object names
Sir how to create excel range to jpg vba button click file save multi image
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
Thanks ... Thanks ... Thanks ...
Thanks for watching
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
That means he has saved the file location in his worksheet at location "H1".
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.
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..
Hi Rinku, I will definitely try to make such video very soon.
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.😊
Sir with command button I want to PDF Excel files not macro
Very useful, what would I need to add to the code to include the file length. As in Name, Type, Length? Thank you.
length? what's that?
@@accu96 Length = the amount of hours: Minutes: seconds . As in the File header.. Name, Size, Length, Date, Type
@@davidhudson2497 You mean the playback time length? In a playable file, like a music or a video clip file.
@@accu96 Yes, but filename, file type, length (Time) etc. Detail about the file or files.
@@davidhudson2497 As far as I understand, it's not possible. You can refer to the list of the properties.
Nice. Bro
Thanks for your valuable feedback
How can we add Authors name of file ?
please upload the vidios in Hindi. or give links.