Creating report from Excel to Word

hi RinorM, try to change the following line:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hi! unfortunately that didnt work. I will paste the document if you got time to check it please. Thank you.

Excelforum help.xlsm

try this out:

Please Login or Register  to view this content.

Hi watersev! It became better but it still gets outside the margins:

Excelforum.jpg

Thank you for your time and help!

my end it is looking OK on the provided xlsm file, please see attached

Yes I see, but do you know why the microsoft equation formulas get so strange format? Becase the code I had copied the whole formula but yours takes somekind of printscreen of it? Thank you.

the last line controls that

Please Login or Register  to view this content.

try to right-click the table your end, Autofit - Autofit Contents, it should correct table over the margin issue your end

I managed to rewrite the code abit so it looks like this:

Please Login or Register  to view this content.

Only thing is that now it creates two word documents. I believe it is becase of this sentence is mentioned twice :

Please Login or Register  to view this content.

How can I rewrite that one so that it doesn't appear two word documents when running the Macro? Thank you.

it should be

Please Login or Register  to view this content.

instead of the line in question

I do not see how that rectifies the issue of the table over the margin. Though if you are OK with that I do not mind (I can suggest the way it would work as you want in case I'm right)

Sorry for changing subject. The code I pasted manages to give me that the tables are inside of the page, but how can I make it so that I want to narrow the width of the tables pasted? btw i really appreciate the time you take to help me.

the following code goes to Excel file:

Please Login or Register  to view this content.

This code goes to Word Normal.dot that keeps Word macros similar to Excel personal macro book:

Please Login or Register  to view this content.

This way it allows to set parameters for Word by it's native code as I've not found a way to control them from Excel

if you do not take Normal.dot for Word it will error out on the calling line and you will end up with everything done except for putting text horizontal and setting table within page margins

Yes I understand, thank you. And there isn't any other way to do the text horizontal and setting table within page margins, without taking the Normal.dot for word?

Oh my god, finally it works!! I am extremly thankful for your time and bearing with me the whole way. THANK YOU!!