|
|
|
#1
03-09-2010, 06:10 PM
|
|||
|
|||
Running Batch File
Hi I really have limited experience with VBA but I am looking for a way to integrate the ability to have access run a Macro and have one of the steps call a .bat file located in a directory that is setup to create a .txt file of that directory's files. The kicker is that the macro needs to wait until the file is completed (CMD window disappears) before moving onto the next steps of the macro. Please see attached sample.
|
|
#2
03-11-2010, 03:32 AM
|
|||
|
|||
|
Instead of calling a .bat file you could just write the code in vb using the File System Object - do a search for fso and see what comes up. Or check out this link: http://allenbrowne.com/ser-59.html - it may be helpful.
Good luck 
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Newbie Alert! Help to create Batch Number | Vikki | Access | 1 | 02-09-2010 09:39 PM |
| Batch Update to Access Table (random fields and records) | cryswater | Access | 5 | 01-05-2010 07:22 PM |
| Open Accesss DB by batch script | micada | Access | 0 | 06-10-2008 12:33 PM |
| New Database - Batch processing | stevo2820 | Database Design | 0 | 04-30-2007 12:22 AM |
| Shell with Batch Variables | robbyaube | Programming | 0 | 12-12-2005 06:40 AM |
Windows XP 
Access 2003 (version 11.0)
Linear Mode
