Automating Tasks

[billheath]

I am trying to write a VB procedure to automaticall export a table into a text file. I have set up the export specs. I can open the table, and then execute the &quot;save as&quot; function. How do I send key strokes to each window without user input.&nbsp;&nbsp;I tried using &quot;SendKeys&quot; with no luck.&nbsp;&nbsp;I am using Access 97.<br>Thanks<br>Bill<br>&nbsp;

 

[JARE]

IN VB CODE -<br><br><br>docmd.OutputTo acOutputTABLE, &quot;TABLE NAME&quot;, acFormatTXT, <br>&quot;C:\mydocs&quot; & [FIELD1] & &quot;TEXT&quot; &quot;.txt&quot;, -0<br><br>Will create a text file named [field1]TEXT.txt<br><br>

 

[desiboy]

Use the TransferDatabase function. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=

http://www.matatechnologies.com>Mata

Technologies</a><br>sign up for our free Discussion list: "Access Tips And Tricks" at

http://www.matatechnologies.com