Macro exporting data from a spreadsheet to word and retaining it as a table

Hi guys, wonder if you can help

I'm working on a project and am slightly out of my depth! I'm trying to create a "report" button which generates a word file with the contents of the current worksheet in a nice table

Currently the word file is created and the data is in there... From within Word, all that needs to happen is selecting all the text and then clicking Table>Convert>Text to Table

I borrowed some code from somebody elses example and modified it a bit

Please Login or Register  to view this content.

This bit

" .Range.ConvertToTable Separator:=wdSeparateByTabs"

is the part which should be converting the text into a table... But it isn't!

Anybody got any thoughts?