Hi all,

I checked many solutions to fix my issue but i am not able to correct it, I have a file placed on a server and I would like to copy the sheet "PO" to a new workbook via VBA.

My VBA code is really simple :

Sub CopyPO()

ActiveWorkbook.Sheets("PO").Copy

End Sub

The macro work well when I run it from the file placed in on my desktop but when i run it from the server i got Path/file access error VB???.tmp (the ??? always change if i run the code severals times)

I tried many ways without viable solution.

I will be glad to get some help.

Thx
Geoffrey