Macro causes multiple instances of Excel in Task Manager

I have a workbook with an open event that gathers data from some number of closed workbooks. Each time I run the code another instance of Excel is added to the Task Manager. How do I prevent a second instance of Excel, or how do I close that second instance with in my code.

This has me stumped. Any help would be great.

Please Login or Register  to view this content.

Not sure what u are using xl for. You can still set the workbook without make a new instance of excel (This is what fill your taskmanager with another excel), since you running this within Excel.

Please Login or Register  to view this content.

I tried removing xl, which I had defined as "New Excel.Application". When I run the code it looks at one workbook and then bails.

I replaced

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

. This does prevent the second instance of excel! but when I open the workbook it it is not getting all of the data, but if I step through the code everything comes through fine.
I tried moving

Please Login or Register  to view this content.

to the end of my code but that did not keep the second instance of Excel from showing up and it was not getting all of the data.

Oh and

Please Login or Register  to view this content.

is a bad line I was trying to something I had found doing a Google search, and I missed that line when I deleted that set of code.

Actually I still need

Please Login or Register  to view this content.

and it needs to be before the quit. If I dont have the close than Excel thinks that the workbooks being acssessed are being closed improperly and creates a backup of the file.

I tried leaving

Please Login or Register  to view this content.

where it belongs and put

Please Login or Register  to view this content.

at the end of the code. after running the code I still have 2 instances of Excel, but everything works fine.
if I combine

Please Login or Register  to view this content.

and run the code there is only 1 instance of Excel but it does not pull all of the data. if I step through it everything works.

Okay. Not sure if this is the best fix but it seems to work. I placed

Please Login or Register  to view this content.

right be for the

Please Login or Register  to view this content.

loop. This prevents the second instance of excel.
I removed the error trap located here.

Please Login or Register  to view this content.

I am traping for errors here though

Please Login or Register  to view this content.

I added this trap since I was getting a run-time error 13 when I ran the code, but when I step through the code everything worked great.

here is the new working code.

Please Login or Register  to view this content.

I solved my problem but I think there might be a better way.

If I move the xl.Quit after the next there is still a second instance of Excel after I run through the code.

If I dont have the

Please Login or Register  to view this content.

then this line

Please Login or Register  to view this content.

generates a run-time error 13 when I run through the code. The odd thing about this error though is, I dont get it when I step through the code. Any thoughts?

I will try doing everything with in the active workbook.

Okay, I reworked the code so that it now runs in the existing instance of Excel. While this does prevent the second instance of Excel, I dont like how the screen "flickers" each time the closed workbook is opened even though I have the screen updating turned off. I am not sure who to fix this problem though.

As for xl = Nothing; I am not trying to close the appliction, I am attempting to free memory. This was one of my first VBA code projects so I didnt know much about coding. I have now moved it to the end of the code.

Please Login or Register  to view this content.

I am not selecting anything in the closed workbook. The code is looking at cells for value but it is not selecting them. when I step throug the code, the flicker happens on this line.

Please Login or Register  to view this content.