Unneeded VBAProject Side Effect

[SDruley]

Please Login or Register  to view this content.

The above code, which is enclosed in a Do Loop, produces a

VBAProject (quotes.csv)

that can be seen in the VBA Project window of the Visual Basic window.

The above code is triggered every 6 seconds, In a 5 minute period, 50 of these have accumulated in the project window. When i stop the code, they dissapear all by them selves.

Question:

Do I need to insert code to delete these eroneous, codeless vba projects at each loop?

[shg]

You're creating a new workbook in each iteration of the loop. If you don't want them to accumulate, close them inside the loop.

[SDruley]

shg,

I believe that is, in fact, what is happening. I am at a loss how to delete a "VBAProject" programmatically

[shg]

Close the workbooks, and the projects go with them (usually).

[SDruley]

I think I will programmatically close every hour then reopen.
Thanks,shg