VBA: extract specific table from word to excel

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I Good People

    I managed to identify all th word docs. However, I'm having a problem achieving to extract the 2nd column row 2 data of the table.

    Error: Set Table = doc.Table Object variable block

    The word table looks like the attached img. I only wanted to extract the "x" starting from row 2 column 2..

    Hoping someone can actually help me on this.. Thank you in Advance!

  • Your code never starts Word, or opens any documents.

    Also, this is yet another thread where you have cross-posted elsewhere without saying so, so your account is now suspended.

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!