View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Origin of Immediate Window messages

At some time during the past few months, and since building a new machine,
after starting Excel (Excel 2002 SP3), certain output has been appearing in the
Immediate Window of the VBA Editor.

This did not appear on my old machine.

The appearance of these lines seems to occur if and only if atpvbaen.xls is in
the project list. This project will appear if it is either selected explicitly
as an add-in from Excel (Analysis Toolpak - VBA), or if there are references to
this in another project.

Any suggestions as to how keep this from happening? It's probably not a
functional issue, but I find it annoying.

Thanks.

--Ron

Contents of Immediate Window after normal startup
------------------------------------------
[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen] 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs]
[auto_open]
---------------------------------------

Contents after <shift startup
---------------------------------
[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen] WorkbookName = [ATPVBAEN.XLA]REG
[VerifyOpen] AnalysisPath = C:\Program Files\Microsoft
Office\Office10\Library\Analysis\ 2
[RegisterFunctionIDs] <
[RegisterFunctionIDs]
[auto_open]
-----------------------------------


--ron