I am doing this approx 150-200 times in a loop
For i = 1 to 150
Open Workbook

You loop shows you doing 150 times.

within the loop, you would probably be best advised to work on a single
workbook and then close it before opening the next.

Other than that, you would have to state what your actual question is.

--
Regards,
Tom Ogilvy

"Phil Berkhof" wrote in message
...
I am doing this approx 150-200 times in a loop
For i = 1 to 150
Open Workbook