Hello everyone!
I need to copy some tables from MS Word to Excel automatically with VBA. but I need the tables to be transposed in Excel. I've attached samples to this post so that you can understand what I mean.
I've tried some codes but they are not working like I want. I need this urgently please.
If someone is out there reading this and can help out, please do.
Save a soul here please!
Thank you in advance.
The macro code below seems to function as you desire. I modified code found on another forum to transpose the table and read the header once. This assumes the headers are always the same in column 1 of each of the Word tables.
Source: http://www.mrexcel.com/forum/excel-q...lications.html
Copy this as a macro into your workbook and run it. Browse to the .docx file and it will pull the data onto a new sheet.
Please Login or Register to view this content.
<----Don't forget to add reputation if I helped
@percecuted: Thank you so much for the code. But how do I add 'reputation'? Let me know how please so that I can add it. Thank you once again.
@percecuted, I don't also know where you can give me a full code of that one you sent me. I want the code to run on both MAC and Windows. Thank you. I will repeat the code below.
Please Login or Register to view this content.
Unfortunately I don't know what changes, if any, need to be made in order for this to run on both MAC and Windows systems. I only have Windows systems to work with.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks