CharlesFS,
It's actually three lines; The first to change the drive letter; the second to change the directory and then the third to execute a script. If I dont do it that way the batchfile doesnt work. Ok So here it is.......
s:
cd \WC CSO PI - Local\Phones\Scripts\08 Tables\New Tables\...
PHV,
A batch file is an MS DOS application which will run in access. it took a bit of "remodeling" but i figured out that i had to change directories within the batch file. also i had to rename it with a .bat extention instead of .cmd and take out the spaces in the batchfile name. I...
Thanks Charles! Im brand new to VBA and Im not quite sure how to create the sub. I can cut and paste like a champ but Im not sure what I should and should not paste in a module. When I try to add the line Runcode in the macro I get error messages with the code as it is. Any chance you can...
Im creating a maco in Access that executes a batch file which executes a script that generates several txt files that are then imported into the database by the next action in the macro. How can I pause between the creation of the txt files and the transfer of said files for a minute so that...
Im creating a maco in Access that executes a batch file which executes a script that generates several txt files that are then imported into the database by the next action in the macro. How can I pause between the creation of the txt files and the transfer of said files for a minute so that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.