Pete,
Thanks for the feedback.
As for the browse button, it's job is to give you a file - open dialog, and
to only put any selected file name into the name box of the Setup sheet. It
shouldn't open any files, or start any programs. If it does, something is
gerwhacko. Let me know.The dialog lists all files, and starts in the
current Excel folder, which you can change while you're in the dialog. If
you change folders while in that dialog, the Excel default path (current
folder) will be changed, which will determine where the file is written, per
Windows file specification rules. I hope, anyway.
a.txt - put file in Excel default path, default drive.
\a txt - put file in root of default drive. Ignore the default path
(current folder).
MyFolder\a.txt - put file in folder MyFolder, which should already be in the
Excel default path.
\MyFolder\a.txt - put file in MyFolder, which should already be in the root
of the default drive. Ignore the default path.
D:\Myfolder\MyDeeperFolder\a.txt - put file in drive and path specified,
ignoring default drive and default path.
As for writing the additional delimiters until a fixed count of fields has
been written to each record, per your example, the program normally does not
do that, but will do so if you use the "Write rectangular" option. You must
manually select the range it's to use, which determines how many fields to
write in each record (as well as how many records to write). You can have it
expand the selection from a single selected cell (as with sorting, charts,
etc.), if your data is contiguous and not adjacent to other data. If this
doesn't work that way, or doesn't meet your needs, let me know.