By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,485 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,485 IT Pros & Developers. It's quick & easy.

VBA: Reciprocal functionality ?

P: n/a
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.
Feb 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Feb 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.