File System Object Issue.

Greetings:

The code below is used to copy a folder and all its contents. It works great and is quite fast when run across a local drive, and even when run across a shared drive close to me in the network tree, if I'm using the right term. The problem is that when I run it across a shared drive that isn't so close to me in the network tree it doesn't complete itself and results in an Excel "hang" that requires a forced crash of the workbook.

After such a crash I can see that most of the folders and files have been copied, just not all. Oddly, it is fairly consistent with regard to where it hangs in the copy process.

It might be obvious but, when I step through the macro in the VB editor it hangs up when it gets to the line startign with "Fobj.CopyFolder...".

I'm not even sure exactly what to ask here but, does this problem ring a bell with anyone?

Thanks very much.

Please Login or Register  to view this content.