Pete,

I'm still a little confused. The dialog box title says "Open" but it
doesn't, and shouldn't, open a file. So the button should not say "Open" as
you suggested. It's just to pick a name of an existing file. The Browse
button is directly related to "File name to write." I can change the title
of the dialog -- something like "Select file name." I'll put that in a
subsequent release. Or have I totally missed your point.

As for Excel's limited text capabilities, they're legend. That's why I
wrote a simple little program, and it got popular, so I expanded it over the
years. I remember once finding some strangeness in the way Excel reads a
text file, the details of which escape me at the moment, where Access
handled it perfectly.

Let us know when your site is up.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Total Hosting 1" <TotalHosting1@discussions.microsoft.com> wrote in message
news:A1BBA6A4-25F4-48C8-9609-60606AE583C6@microsoft.com...
> Hi earl,
>
> No, it's not GerWacko. I am just telling you what I *expected* to have
> happen. It did in fact open a dialog to open an existing file. But since
> it's
> on the same line as the file name field (and follows immediately after
> "File
> Name to Write" I just expected it to behave differently than it did.
> Again,
> due to it's proximity to a completely different type of function, but one
> in
> which the same interface widget (i.e. "browse button") couild be
> applicable.
> A simple change from "browse" to "open" might make it easier. Prehaps
> swapping the "FNtw" and "Browse" might be useful. Trust me, I am no
> technophile, but I did get confused.
>
> As far as the rectangular selection, that was perfect. EXACTLY what I
> needed. Of course it was right there in the "help" if I had bothered to
> look.
>
> I am still blown away by the fact that Excel is so limited in it's export
> capabilities. The functionality is right there in Access. But not in
> Excel.
>
> Sheesh!
>
> Well thanks for the superb job. I am just putting finishing touches on my
> new site. I am going to throw you a link in my "resources" section.
>
> Pete
>
> "Earl Kiosterud" wrote:
>
>> 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.
>> --
>> Earl Kiosterud
>> mvpearl omitthisword at verizon period net
>> -------------------------------------------
>