Using a macro to export a table to dilimeted test

[bravo6]

I'm trying to use a macro to export a table to dilimeted text. It works but will only accept .txt as the output file extension. It would be great if I could get it to export to filename.kml. Is there a way to do this or to subsequently have a macro change the file name?

As always, thanks to you folks on this forum. You have saved me many times!

Dave

 

[PHV]

In VBA:
Name "filename.txt" As "filename.kml"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bravo6]

I don't know how to use VBA. Can this be done in a Macro?