It can't be done because you probably don't need to do it. You don't need any VB code to change the location. Once you connect your report to a ttx file, the ttx file becomes part of your report. You could delete the ttx file, and it wouldn't make any difference, your report would still run.