Source of text in Immediate Window

[Helmut Weber]

Hi everybody,

playing around with VBA a lot,
and not quite unexperiencend,
when hitting [alt F11] today,
just having started Excel,
I found myself in the immediate window,
and the following text there:

[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] > 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs] >
[auto_open] >

Sure, this is caused by some(!) auto_open.
But where is it?

Why does it write a kind of protocol
in the immediate window?

Sure, must be a feature,
but totally new to me.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Helmut Weber]

Sorry, I'm confused,

that should be sent to excel.programming,
which I'll do right away.

But it really puzzled me.

HW

 

[Michael Bednarek]

Hi everybody,

playing around with VBA a lot,
and not quite unexperiencend,
when hitting [alt F11] today,
just having started Excel,
I found myself in the immediate window,
and the following text there:

[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] > 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs] >
[auto_open] >

Sure, this is caused by some(!) auto_open.
But where is it?

Why does it write a kind of protocol
in the immediate window?

Sure, must be a feature,
but totally new to me.

Not a feature but an oversight. There are 18 Debug.Print statements in
the Analysis Toolpak's (atpvbaen.xla) "VBA Functions and Subs" and
someone (at Microsoft?) forgot to comment (') them out.

After searching for the password for atpvbaen.xla, I fixed this
annoyance a long time ago. Among others, see:
<http://groups.google.com.au/group/m...5e2b210aa1a6bd?lnk=st&rnum=1#7b5e2b210aa1a6bd>

 

[Helmut Weber]

Hi Michael,

perfekt. All solved.
Lots of usedul functions in there.

Thank you.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"