Macro to Export Word Tables to Excel

**WesternGal** · 05-17-2013, 10:52 PM

I have a Word document that has several tables which I would like to pull into Excel (each table on a separate sheet). I have been copying/pasting the tables, but was wondering if there is a macro that can pull them in for me.

I found the following macro online, but when I add it as a module in Excel, I get a run-time error at the

Please Login or Register  to view this content.

line.

Does anyone know why?

I am using Office 2010, and am on a MAC. I tried this on a PC as well and still got an error.

Please Login or Register  to view this content.

**patel45** · 05-18-2013, 08:35 AM

your code works on my excel 2010 win 8, but only with doc file, not docx

**WesternGal** · 05-19-2013, 09:22 PM

Yes, the file I want to import is a .doc file.
I found a forum that said sometimes you have to replace the quotes as they don't come across correctly when copied. That didn't fix it, but it did highlight that the underscore in this line was "invalid character."

Please Login or Register  to view this content.

I tried deleting the underscore and also tried adding a file name

Please Login or Register  to view this content.

but in both cases I get a "type mismatch" error on the following line:

Please Login or Register  to view this content.

I know it's something I'm not doing correctly, but I'm not sure what it is. . .

**ducky_yeng** · 05-20-2013, 05:18 PM

Hi WesternGal

I too gave your original code a go using Excel 2010 on Windows 7 and it worked for both doc and docx files. I was unable to replicate the error.
However, I had a quick look online and found this useful msdn resource that describes "Programmatically Selecting Files in Excel for Windows and Excel for the Mac" http://msdn.microsoft.com/en-us/libr...FileNameMethod

Hope the msdn link is of some help to you.

**WesternGal** · 05-20-2013, 10:00 PM

Found an answer: on a MAC, the line has to read:

Please Login or Register  to view this content.

There were multiple other errors in the code I had copied, but I found the correct text to loop through all tables in Word and import them to excel on this thread:

HTML Code:

Please Login or Register  to view this content.

**yorkie37** · 02-16-2018, 05:08 AM

Thanks a million, Western Gal.

I had searched for days and worked sooo many hours to try to solve this problem. With your code plus a couple of tiny twiddles to it to import data from just one single-line table, it ran perfectly on my Windows PC.