"Compile Error: Sub or Function Not Defined" Please help

[BradPhillips]

I'm trying to use the following code to take information from a single worksheet in two different workbooks and "paste" the data into a worksheet in a master workbook. I keep getting the error "Compile Error: Sub or Function Not Defined" I have worked on it for 4 hours now and can't figure it out. Any one have an idea what I'm doing wrong?

Please Login or Register  to view this content.

Thanks!

[protonLeah]

Do you have a Sub named "CloseAll"? And where is it?

[BradPhillips]

There is a "CloseAll" near the bottom. Is that part incorrect?

[protonLeah]

For some reason, your Code box has no scroll bars so I can't see anything below the App..Screenupdating line. When I pasted your code and added an End Sub. The debugger highlighted the Call CloseAll line. Can you repost the code, please?

[Trebor76]

There is a "CloseAll" near the bottom. Is that part incorrect?

But there must be a macro in a open workbook called "CloseAll" to be executed (run). There currently isn't, so that's why the error message is appearing (as protonLeah was alluding to).

[BradPhillips]

Thanks guys! I got the macro to run, but don't have the macro closing the other two files, which is actually ok, it not better.

Here is my final code

Please Login or Register  to view this content.