Run time Error 5: Invalid procedure or argument

[cmcconna]

Looking for somw hwlp on an error I am getting regrding the below script. The script works fine if I remove the update_new reference and opens and closes the workbooks within the folder.

However when I leave in the update_new reference it wont go any further than the first file found and returns

Run time Error 5: Invalid procedure or argument at the line

Please Login or Register  to view this content.

So this is after it has ran the update_new script. I think the problem is to do with the change in directory but cant figure it out. Apprecaite any help on it. Thanks

Please Login or Register  to view this content.

I have attached the update_new code in book1.xls

[broro183]

hi,

I'm not certain but I agree with you that Dir is likely to be affected by the other macro (perhaps the "saveas" sections).
To overcome this I suggest you loop right through the files & create an array of file names before processing them in the update_new macro. Here's an example of creating an array of filenames: http://spreadsheetpage.com/index.php...mes_using_vba/

hth
Rob