the parent file (word or excel doc) will be stored in different locations on different computers while the .frm and .bas files will be downloaded (using the code from the excel doc) in a specific location on every computer. i've entered the code for finding the path of the .frm and .bas files but i don't think that's the problem. thanks!