Bat file called from macro addressing network drives - NOT!

R

Ron

I have a bat file on a network drive that manipulates data files on a network
drive. However, when I try to run that bat file from a macro, I get:
\\oslo\common\ccstat
CMD.EXE was started with the above path as the current directory.
UNC paths are not supported. Defaulting to the windows directory.

The path above is correct, so he recognizes it. I have the drives mapped as
drive letters also.

So how do I trick this thing to run my bat file from a macro? Or can I?

Ron
(BTW, thought I sent this yesterday, so if it shows up twice, I
apologize....I know, I know, if he can't post a question, how can he do VBA?)
 
R

Ron

Call Shell("cmd.exe /c T:\all.bat 10-06-09", 1)

I did it with and without the call statement.

Ron
 
R

Ron

It has been solved. I needed to change directory in the bat file to the
network drive. Then all works as advertised.

Thanks, anyway guys
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top