Upgrade to 2003, strange stuff in Immediate Window
 

Just upgraded to 2003 (I know, I work for the state), and now I'm seeing
the following "stuff" in the Immediate Window when I first open the VBE

[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen]

Is this useful somehow? If so, what does it mean?
Thanks in advance.

Upgrade to 2003, strange stuff in Immediate Window
 

It is some debugging code that the MS developers left in the VBA Analysis
Toolpak addin.

--
__________________________________
HTH

Bob

"salgud" wrote in message
. ..
Just upgraded to 2003 (I know, I work for the state), and now I'm seeing
the following "stuff" in the Immediate Window when I first open the VBE

[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen]

Is this useful somehow? If so, what does it mean?
Thanks in advance.

Upgrade to 2003, strange stuff in Immediate Window
 

Hi,

It's all debug code form the analysis toolpak VBA addin. AFAIK it's debug
messages that should have been removed.

The < means process started
the means process finished

Mike

"salgud" wrote:

Just upgraded to 2003 (I know, I work for the state), and now I'm seeing
the following "stuff" in the Immediate Window when I first open the VBE

[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen]

Is this useful somehow? If so, what does it mean?
Thanks in advance.

automatic confirmation of delete etc
 

I have a vba procedure that deletes "n" number of sheets; every time it
deletes one it forces me to respond manually to confirm if i want to go ahead
with the deletion.

Once the procedure is completed with nw information i want to save the file;
again I'm forced to intervene to confirm.

How can i avoid these interventions/

With thanks

Dave

Upgrade to 2003, strange stuff in Immediate Window
 

Thanks to both of you.

automatic confirmation of delete etc
 

near the beginning of your procedure enter:
Application.DisplayAlerts = False

and near the end:
Application.DisplayAlerts = True

hope that helps
:)
susan



On Jan 15, 1:27*pm, dave glynn wrote:
I have a vba procedure that deletes "n" number of sheets; every time it
deletes one it forces me to respond manually to confirm if i want to go ahead
with the deletion.

Once the procedure is completed with nw information i want to save the file;
again I'm forced to intervene to confirm.

How can i avoid these interventions/

With thanks

Dave

automatic confirmation of delete etc
 

Application.DisplayAlerts = False
Delete the sheets
Save the file
Application.DisplayAlerts = True


Gord Dibben MS Excel MVP

On Thu, 15 Jan 2009 10:27:03 -0800, dave glynn wrote:

I have a vba procedure that deletes "n" number of sheets; every time it
deletes one it forces me to respond manually to confirm if i want to go ahead
with the deletion.

Once the procedure is completed with nw information i want to save the file;
again I'm forced to intervene to confirm.

How can i avoid these interventions/

With thanks

Dave