On Sep 27, 7:46*pm, "Tim Williams" wrote:
A web server is not a filesystem (OK I know it is underneath, but it's not
exposed in the same way).
Being able to open a file in Excel from a http location is just an added
convenience, but you can't use Dir() on a http location,

If this is an intranet situation then you may be able to map a drive on to
the shareweb server:
\\xx\xx\CIS\Shared Documents\

Provided you have access privileges that is.

Tim,

Thank you for pointing out the distinction!!! I think that is exactly
the issue I'm facing. And yes, I can map the drive and I do have
access so I'm going to go try it right now.

Thanks again, I was hoping I would have a solution before the start of
the week!

John