thanks
your macro save me a lot of time.

Bob Phillips Wrote:
"ditzafar" wrote
in
message ...

I have same questions.
1. im aryFiles did you mean dim aryfiles. if you mean it, for what do
I
need it?

I do, the copy got chopped.

2. for what do I need Dim i As Integer

You don't need either, I cut this from some other code, and left some
redundant stuff in.

3. selectFiles "c:\MyTest" did it is the name of the folder
if it the name of the folder where does this macro run on all the
files

Yes

4.when I runing this macro I get a erro message "sub or function not
define".
for the function selectFiles

I don't, I am not sure why you should. As you can see the sub exists.

5. Should I call my macro between this two line

I have marked where you should call your macro.


--
ditzafar
------------------------------------------------------------------------
ditzafar's Profile: http://www.excelforum.com/member.php...o&userid=29475
View this thread: http://www.excelforum.com/showthread...hreadid=497905