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
|