Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bat file called from macro addressing network drives - NOT!
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?) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bat file called from macro addressing network drives - NOT!
What code did you use to try and "run" your BAT file?
-- Rick (MVP - Excel) "Ron" wrote in message ... 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?) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bat file called from macro addressing network drives - NOT!
Call Shell("cmd.exe /c T:\all.bat 10-06-09", 1)
I did it with and without the call statement. Ron "Rick Rothstein" wrote: What code did you use to try and "run" your BAT file? -- Rick (MVP - Excel) "Ron" wrote in message ... 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?) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bat file called from macro addressing network drives - NOT!
Sorry, without the call staement I used X =
"Ron" wrote: Call Shell("cmd.exe /c T:\all.bat 10-06-09", 1) I did it with and without the call statement. Ron "Rick Rothstein" wrote: What code did you use to try and "run" your BAT file? -- Rick (MVP - Excel) "Ron" wrote in message ... 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?) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bat file called from macro addressing network drives - NOT!
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 "Ron" wrote: Sorry, without the call staement I used X = "Ron" wrote: Call Shell("cmd.exe /c T:\all.bat 10-06-09", 1) I did it with and without the call statement. Ron "Rick Rothstein" wrote: What code did you use to try and "run" your BAT file? -- Rick (MVP - Excel) "Ron" wrote in message ... 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?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mapped vs Network drives | Excel Worksheet Functions | |||
Hyperlinking on Network drives | Excel Worksheet Functions | |||
Network Drives | New Users to Excel | |||
Network Drives | Excel Programming | |||
Network drives | Excel Programming |