How to split an excel range into multiple tables in word

[deb]

I need to split a range A1: I11069 of a excel sheet named word report into multiple tables of a single word file named report.doc and set the word files to landscape orientation . Need a vba code for this .

[gmayor]

How many rows do you want in each table? Do you want the header row to appear in each table?

[deb]

pls refer to the word document which should be the final outcome after splitting the excel range in the sheet word report in the excel file .

thank you in advance for taking your time to help me out .

[gmayor]

Unfortunately, this is far more complicated a task than your initial question suggested. I regret I am not able to assist.