Dear All,

Programtically a Workbook is opened as read only from a
shared directory. How can I enure that when a user tries
to press save, the directory where the file was opened is
not the directory that Excel tries to save the file, but
one of my choice?

Chdir does not work. I could customise the Excel Workbook
or make the shared directory read only, but is there an
easier way?

Alastair