Dave, do you want to save the file in the same directory it was opened
from or to a standard, default directory or to a directory that the
user chooses?

Alan

David Hodgson wrote:
Hi folks,

Is there a way to open an excell file so that when you go to save it it
saves in a specific directory?

ps I am opening this file using the hyperlink function within excel.

thanks
Dave