Dynamically create a Word Table from Excel Data using Excel VBA

Welcome to my ExcelPowerTips Channel! Use Excel VBA to dynamically create a Word Table based on an Excel dataset with variable number of Excel rows and columns and the generated Word Table will also have matching structure. Also repeating table header row with header shading. You can download the enhanced v2 code using the link here: https://drive.google.com/file/d/1D2h1AtqWt8gvDKdnt2Ga7mzQqCCS2ofT/view?usp=sharing The above updated v2 code now allows you to set the font name of the Word table as well as the font size from with the code and screen updates have been temporarily switched off for performance. Furthermore a list of common font names are included you can choose from with the above code and you can now set the row height of the Word table from within the Excel VBA code. If you enjoyed watching this video consider subscribing and share this amazing Excel Power Tip with others. If you like my channel contents please consider donating however small to support my channel so I can continue providing you with quality content using the below link. https://www.paypal.com/donate/?hosted_button_id=KY9HN97ZNPYGU LIKE - SUBSCRIBE - SHARE - COMMENT - DONATE - ENJOY!