I have some code that was supposed to change the save directory to teh c
drive, if the desired network drive was unavailable.

If the drive was unavailable (presumably because of some network
infrasturucture issue) excel would return error 68 Device unavailable. the
code traps this error and the runs the routine to save it to the c:\ drive.

But, if the path changed the code would trap error 76 Path not found and key
the user to update the path in the macro.

However, suddenly the when the infrastructure condition occurs that makes
the network drive unavailable, it returns 76 instead of 68.

What happened?

there have been some infrastucture chages to the vendor who supplies the
various routers and switches in teh envirionment.

You may want to use the folderExist method to test if the error exists rather
than detect the error condition.

object.FolderExists(folderspec)



"Pbk" wrote:

I have some code that was supposed to change the save directory to teh c
drive, if the desired network drive was unavailable.

If the drive was unavailable (presumably because of some network
infrasturucture issue) excel would return error 68 Device unavailable. the
code traps this error and the runs the routine to save it to the c:\ drive.

But, if the path changed the code would trap error 76 Path not found and key
the user to update the path in the macro.

However, suddenly the when the infrastructure condition occurs that makes
the network drive unavailable, it returns 76 instead of 68.

What happened?

there have been some infrastucture chages to the vendor who supplies the
various routers and switches in teh envirionment.