Close workbooks and move in and out of workbooks in VBA

Dear all,

Thank you for reading my post.

My macro is very simple. Basically the main workbook opens 2 files at a time performs a calculate in the main workbook and then copies and pastes information in 3 ranges. Then closes the two open workbooks and loops and performs same operations until it hits the maximum loops.

My macro is as follows and I have 3 question in capital letters.

Sorry i am a beginner and appreciate your help, regards John

Please Login or Register  to view this content.

Try to utilize this code to fit in with your existing code
http://support.microsoft.com/kb/147742

Hi I marked it as solved so that you dont delete my othe post.

But honestly its not solved.

Regards John



Moderator note: discussion continues in this thread