I would like to be able to execute the following command from within an MS
Access code module (FOR /F "delims=~" %%f in (Cust_and_DelAddr_Folders.txt)
DO MD "%%f") Which is normally run through "cmd.exe".

Is this possible?

Sure, use the Shell function...

Dim strCmd As String
strCmd = "rgsvr32 somefile.dll"
Shell strCmd


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Blaze" wrote:

> I would like to be able to execute the following command from within an MS
> Access code module (FOR /F "delims=~" %%f in (Cust_and_DelAddr_Folders.txt)
> DO MD "%%f") Which is normally run through "cmd.exe".
>
> Is this possible?

Come to think of it, if you have this already in a cmd or bat file you can
shell the file itself...

Shell """C:\Progs and Settings\yourcmd.cmd"""


note that if you need quotes in a string to be shelled they have to be
included as they would for a where string.

hth

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Jack Leach" wrote:

> Sure, use the Shell function...
>
> Dim strCmd As String
> strCmd = "rgsvr32 somefile.dll"
> Shell strCmd
>
>
> --
> Jack Leach
> www.tristatemachine.com
>
> "I haven''t failed, I''ve found ten thousand ways that don''t work."
> -Thomas Edison (1847-1931)
>
>
>
> "Blaze" wrote:
>
> > I would like to be able to execute the following command from within an MS
> > Access code module (FOR /F "delims=~" %%f in (Cust_and_DelAddr_Folders.txt)
> > DO MD "%%f") Which is normally run through "cmd.exe".
> >
> > Is this possible?

and one last thing... I've had this sitting around for a while and never
tried it, but you apparently can read the output lines of whatever command
you run... could come in quite handy

http://www.j.nurick.dial.pipex.com/C.../vbPerlish.htm

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Jack Leach" wrote:

> Come to think of it, if you have this already in a cmd or bat file you can
> shell the file itself...
>
> Shell """C:\Progs and Settings\yourcmd.cmd"""
>
>
> note that if you need quotes in a string to be shelled they have to be
> included as they would for a where string.
>
> hth
>
> --
> Jack Leach
> www.tristatemachine.com
>
> "I haven''t failed, I''ve found ten thousand ways that don''t work."
> -Thomas Edison (1847-1931)
>
>
>
> "Jack Leach" wrote:
>
> > Sure, use the Shell function...
> >
> > Dim strCmd As String
> > strCmd = "rgsvr32 somefile.dll"
> > Shell strCmd
> >
> >
> > --
> > Jack Leach
> > www.tristatemachine.com
> >
> > "I haven''t failed, I''ve found ten thousand ways that don''t work."
> > -Thomas Edison (1847-1931)
> >
> >
> >
> > "Blaze" wrote:
> >
> > > I would like to be able to execute the following command from within an MS
> > > Access code module (FOR /F "delims=~" %%f in (Cust_and_DelAddr_Folders.txt)
> > > DO MD "%%f") Which is normally run through "cmd.exe".
> > >
> > > Is this possible?