Bob,
I've completed my code and tested successfully. Funny now, it took
more words to describe the problem than the actual code :) Viva Excel
& VBA !

Thanks. Your GetFolder routine was imo the piece that I needed help
with, the most.

Regards

Anna

"Bob Phillips" wrote in message ...
Hi Anna,

Good news all round.

We'll see you with the next round<g.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"annapuvat" wrote in message
om...
Folks, thank you all for detailed (and intimidating ;-) ) response.
I'm able to incorporate Bob Phillips' function into my program.
I sought help/samples for my program in an earlier post on 2/20/04 -
subject: Compare Worksheets. The program is to compare workbooks from
two user specified folders.I was able to use GetOpenFilename for
accepting one set of user-specified workbooks. Using Bob's GetFolder
function, I am able to get get the location of workbooks to be
compared. These workbooks have the same name as in the first folder. I
am looking to compare workbooks in the two folders as detailed in my
post of 2/20. Using a sample from Tom Ogilvy, I've progressed a bit,
using Application.Match to locate matching row between two workbooks.
I'm trying to figure out the command(s) that will compare individual
cells on a matched row and highlight difference.
For a newbie, my progress has been sure, but painfully slow. This
group is a great resource. Thanks again, and in anticipation for all
your help

-Anna