What i want to do is to get the name of the word document in vba so that i can use the Right function to determine wether it is a dot or doc file and the dependent on the result to run a macro but cannot find the code to pull the file name.

Does anyone know what it is?

Thanks