Here's the situation. Specifying a filename without a path using teh SaveCopyAs method of the ActiveWorkbook apparently defaults to the path being the My Documents folder.
Specifying just a filename outside of that method is defaulting to the path where the executable resides.
Therefore you need to specify it for the connectionstring using the method in the link.
This post has been edited by CharlieMay: 02 April 2013 - 11:29 AM