changefileaccess

[johngauci]

hi there,

i have a strange problem with the command changefileaccess.

When i use ThisWorkbook.ChangeFileAccess xlReadWrite from a local file, the following commands work, but when i have the file saved over the network excel halts just after executing the changefileacess.

Any suggestions please? this is quite urgent

Thanks all