How to get rid of a VBAProject?
Excell2002
WB(a) opens WB(1),WB(2),...,WB(n) successively, makes sg with them then colses them peacefully. Each of the WB(i) contains VBAProject too. After closing WB(i), its VBAProject remains still existing, that causes the application stall. How coud I get rid of the VBAProject belonging to a closed WB? SOS! |
How to get rid of a VBAProject?
Maybe this is your problem
If you Dim outside your macro like this at the top of your module Dim WB As Workbook Sub test() Set WB = Workbooks.Open("c:\data\ron.xls") 'your code WB.Close False End Sub You still can see the VBAProject in the VBE Use this then Sub test() Set WB = Workbooks.Open("c:\data\ron.xls") 'your code WB.Close False Set WB = Nothing End Sub Or Dim in the macro -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "GF" wrote in message ... Excell2002 WB(a) opens WB(1),WB(2),...,WB(n) successively, makes sg with them then colses them peacefully. Each of the WB(i) contains VBAProject too. After closing WB(i), its VBAProject remains still existing, that causes the application stall. How coud I get rid of the VBAProject belonging to a closed WB? SOS! |
All times are GMT +1. The time now is 03:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com