Strange stuff in Immediate window when Excel opens

E

Ed

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
 
N

Niek Otten

Hi Ed,

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

--
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
| 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
|
|
 
E

Ed

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
 
M

Michael Bednarek

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

in message |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?
 
E

Ed

Thanks, Jim -greatly appreciated.
Ed

Jim Cone said:
Ed,
You can edit the Analysis Toolpak code to clean it up...
http://snipurl.com/ztxw
--
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 said:
Hi Ed,

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

--
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
| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top