VBA Code to copy table from word into excel

**sharonb888** · 12-13-2012, 10:57 AM

I am looking for VBA script that copies the second table (two columns 19 rows) in a word document into ‘Book 3’ excel spread sheet in a specified location keeping the source formatting.

Any help would be much appreciated.

**patel45** · 12-13-2012, 11:23 AM

try this

Please Login or Register  to view this content.

**sharonb888** · 12-13-2012, 01:47 PM

Hi...thanks for the code it is the best that I have seen.....is there any chance that the code can be tweaked so that the extracted information loads from where you have clicked in an excel file and can it also incorporate the assumption that the extracted information is from the active word document?

**patel45** · 12-14-2012, 04:01 AM

I'm sorry, I found it and never used

**sharonb888** · 12-14-2012, 05:24 AM

Hi..I have tested the above code and it works but I would would like it to pull the data from the active word document.....does anyone have any idea how to do this?

**patel45** · 12-14-2012, 07:37 AM

When you are using Excel you have no active word document, you have only a open word document, then you have to know the file name

Please Login or Register  to view this content.

**sharonb888** · 12-14-2012, 09:33 AM

Hi...with the scenario that I will be working with there will be a word document opened....(opened from an e-mail attachment) and excel will be open therefore I need it to recognise the word document that is open...if that makes sense.

Kind Regards

Sharon

**patel45** · 12-15-2012, 05:19 AM

It's better you open a new thread with title How to recognise the word document that is open

**jcorriher** · 04-02-2013, 06:43 PM

This does work very well - much appreciated for the tips. But I have a situation where I have multi-row merged cells. For example, in the first table column, there would be a merged cell for rows 2-4, but the 2nd and subsequent columns would be unmerged. Is there a way to unmerge these cells prior to pulling them into Excel? Thanks in advance!

**arlu1201** · 04-03-2013, 02:15 AM

jcorriher,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.