Sorry

I am new to this and apologise for posting incorrectly

Thank you for all your help

I didn't realise the ' shape difference because normally in an SQL string it is '

I guess I needed to add the extra info on the provider bit to establish the connection.

The letter works fine thank you.

I have created 3 documents and have a msgbox to prompt me with which type I'd like and then have added this to the path string to open and had this stored in a variable and have used that variable to change the main document type.

Would I need to add anymore code depending on what type of format I select?

Ps what is the dollar sign in sheet$

Many thank sir

I can see you put a lot of effort on this forum and I especially appreciate all your help