VBA Code to create a new MS Word Document.

Dear all,

I hope you are all well.

I have a workbook with a table were I insert all my tasks (The new ones, in process, resolved and so on).

I have a UserForm that let me choose the row of the table I want so I can send an email. So far so good. I am using the following code that works perfectly:

Please Login or Register  to view this content.

I need to have something similar, but instead of opening a new Email from Outlook, I need to open a new document from MS Word.

Your assistance will be highly appreciated.

Best regards,
Filipe

Please Login or Register  to view this content.

Hope this helps!

Hi TKCZBW,

Thank you for your prompt reply.

The code opens a new MS Word document, which is great, but I need to have as well some pre-selected text as shown on my code in the "strbody".

Thanks a million,
Filipe

Please Login or Register  to view this content.

If you want it at a specific location in the word doc, that is a problem that I am currently dealing with as well. My personal thought process is currently leaning towards the use of text boxes. However, this would realy only work if you open an existing blank template with the textboxes in there already.

If you just need the text at the beginning of the sheet then the code above should do it.

Best,

TKCZBW