My messages do not appear to be posting; I'll try again...

Thanks to both RVG and RP for the help!

I don't have much experience with VB/VBA Windows API calls or, shell calls.
I'd like to learn more about subject; any book or website suggestions ?

Thanks again for your assistance!

Rob F



"Rob" wrote in message
news:HZiJd.27978$IV5.1294@attbi_s54...
Hey folks,

I'm a little rusty with my VBA...

I created a few lines of code that will allow me to insert the names of
each directory and all of the files from each directory to a word
document. I will eventually pass the same info into an excel sheet.
Eventually, I may find a need to create a hyperlink to each folder/file
but that is way down the line. I did it once in JAVA, but lost the code
years ago due to non-use. I also hate JAVA, but thats not the issue here.

My code works perfectly, but I added a full path (i.e "C:\Temp") to my
fuction call.

What I want to do is allow the user to pick the directories to copy using
(what I think is called) a windows common dialog box.

Once I select the folder I wish to start in, I want to pass the full path
to my function call (in a string variable)

I tried this with with the filedialog property, but you cannot pick a
folder (you must pick a file)

Any ideas?