Excel to Word- paragraph and page setup

Record you macro in MSWord and use that in your Excel macro. These links should help as well.
'TypeText method
' http://www.excelforum.com/excel-prog...ml#post1946784
' http://www.excelforum.com/showthread.php?p=1946784
' http://vbaexpress.com/forum/showthread.php?p=169877
' http://vbaexpress.com/forum/showthread.php?t=24693

When I create a macro in Word, I get this code:

Please Login or Register  to view this content.

When I insert this into the previous code after wdApp.Visible = True and try to run the macro, I get an error message: "Sub or Function not defined" and the debugger highlights "InchesToPoints".

Thanks!

I do have a word document setup and bookmarked to add the values to the document that I use. However, there are 6 other users of the workbook and I would like to generate a word document for them on their machines. When a macro is run to generate a word document, the default margins and paragraph for their normal template is used and there is variation in this "normal" template from user to user. Thus, I want to create the Word document and define the page setup and paragraph setup instead of using the normal templates.

With the above code generating an error message, it seems that I need to define or reference the document somehow.

Thanks,

Originally Posted by snb

Why not sending those users a copy of the correctly formatted document ?

That is not an option that I want to pursue at this time. I want to use VBA to create the word document and also define the page setup and paragraph setup.

Thanks

Your code is for Word's VBA using it's defaults. You are doing it in Excel's VBA which uses it's defaults. So, after you make the Word Application object reference called say "wa" as shown in my first example link, do wa.Selection. Selection by itself assumes the Selection is for the Excel application.

Thanks to the good folks above, here is the code that worked:

Please Login or Register  to view this content.

I would recommend that you add the Word constants since you are using late binding. You probably have the Word object referenced which is why that code worked.

Please Login or Register  to view this content.