Open and save macro
 

I want to be able to open a workbook that is currently open by another user
on a shared network by using a macro. I then want the macro to automatically
select ok when prompted about being a read only and then to select update.
Next, the macro should save the file as a different file name, possibly in a
different location. I then want to close the file. Is it possible to
automate this?

Thanks

Adam Bush