I am sure this has been answered many different ways, but I haven't had success in what results I have found and tried. But is there a way to execute a *.bat file thru access 2007 vba. Everything I have tried either quickly open and closes the cmd window with no results, does nothing, or just opens the cmd window and also does nothing. I have tried the Shell command and run app command.
The *.bat file runs successfully with scheduled tasks or manually executing it.
What the *.bat file does is automatically extracts a zip file to a specific folder.
Thank you in advance for all your help.