Strange stuff in Immediate window when Excel opens

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 19 Oct 2006 18:16 GMT

I ran a macro and had it print to the Immediate window. When I was done, I
cleared the window and closed Excel. I just reopened Excel and the
Immediate window, and I see this:
[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] > 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs] >
[auto_open] >

This was there the last time I opened the Immediate window, too, but I
dismissed it as "leftovers" from some mucked-up previous macro. (I get that
"every now and then"!!) Apparently, though, there's some processes that are
happening at open? Where do I begin to look?

Ed

Reply to this Message

Niek Otten - 19 Oct 2006 18:41 GMT

Hi Ed,

It seems to be a leftover from Analysis Toolpak. I've not seen it in Excel2007; a clean start hopefully

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I ran a macro and had it print to the Immediate window. When I was done, I
| cleared the window and closed Excel. I just reopened Excel and the
[quoted text clipped - 16 lines]
|
| Ed

Reply to this Message

Ed - 19 Oct 2006 21:27 GMT

Hi, Niek. Thanks for the response. I do load the Analysis Toolpak add-in.
Do you think this means trouble? Or can it be safely ignored?

Ed

> Hi Ed,
>
[quoted text clipped - 24 lines]
> |
> | Ed

Reply to this Message

Jim Cone - 20 Oct 2006 01:30 GMT

Ed,
You can edit the Analysis Toolpak code to clean it up...
http://snipurl.com/ztxw

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Ed" <ed_millis@NO_SPAM.yahoo.com>
wrote in message
Hi, Niek. Thanks for the response. I do load the Analysis Toolpak add-in.
Do you think this means trouble? Or can it be safely ignored?
Ed

"Niek Otten" <nicolaus@xs4all.nl>
wrote in message

> Hi Ed,
>
[quoted text clipped - 24 lines]
> |
> | Ed

Reply to this Message

Ed - 20 Oct 2006 20:06 GMT

Thanks, Jim -greatly appreciated.
Ed

> Ed,
> You can edit the Analysis Toolpak code to clean it up...
[quoted text clipped - 29 lines]
>> |
>> | Ed

Reply to this Message

Michael Bednarek - 20 Oct 2006 03:25 GMT

>Hi, Niek. Thanks for the response. I do load the Analysis Toolpak add-in.
>Do you think this means trouble? Or can it be safely ignored?

It can safely be ignored. If it bothers you, turn all 18 Debug.Print
statements in atpvbaen.xla into comments.

>> It seems to be a leftover from Analysis Toolpak. I've not seen it in
>> Excel2007; a clean start hopefully
[quoted text clipped - 17 lines]
>> | "every now and then"!!) Apparently, though, there's some processes that are
>> | happening at open? Where do I begin to look?

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message

Rate this thread: