Error when VBA tries to copy on Macserver from Windows 7

[scottiex]

I have a macro that used a fileserviceobject command to copy files.
It is designed to be run on a windows computer in a windows 7 environment to copy a file on a mac server.

it has been working until recently but now it seems to fail when run from a windows 7 environment.

Strangely it works when I run it from an XP environment. Or if I tell it to copy files that are not on the mac server (unfortunately these are not the combinations that are required!). I can also copy files manually.

If I step through the VBA it gets to the Fileserviceobject line and copies the file but then it hangs and will not proceed any further.

We get an error

System error &H80070040 (-2147024832)

if I delete the file while it is in the 'hung state' it gives a "permission denied" message.

windows 8.1 also fails in the same way.


So in summary some sort of issue occurs in the copy process for VBA run from windows 7 (on excel 2010) when working on a specific server (a mac server)

Has anyone else encountered this behavior and have any ideas where the issue might be, or have an idea for a work around?

[scottiex]

Update : I discovered that FileCopy sourcefile, destinationfile works (while using filesystemObject doesn't) so I think I have a work around