I need to use the variable LETTERFILE to represent the name of the file I wish to open, I have a procedure written that will fill in the name and address section of the letter, but depending on who the letter is being sent to it may change the template I wish to use.

   Set oWord = CreateObject("Word.Application")
    oWord.Visible = True
    Set oDoc = oWord.Documents.Open(FileName:="& letterfile &", _
    ReadOnly:=True)

So how do you pass a variable into the above??

Shady


____________________________
I don't wanna die... but I ain't keen on livin' either

I think you just have to remove the quotes.

Set oDoc = oWord.Documents.Open(FileName:= letterfile , _     ReadOnly:=True)

[Edited by steve_w on 18-06-2003 at 03:13 PM GMT]