I have a variable named StrJobNum that i get from a list box that the user selects. On my hard drive are .doc files that each match one of the given selections from the list box. So what I need is for my program to then open the .doc files in word with something like "C:\My Documents\StrJobNum.doc" and I have each file for every given situation for StrJobNum. So if my StrJobNum is A1024, I want it to open C:\My Documents\A1204.doc in word, or if possible then make it splash up onto the screen. Thanks guys :) I wish i was smart enough but i haven't got there yet :(

If you don't feel put off by the Win API (and you shouldn't be in this case) I'd say try ShellExexcute.

Details here http://vbaccelerator.nuwebhost.com/c...ll/shellex.htm or http://support.microsoft.com/default...en-us%3B170918 here.

If you still have problems are reading these post back.

I found this code that opens it in Read Only mode, but I imagine you could change the attributes to make it editable:

Set WordApp = CreateObject("Word.Application")
    WordApp.Visible = True
    WordApp.Documents.Open ("C:\Temp\Test1.Doc")

Pete S - Tucson, AZ

Pete S - Tucson, AZ