2 Copies of The Same Workbook Open in Task Manager

gmccreedy · Oct 2nd 2006

I have had some problems closing down a workbook that I have. During a save and close. A duplicate file appears and causes considerable time delay...sometimes even causes a windows crash. I can't find the source of the problem, but I have noticed that in the Windows Task Manager, the file is there as well, yet not visible on the screen.

Can anyone decipher my problem and have a remedy for this?

gmccreedy · Oct 2nd 2006

Re: Multiple Workbooks Open

perhaps I should elaborate more on this. (I just read what I posted and even I was confused by it.)

On start up of a workbook, a series of macros are executed to do numerous tasks such as copying info from another workbook, creating a drop-down menu, etc.

For the sake of argument, lets call the file name test.xls

After workbook open is completed on test.xls....If I view the Windows Task Manager, there is two files posted....

Microsoft Excel - Test.xls
Test.xls

(Please note that the "Windows in Taskbar" option is checked, yet only one file can be seen in the taskbar) Is it me or is this weird?

I believe that this becomes the source of my problems on close...this "other" file all of a sudden appears (so two are now visible)...and it really lags my comp.

any suggestions?

The file size for test.xls is about 2.5 megs at most, so the file is not that big to really be causing the lag.

the weird part about it...the lag only really occurs if you leave the file open for a considerable period of time or alot of work is done. Other than that, it can be saved and close pretty quickly.

gmccreedy · Oct 2nd 2006

Re: Multiple Workbooks Open

I think this is my problem here.

http://www.ozgrid.com/forum/sh…38&highlight=task+manager

Not sure if you consider this a double post Mods...I just wasn't sure how to word it.

txaggie · Oct 2nd 2006

Re: Multiple Workbooks Open

I'm not sure if this is what you want, but this code will terminate Excel for me (2003 SP2).

Code

Option Explicit
Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As Any, ByVal lpWindowName As Any) As Long
Declare Function PostMessage Lib "user32" Alias "PostMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long


Sub Terminate_Excel()
    Dim lpClassName As String
    Dim iHwnd As Long
    Dim iReturn As Long
    Const WM_QUIT = &H12
    lpClassName = "XLMain"
    Do
'        iHwnd = FindWindow("XLMain", Application.Caption)
        iHwnd = FindWindow(lpClassName, 0&)
        If iHwnd = 0 Then Exit Do
'        Debug.Print iHwnd
        iReturn = PostMessage(iHwnd, WM_QUIT, 0&, 0&)
    Loop
End Sub

Display More

hope this helps.

Dave Hawley · Oct 3rd 2006

Re: Multiple Workbooks Open

Quote

Not sure if you consider this a double post Mods...I just wasn't sure how to word it.

If you had read the rules you are bound by you will not you are specifcally asked NOT to post any questions in the Thread of another member.

Perhaps you code is causing it in some way. Opening another Window of the same Workbook?

Dave Hawley · Oct 3rd 2006

Re: Multiple Workbooks Open

FYI, creating a New Window of any open Workbook is very likley the cause.

gmccreedy · Oct 3rd 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

apologies Dave. No excuse for it.

As far as when the or where the problem is...I am not opening a new window of the same workbook.

What is happening is, the workbook opens....on the workbook open event, another workbook is open, this workbook is set to an autofilter, then information is copied, closed without saving, then the information is pasted into the other workbook. the clipboard is then cleared.

But from what i have read, the copying and pasting could be the source of the problem and the reason for the excessive delay in saving and closing of the workbook.

I haven't had a chance to look at the code above, once I get to work, will take a look and see if this will help. thanks.

Dave Hawley · Oct 3rd 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

The only way I can reproduce the problem is to create a New Window of an open Workbook. This can also happen when/if the Workbook is saved as a Workspace

gmccreedy · Oct 3rd 2006

Re: Multiple Workbooks Open

txaggie, what does the code you posted do? I see that it exits excel, but is it doing anything special?

dave, When i get to work in an hour I will capture an image of the task manager so you can see it. Not sure if you can recreate this situation. Like i said, I have never seen this before and happened to stumble on it when one of my employees couldn't get there workbook to save without crashing.

Dave Hawley · Oct 3rd 2006

Re: Multiple Workbooks Open

I don't need to see an image. As I stated "The only way I can reproduce the problem is to create a New Window of an open Workbook"

When the Workbook is open and problem occurs, go to Window and see if you see YourBook.xls: 1 and YourBook.xls: 2

txaggie · Oct 3rd 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

The code I posted looks for all instances of open Excel workbooks. It doesn't just close them, it terminates Excel, even those that just show up in the Task Manager.

gmccreedy · Oct 3rd 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

Dave,

I know you didn't want to see this, but I figured this may be helpful for others who may have the problem.

The file in question here is entitled Glenn McCreedy.xls

Notice the two instances of the file. This is during normal operation of the file. I am looking into when the file crashes right now.

gmccreedy · Oct 3rd 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

Here is the crash...

jolivanes · Oct 3rd 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

gmccreedy.
I see exactly the same thing on my problem. I have not figured it out yet. In my case, the userform opens some folders and others, on the same drive, it does not. It works great and for no reason that I can think of, it hangs. I am still at a loss on what causes this. If I do happen to stumble on a solution, I'll let you know right away. Regards.

John

Dave Hawley · Oct 4th 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

gmccreedy, help is a 2-way communication. I cannot help if you don't answer my questions.

gmccreedy · Oct 4th 2006

Re: Multiple Workbooks Open

Quote from Dave Hawley

I don't need to see an image. As I stated "The only way I can reproduce the problem is to create a New Window of an open Workbook"

When the Workbook is open and problem occurs, go to Window and see if you see YourBook.xls: 1 and YourBook.xls: 2

Sorry Dave,

I am not sure I follow you then. I thought you meant to look in task manager for the files you requested, which i don't see as described in my previous posts above. what do you mean by "go to window"?

Dave Hawley · Oct 4th 2006

Re: Multiple Workbooks Open

Window on the Worksheet Menu Bar in Excel

gmccreedy · Oct 4th 2006

Re: Multiple Workbooks Open

Quote from Dave Hawley

Window on the Worksheet Menu Bar in Excel

never mind....gotcha now. Going to recreate problem again and look

gmccreedy · Oct 5th 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

can't check the window menu during crash...program is "not responding".

Dave Hawley · Oct 6th 2006

Re: 2 Copies of The Same Workbook Open in Task Manager

Step through the code with F8 and see which line is causing the problem.

2 Copies of The Same Workbook Open in Task Manager

Participate now!

Share