Unfortunately not, especially assuming you want to use the layout you
mentioned in your recent message.
Generally speaking, probably the safest delimiters to use are comma or <tab>
for the field delimiter (and even <tab> can have its problems) and
"paragraph mark" for the record delimiter. If your data includes either
delimiter, you have to wrap the data item in double quotes.
As far as I know, the only way to specify a particular field delimiter in a
text file in a way that will prevent Word asking is to ensure that Word uses
ODBC to open the file (e.g. using an OpenDataSource call in VBA), and
specify the field delimiter in a SCHEMA.INI file in the same folder as the
text file. However
a. you can only specify the field delimiter. As far as I know ODBC always
expects the record delimiter to be a line end (CRLF)
b. using ODBC may reduce the maximum number of fields to 255
You haven't stated the reasons for wanting to do things the way you are
doing them, but assuming it is vital to start with that format, all I can
suggest is that if necessary you consider
a. preprocessing the file into a format that Word will recognise without
popping up boxes (e..g tab field delimiters, CRLF record delimiters)
b. using .dat extension if you are using a plain text file (this helps
avoid use of ODBC
c. "rolling your own" merge to read the data directly.
