export text file in macro

[-DwayneWade]

I am writing an export text file function in macro using Access 97. I use
transfertext and export delimited. However when I run this macro, I got an
error message "the file is already existed" and stop processing. How can I
delete the file before I run this process in a macro? Thanks.

 

[Alex Dybenko]

Hi, you can use Kill statement:

strFile="c:\1.txt"

if len(dir(strFile)) >0 then
kill strFile
end if

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com