I’m having a hard time understanding how you are doing this. With automation you should not have any file sharing errors
But in any case, if you Have to user a macro, you can do something like this:

Private Sub Workbook_Open()
ActiveWorkbook.SaveAs Filename:="c:\temp\MyFile"
End Sub

>Thanks Yuri!
>I appreciate the response. I am unable to use automation as the workbook gives me a file share error. So, COPY may be the only way to go. The only issue now is, I need to manually run out to the machine and press save on the open workbook. I just need some kind of macro to set up with Excel to Auto Save. Any suggestions?