Andrew you're a fantastic teacher - if I was to be extremely picky the only thing missing from these series would be some "homework" after each video - obviously we could think about that ourselves but just thought I'd mention it as you might be able to suggest 'better' things than we could at this initial stage. And I love how you revisit the previously taught concepts in new lessons which helps reinforce them.
Excellent tutorial! I hope to see this concept explained with PowerPoint! However, I am already thinking how to implement these techniques! Thanks for sharing
Than you so so much this is so helpful, i have a quick question what if I want to open word template and not an new word doc how would i could that to make it happen? also how can I code a page break between each table instead of a paragraph line?
Hi Andrew, how are you? Could you please let us know how we can combine multiple pdf files into excel using VBA Programming. Plz upload a video if you can. Thank you so much in Advance.
Hello!! I think I found the reason why the for each loop doesn't work at 21.44..... I think becasue of this "For Each doesn't work because updating the field destroys the object, so it loops over the same object"
Hello Sir - I need help in MS word VBA. I am running loop in ms word table for each row and each row is having a Bookmark as I am pasting data from excel to word but I want to retain the bookmark.
Hi Surendra! Maybe these links will help www.mrexcel.com/board/threads/vba-copy-excel-table-to-word-bookmark-but-keep-bookmark.1137435/ wordmvp.com/FAQs/MacrosVBA/InsertingTextAtBookmark.htm
I have some problems with updating the data. When I save the excel file and then try to update the data, the data in the word will not update any longer. Why this happens?
Hi bro, same issue here. The idea may be found in the link below from Microsoft.com answers.microsoft.com/en-us/office/forum/office_2013_release-word/embedded-links-in-word-from-excel-problem-opening/35460e5e-7316-44b5-b4c2-520a02a5dc53. See the reply of the guy on June 6, 2015 Inspired by this, only for the purpose of learning(which means not from my practical experience), i solved this issue by checking "Enabling all macros" in trust center. It works. i have tried. However, this is a way to solve it. I can't find another solution to this problem right away.
Nevertheless, i found that i just didn't check the silly Developer Macro Settings in Microsoft Word!!! If you check that box, you can find that even with Macro Settings "Disable all macros with notification", the updating data issue would be solved.
Hello, I am trying to update links from another excel file where the source data file remains same but the name changes eg. Soucedata for 12 07 2021 will change to source data 13 07 2021 how can I update the links from another excel work book where the name changes daily ?
Hi there! I don't know the answer to that one. I'd recommend searching for an answer on StackOverflow.com and, if you can't find one, post a question there. I hope you find the answer!
Brilliantly explained man, I literally wasted countless hours googling this topic. when I came to this...
Andrew you're a fantastic teacher - if I was to be extremely picky the only thing missing from these series would be some "homework" after each video - obviously we could think about that ourselves but just thought I'd mention it as you might be able to suggest 'better' things than we could at this initial stage. And I love how you revisit the previously taught concepts in new lessons which helps reinforce them.
Another fantastic video ❤ Thank you!
Thank you for watching!
You're a genius! No other words are needed!
Great job once again Andrew. Thanks so much.
really outstanding...Andrew.!
Excellent tutorial! I hope to see this concept explained with PowerPoint! However, I am already thinking how to implement these techniques! Thanks for sharing
Great video as always!
Did you figure out the infinite loop issue for the for / each method?
Than you so so much this is so helpful, i have a quick question what if I want to open word template and not an new word doc how would i could that to make it happen? also how can I code a page break between each table instead of a paragraph line?
Hi Andrew, how are you? Could you please let us know how we can combine multiple pdf files into excel using VBA Programming. Plz upload a video if you can. Thank you so much in Advance.
Hello!! I think I found the reason why the for each loop doesn't work at 21.44..... I think becasue of this "For Each doesn't work because updating the field destroys the object, so it loops over the same object"
Thank you!! What if the range of cells to copy varies? Is there a way to automatically determine the range in each sheet?
hi @Cullen Harris, he talks about your question in this video: th-cam.com/video/FwcEFCwGtjo/w-d-xo.html
i hope this helps you out
Hi Andrew,
Another awesome video!
I had a question.
Does this also work for linked graphs?
Fentastic Sir.
Thank you Rohith!
Hello Sir - I need help in MS word VBA. I am running loop in ms word table for each row and each row is having a Bookmark as I am pasting data from excel to word but I want to retain the bookmark.
Hi Surendra! Maybe these links will help www.mrexcel.com/board/threads/vba-copy-excel-table-to-word-bookmark-but-keep-bookmark.1137435/
wordmvp.com/FAQs/MacrosVBA/InsertingTextAtBookmark.htm
I have some problems with updating the data. When I save the excel file and then try to update the data, the data in the word will not update any longer. Why this happens?
same issue here why!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I realized this bug may be due to office 2013. Are you also using office 2013? I think the latest office shouldnt give u this kind of bug
Hi bro,
same issue here.
The idea may be found in the link below from Microsoft.com
answers.microsoft.com/en-us/office/forum/office_2013_release-word/embedded-links-in-word-from-excel-problem-opening/35460e5e-7316-44b5-b4c2-520a02a5dc53.
See the reply of the guy on June 6, 2015
Inspired by this, only for the purpose of learning(which means not from my practical experience), i solved this issue by checking "Enabling all macros" in trust center. It works. i have tried.
However, this is a way to solve it. I can't find another solution to this problem right away.
Nevertheless, i found that i just didn't check the silly Developer Macro Settings in Microsoft Word!!!
If you check that box, you can find that even with Macro Settings "Disable all macros with notification", the updating data issue would be solved.
Hello, I am trying to update links from another excel file where the source data file remains same but the name changes eg. Soucedata for 12 07 2021 will change to source data 13 07 2021 how can I update the links from another excel work book where the name changes daily ?
Hi there! I don't know the answer to that one. I'd recommend searching for an answer on StackOverflow.com and, if you can't find one, post a question there. I hope you find the answer!
just fantastic