nice simple code that executes well, suggestion would be to remove any formatting from source document as a elements such as hyperlinks can break the code execution.
Thank you so much, ¡Brilliant!. Anyway, please, could it be possible that the text format (from Word) will be transferred to the Excel? And if possible, could you teach the code to be added to the code in this video? Tank you very much. Cheers, Alberto
Sorry for spelling mistake. Vlookup when data is in filter. Using match for headers. Ex: filter completed when we have to lookup for pending. But the columns are not in sequence.
Hello sir, I’m running into an issue here. When I ran the code for the word document, I could only run for the first page, my results from the second page is not showing up. Also my word document contains text that I want to search for and copy to excel. Is there a video of yours I could look at for more detail? Thanks for all your help in advance
hi sir. I have a case. with a worksheet of multiple columns. each data in the column may refer to another sheets on a lan or share point are which need to be validated second. if one cell value is given. based on cell value next column to be populated based on validation from different sheet. I may have 100 plus reference sheets where data to be validated. is that a possible case. can you help me sir
Hi Sir. I am running into an error while running this code. when I run the code first time it works fine but when I run it for the second time it throws the error on the below line set cDoc=ActiveDocument the error is read as "the remote server machine does not exist or unavailable." Please advise how to remove this error.
Hello Dinesh, your video is amazing and underrated! 👍
Thank you sir,
This code running but,
Upgrade this code with
Add [ Text, image(png, jpg), maths equation, Entry button, etc ]
❤
nice simple code that executes well, suggestion would be to remove any formatting from source document as a elements such as hyperlinks can break the code execution.
Excellent video sir! saved hrs of my life! I
wish to extract highlighted data instead of data in brackets please guide!
Glad it helped. This link will guide: www.exceltrainingvideos.com/identify-colored-cells-excel-worksheet-and-perform-actions/
Very nice and Brilliant code created
Glad you like it! Please share the Excel VBA tutorial with your friends also.
I'm trying this on a macro enabled word document (docm files) which things should i change in this code to make it work?
Totally different way of working from Word!
Thank you so much, ¡Brilliant!.
Anyway, please, could it be possible that the text format (from Word) will be transferred to the Excel? And if possible, could you teach the code to be added to the code in this video?
Tank you very much.
Cheers,
Alberto
Hey Thank you for this help. Stay Blessed.
You're welcome!
Thanks a lot. That's really helpful
Glad it was helpful! Please share the VBA tutorial with your friends.
Simply superb sir. Please do a video on filtered data. Vlookup. How to do visible cells vlookup. Please sir
Already uploaded. Search this channel or our website: www.exceltrainingvideos.com/
Simply how to do vlookup function when any data is in filter. For visible cells only we have to lookup using match function for headers mapping.
Query not clear.
Sorry for spelling mistake. Vlookup when data is in filter. Using match for headers. Ex: filter completed when we have to lookup for pending. But the columns are not in sequence.
Noted
@@Exceltrainingvideos: thank you. Waiting for video sir
Can this be used to get some data from word and then add it to the meta data of the file? then adding it to say the "TAG" properties?
Try it out!
@@Exceltrainingvideos I have and it doesn't work.
Thanks for sharing... Great learning experience. Can it possible to extract a sentence after find a specific word on it?
Could you please take another session on this?
Yes you can! Try it out!
Hello sir, I’m running into an issue here. When I ran the code for the word document, I could only run for the first page, my results from the second page is not showing up. Also my word document contains text that I want to search for and copy to excel. Is there a video of yours I could look at for more detail? Thanks for all your help in advance
Please search the channel. To get data from multiple pages in your word document, you'll have to use a looping process.
hi sir. I have a case. with a worksheet of multiple columns. each data in the column may refer to another sheets on a lan or share point are which need to be validated
second. if one cell value is given. based on cell value next column to be populated based on validation from different sheet. I may have 100 plus reference sheets where data to be validated.
is that a possible case. can you help me sir
Noted
can we export date from multiple word files, copying those to excel ?
Should be possible.
Tqs for the reply sir. But there is no video for how to do vlookup for multer data using match.
What is multer data?
Use this exact code but I'm getting a "Compile error: User-defined type not defined" and it is referring to... cDoc As Word.Document
Hi Sir. I am running into an error while running this code. when I run the code first time it works fine but when I run it for the second time it throws the error on the below line
set cDoc=ActiveDocument
the error is read as "the remote server machine does not exist or unavailable."
Please advise how to remove this error.
Just save and close the document in the first extraction.
Still not working Sir. I got 462 error.
Can you show VBA How to auto transfer data to another sheet by using date?
This VBA tutorial link will guide: www.exceltrainingvideos.com/tag/copy-data-based-on-date-criteria/
Or search www.exceltrainingvideos.com
Thanks so much
Interesting
Glad you found the Excel VBA tutorial interesting. Please share with your friends too.