Dir and FileCopy don't work???

[Bill]

It appears that both the Dir and FileCopy
functions do not work when being directed
to mapped drives. Is there a way around
that problem?

Bill

 

[Bill]

Not sure why mapped drives don't work, so to
get around that problem, I simply used network
syntax to specify the \\servername\sharename\.
where sharename is the share name of the
desired drive on another machine.

Bill

 

[Douglas J Steele]

Glad you got it working, but I'm pretty sure I've used mapped drivers
without issue.

What's the code you're using that's failing?

"Bill" wrote in message

Not sure why mapped drives don't work, so to
get around that problem, I simply used network
syntax to specify the \\servername\sharename\.
where sharename is the share name of the
desired drive on another machine.

Bill

 

[Bill]

[snips]
Const SermonPortal As String = "p:\SermonPortal\"
FileName = Dir(SermonPortal & "*.*")

Where p is a mapped dirve. The Dir returned null
whereas there are 50 or so files in the directory.
The code worked fine after the constant was changed
to \\AV-Computer\AV-DDrive\SermonPortal\", where
AV-Computer is a member of the current Workgroup.

Bill

 

[Douglas J Steele]

Not that it's going to be any consolation, but I can confirm what you're
saying, at least under Win7.

Odd, because I'm sure I've used mapped drives successfully in older OS.

"Bill" wrote in message

[snips]
Const SermonPortal As String = "p:\SermonPortal\"
FileName = Dir(SermonPortal & "*.*")

Where p is a mapped dirve. The Dir returned null
whereas there are 50 or so files in the directory.
The code worked fine after the constant was changed
to \\AV-Computer\AV-DDrive\SermonPortal\", where
AV-Computer is a member of the current Workgroup.

Bill

 

[Bill]

I was surprised as you apparently are.

By the way Doug, would you have a quick look
at my post "How do I link"? Maybe you can tell
if References could be at cause for my failures.

Thanks,
Bill

Not that it's going to be any consolation, but I can confirm what you're
saying, at least under Win7.

Odd, because I'm sure I've used mapped drives successfully in older OS.

"Bill" wrote in message

[snips]
Const SermonPortal As String = "p:\SermonPortal\"
FileName = Dir(SermonPortal & "*.*")

Where p is a mapped dirve. The Dir returned null
whereas there are 50 or so files in the directory.
The code worked fine after the constant was changed
to \\AV-Computer\AV-DDrive\SermonPortal\", where
AV-Computer is a member of the current Workgroup.

Bill

Glad you got it working, but I'm pretty sure I've used mapped drivers
without issue.

What's the code you're using that's failing?

"Bill" wrote in message

Not sure why mapped drives don't work, so to
get around that problem, I simply used network
syntax to specify the \\servername\sharename\.
where sharename is the share name of the
desired drive on another machine.

Bill