LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #19   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Closed workbooks still appear in VBE?

FWIW, this is (some of) the output from Process Explorer for Excel 2002 on
Win2K. Never had the phantom problem.
http://www.microsoft.com/technet/sys...sExplorer.mspx

Maybe see how it compares to yours. Note I have Acrobat and Winfax installed
I have no idea what a .box file is though. Anyone ?

NickHK

Process: EXCEL.EXE Pid: 796

File C:\Documents and Settings\Nick\Desktop
File C:\Documents and Settings\Nick\Application
Data\Microsoft\Excel\XLSTART\PERSONAL.XLS
File C:\Documents and Settings\Nick\Local Settings\Temp\~DFA732.tmp
File C:\Program Files\Microsoft Office\Office XP\Office10\EXCEL.EXE
File C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
File C:\WINNT\system32\FM20.DLL
File C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL
File C:\WINNT\system32\STDOLE2.TLB
File C:\Documents and Settings\Nick\Local Settings\Temp\568.tmp
File C:\Documents and Settings\Nick\Local Settings\Temp\~DFA4F8.tmp
File C:\Documents and Settings\Nick\Application
Data\Microsoft\Excel\XLSTART\PDFMaker.xla
File C:\Documents and Settings\Nick\Local Settings\Temp\~DFA94D.tmp
File C:\Program Files\Adobe\Acrobat 6.0\PDFMaker\Common\AdobePDFMakerX.tlb
File C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
File C:\Documents and Settings\Nick\Local Settings\Temp\VBE\MSForms.exd
File C:\Program Files\Microsoft Office\Office
XP\Office10\XLStart\WFXL2000.XLS
File C:\Documents and Settings\Nick\Local Settings\Temp\~DFB806.tmp
File \Device\KsecDD
File C:\Documents and Settings\Nick\Local Settings\Temporary Internet
Files\Content.MSO\8F41B51E.emf
File C:\Program Files\Common Files\Microsoft Shared\Smart Tag\FNAME.DLL
File C:\Program Files\Common Files\Microsoft Shared\Smart
Tag\Lists\STOCKS.DAT
File C:\Program Files\Common Files\Microsoft Shared\Smart Tag\MOFL.DLL
File C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
File C:\Documents and Settings\Nick\Application
Data\Microsoft\Forms\EXCEL.box
File C:\Documents and Settings\Nick\Local Settings\Temp\~DFD533.tmp
File C:\Documents and Settings\Nick\Local Settings\Temp\~DFD53E.tmp
File C:\WINNT\system32\FM20.DLL
File C:\Documents and Settings\Nick\Application
Data\Microsoft\Forms\MSComctlLib.exd
File C:\Documents and Settings\Nick\Local Settings\Temporary Internet
Files\Content.MSO\246E2687.emf
File C:\Program Files\MZTools\MZTools3VBA\
File C:\Documents and Settings\Nick\Local Settings\Temp\~DFC03C.tmp
File C:\WINNT\system32\MSVBVM60.DLL
File C:\WINNT\system32\MSCOMCTL.OCX
File C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL


"robotman" wrote in message
oups.com...
Hi Dave,

I didn't realize I had to choose the "Tools" category under the
Command Tab. I now see where the "COM Add-ins" is.

I added the button and there are no COM add-in's available. So I'm
back to square one.

Any other ideas what can be causing the phantom workbooks? It is a
strange problem. I'm still suspicious of this other complex charting
macro that I run. Even though it's not loaded when I start Excel, is
there any way it left behind some residual code or setting that is
causing the problem?

Thanks.

John



 
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
Getting Data from Closed Workbooks NPell Excel Worksheet Functions 3 April 2nd 08 10:28 AM
Information from Closed workbooks PaulW Excel Discussion (Misc queries) 1 August 24th 06 09:20 PM
Get Properties Of Closed Workbooks MDW Excel Programming 1 July 5th 06 05:23 PM
Get two Values from closed Workbooks Roger Larsson Excel Programming 2 January 17th 06 09:37 AM
get data from closed workbooks! Martyn Excel Programming 4 July 3rd 04 08:28 AM


All times are GMT +1. The time now is 02:22 PM.

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"