VBA: Reciprocal functionality ?

[Alan Searle]

Dear All,

I am putting together a section of code which needs to scan a number of
directory trees. For example ...

c:\abc
c:\abc\def
c:\abc\hij
c:\abc\def\klm

.... and then put these into XML format for navigation with a web browser.

So far I have tried coding it up using VBA using tables (and SQL) or
internal arrays. I have had some success but keep coming up against
problems of blowing the 255 character limit in tables and with
reciprocal coding using arrays (i.e. a particular piece of code needing
to re-visit and re-processing a constantly growing array).

For example, once I have scanned each parent directory, I then need to
scan the child directories but I find that arrays are really unwieldy
when it comes to filtering and sorting. Tables are better but for
portability (later) I would rather do it in internal memory.

Anyway, I can't help thinking that I am probably busy 're-inventing the
wheel' here and there must certainly be blocks of code available to do
this? Maybe even a piece of functionality which directly spits my
structures out to XML?

Any tips or thoughts or pointers to 'HOWTOs' would be most gratefully
received.

Many thanks,
Alan Searle.

PS: remove the xxx to send me an e-mail.

[Lyle Fairfield]

You have considered and rejected something like:
<form action=folders.htm method=get>
<input id="file" name="file" type=file size="80"/>
</form>
which allows the user to browse his/her files and enter the selection
into a textbox?

trivial example at:
http://ffdba.com/folders.htm