ActiveWorkbook.Path issues with UNC

[mdex]

I've been learning more and more about Macros and VBA to automate a small report I need to perform on a daily basis.

I still can't write code from memory but understand a little which is why I'm dangerous. With a bit of googling and modification the code was tested and all working locally before moving to the network drive location. After moving, my code falls down at pretty much the first action of finding the name of a file to copy into the existing report.

The reason I'm not using explicit filenames is because there is date added to the file I'm copying in.

This line is where I get a Run-time error '52' Bad filename or number.

Please Login or Register  to view this content.

When it fails out hovering over activeworkbook.path show's the UNC path \\blahblah\folder\folder2 but sFound is = "".

Please Login or Register  to view this content.

Can I modify the existing code in any way to work with UNC paths?

[humdingaling]

see if this helps

Please Login or Register  to view this content.

[mdex]

see if this helps

Please Login or Register  to view this content.

It fails out before we even get to the copy stage. It fails defining sFound.

[rorya]

How long is the string returned by activeworkbook.path?

[mdex]

How long is the string returned by activeworkbook.path?

101 characters.

It's a mapped drive to a SharePoint document library if that makes any difference. It also has a @ in the path which could be causing the issue?

[rorya]

I don't have access to a Sharepoint folder to test but the @ shouldn't be a problem for Dir.

[mdex]

I don't have access to a Sharepoint folder to test but the @ shouldn't be a problem for Dir.

Definitly a sharpoint issue. Moved to regular network drive and it works fine.

I've since noticed that activeworkbook.path isn't returning the UNC path but the https:// path instead.

[rorya]

Ah, yes - that would be a problem.

[mdex]

Ah, yes - that would be a problem.

I've had to specify the UNC path to sharepoint rather than use ActiveWorkbook.path. Not the end of the world.