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 .
Printable View
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 .
How many rows do you want in each table? Do you want the header row to appear in each table?
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 .
Unfortunately, this is far more complicated a task than your initial question suggested. I regret I am not able to assist.