LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Closed Excel but Vba project remained

I have a sub that opens several workbooks (with macros embedded).
at the end of the sub I have

workbooks("book1.xls").close true ' to close all but 1 workbook

the workbooks are closed but if I open vba window, I can still see the vba
projects.

if I do debug.print workbooks(2).name I get out of range error -- which i
assume the object no longer exists ...

how can i truely close workbooks?

application.quit?

I want to close all but 1 workbook.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA project does not close when workbook is closed SimonN Excel Programming 5 July 1st 20 05:47 AM
VBA project does not close when workbook is closed Simon Norris Excel Programming 5 March 2nd 16 05:34 PM
Project still in "project explorer" window after file closed down! Gunnar Johansson Excel Programming 16 December 22nd 04 06:21 PM
Project still in "project explorer" window after file closed down! Gunnar Johansson[_3_] Excel Programming 0 December 7th 04 01:43 PM
VBA project does not close when workbook is closed SimonN Excel Programming 3 October 25th 04 09:23 PM


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"