Invalid procedure call or argument error

Hi

I have the following code to open each file in a directory and then call on two other macros. It works for a little but then stops and I receive the "Invalid procedure call or argument" error at the line "Filename = Dir". Is there something I have wrong?

Please Login or Register  to view this content.

Do you have a Dir in one of the other routines?

Yes, it is in the "Test_File_Exists_With_Dir_v1" macro, as shown below"

Please Login or Register  to view this content.

any way this can be solved Kenneth?

I know of 4 ways. Some make an array of filenames. You can then iterate the array. If you have just the root folder to iterate, I can show you the Dir() method to create an array. Here is one such method.

Please Login or Register  to view this content.

My batch method gives you all the power and options of the command shell's DIR method which is nothing like VBA's Dir() method.

HTML Code: 

thank you Kenneth.

Where would I place the code above in relation to both of my macros?

this obviously gives me the names of the files but how can I use this in relation to my original problem Kenneth?

The test routines show how. Once you have the array, just iterate it in a For i = lbound(arrayname) to ubound(arrayname) or a For Each variantvariable in arrayname loop.

thanks Kenneth. Unfortunately I do not know how to do this. If you could assist me further, that would be really appreciated.

Please Login or Register  to view this content.

thanks Kenneth, worked perfectly.