Opening a word document and adding text to it

Dear all,

I wrote the following macro with which I open a word document:


Set word = CreateObject("word.application")
word.Visible = True
word.documents.Open ("C:\Documents and Settings\aa471714\Desktop\Sop_template_Zuilen")

No i would like however that I can also insert something (preferably in an input box) which automatically is put in the word file I open. The text should be put after a phrase called "Invoice". Anybody a clue on how I can do this?

Dear regards,

Marc

Hi Marc
Based on your post this is a Word Issue and not an Excel one. However what you need to do is in the file that you are opening from Excel you need to save it as a template first of all. Then in that same template create an a bookmark where you want the user input to be placed. Then create AutoOpen macro that prompts the user for input and then searches for the Bookmark you have created and places the text. This can be done by recording the macro first the cutting and pasting it into your AutoOpen macro.
Hope this helps.
Good luck.
Tony