run dos commands from Access? (2003 sp1)

Topic

New Reply

This is probably a really simple question, but I haven’t had to do this yet.

I need to run this dos command:

echo go>C:textfile.txt

I’d like to run via VBA code in my Access app. I think I can run it calling the BAT file it is in using the Shell command (found example on Dev Ashish’s website )

But I’d like to avoid the bat file all together. Is this possible, if so how?

Thanks.

Reply | Quote

Replies

You can use Shell as follows:

Shell “cmd /c echo go>C:textfile.txt”

cmd starts the command line processor, the /c switch indicates that it should quit after processing the command.

Reply | Quote

That worked. Thanks.

Reply | Quote