Convert word document to excel

[YasserKhalil]

Hello everyone
Is there a way to convert word document to excel and keep the same formats as possible as it can?

I have attached a sample word document to try a test on
Thanks advanced for help

[Rudi]

Welcome to the Lounge from me too...

Is this a once off document or do you need to convert many?

Most of the document is made up of tables, which can be copied and pasted into Excel with a measure of success, but will still need a bit of manual attention to neaten up. For a once of, its just a copy and paste and then some TLC to neaten it up. Converting many (esp. with code) is not going to be viable.

Why Excel though?
This type of document is actually better suited to Word and tables in Word are more flexible than a spreadsheet structure in Excel.

[HansV]

It would be a LOT of work to try to keep the formatting the same, since all cells in a column in Excel have the same width. You'd have to merge lots of cells.
If possible, I'd keep it as a Word document.

[YasserKhalil]

Thanks a lot Mr. Hans and Mr. Rudi
In fact I need to convert other similar word documents and it will be exhausting if I do that manually. So I was searching for a VBA code that can do that
My boss needs these files to be converted to excel although as you said it is better to be as they are in word.
Best Regards

[Rudi]

Here is a macro from VBA Express to process a folder full of Word documents and copy each into a new sheet in Excel.
As mentioned above, its a straight copy and paste, so it is not going to transfer perfectly due to merged cells and formatting.

It might save a little time with the transfer to Excel, but a lot of work will be needed to fix them up.

I'd have a chat with the boss and convince him its better in Word.

[YasserKhalil]

That will be very helpful. At least it will save time opening and copying each file and pasting it into word
Thank you very much for this great link.

Best and kind regards