Thanks for reading this post.
I am programmatically looping through N workbooks (open workbook, process, close workbook). When I close the workbook, I am left with a "footprint" of workbook in project explorer, even though the workbook itself is closed.
This is causing problems as well as slowing down the processing of the current workbook, the further into the series I am.
Any ideas? Or ways to delete/remove the VBProject?
Many thanks for your responses
UK Nod
Here's a code sample of what I'm doing
=============================
strFileName = Dir(strPath & "\" & strMask) ' get a wbk from disk that matches mask
Do While strFileName <> ""
lngLoopCounter = lngLoopCounter + 1
Workbooks.Open strPath & "\" & strFileName
Application.StatusBar = strFileName
'
' do some stuff
'
Application.StatusBar = False
Workbooks(strFileName).Close saveChanges:=True ' Save results
strFileName = Dir
Loop
I am programmatically looping through N workbooks (open workbook, process, close workbook). When I close the workbook, I am left with a "footprint" of workbook in project explorer, even though the workbook itself is closed.
This is causing problems as well as slowing down the processing of the current workbook, the further into the series I am.
Any ideas? Or ways to delete/remove the VBProject?
Many thanks for your responses
UK Nod
Here's a code sample of what I'm doing
=============================
strFileName = Dir(strPath & "\" & strMask) ' get a wbk from disk that matches mask
Do While strFileName <> ""
lngLoopCounter = lngLoopCounter + 1
Workbooks.Open strPath & "\" & strFileName
Application.StatusBar = strFileName
'
' do some stuff
'
Application.StatusBar = False
Workbooks(strFileName).Close saveChanges:=True ' Save results
strFileName = Dir
Loop