export txt without header

R

Roy

i tring to export a txt file, but i want to avoid the header to be there..
is that possible

thanks in advance
 
K

Klatuu

You will have to use the TransferText method or action. Once of the
arguments is HasFieldNames. You can look up the details in VB Help
 
R

Roy

it works, but now i have a text file with " at the begin and the end of every
line
is it possible to avoid the ""??

thanks
 
K

Klatuu

Use the Export wizard to do the export once manually. When the wizard opens,
select the Advanced button. You can then customize how the output is
formatted. Once you have that set up, click on Save As. Give it a name.
Use this name in the File Spec argument of the TransferText.
 
Top