In this ng we stay in the ORIGINAL thread

--
Don Guillett
SalesAid Software

"oasis" wrote in
message ...

Hi,

Would you please give me an example for how to use your code?

For instance, if I have a folder "c:\test" with these files "
c:\test\file1, c:\test\file2, c:\test\file3,c:\test\file4,...
c:\test\file100" in it. Each file only has one sheet named "sheet1",
and each worksheet contains 4 columns and various numbers of rows.
Column names are A, B, C, D respectively. Would you please be so kind
to tell me how to implement your code to this example?

Do I have to have VB running on my computer or can I just open one of
these files to use the VB Macro Editor to run the application?

Any help would be dearly appreciated. Thank you.

Susan


--
oasis
------------------------------------------------------------------------
oasis's Profile:
http://www.excelforum.com/member.php...o&userid=25991
View this thread: http://www.excelforum.com/showthread...hreadid=264207