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