+ Reply to Thread
Results 1 to 8 of 8

opening Immediate window

  1. #1
    Stefi
    Guest

    opening Immediate window

    Hi All,

    I use XL2003. When opening Immediate window I get in it the lines below.
    What are these, why are they there and how can I get rid of them?

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

    Thanks,
    Stefi



  2. #2
    Norman Jones
    Guest

    re: opening Immediate window

    Hi Stefi,

    These are debug messages from the Analysis ToolPak Addin which the
    developers forgot to remove.

    Without gainning accessto the addin code, there is little that you can do
    other than delete each time,


    ---
    Regards,
    Norman



    "Stefi" <Stefi@discussions.microsoft.com> wrote in message
    news:AE5D3717-C316-4C94-8712-168C30574ADC@microsoft.com...
    > Hi All,
    >
    > I use XL2003. When opening Immediate window I get in it the lines below.
    > What are these, why are they there and how can I get rid of them?
    >
    > [auto_open] <
    > [SetupFunctionIDs] <
    > [SetupFunctionIDs] >
    > [PickPlatform] <
    > [PickPlatform] >
    > [VerifyOpen] <
    > [VerifyOpen] > 1
    > [RegisterFunctionIDs] <
    > [RegisterFunctionIDs] >
    > [auto_open] >
    >
    > Thanks,
    > Stefi
    >
    >




  3. #3
    Bob Phillips
    Guest

    re: opening Immediate window

    This is some debugging code that the developers of the Analysis Toolpak -
    VBA addin put in the code, and they seem to have failed to remove it before
    shipping. Nothing you can do about it I am afraid, we all suffer it.

    --

    HTH

    Bob Phillips

    (replace xxxx in the email address with gmail if mailing direct)

    "Stefi" <Stefi@discussions.microsoft.com> wrote in message
    news:AE5D3717-C316-4C94-8712-168C30574ADC@microsoft.com...
    > Hi All,
    >
    > I use XL2003. When opening Immediate window I get in it the lines below.
    > What are these, why are they there and how can I get rid of them?
    >
    > [auto_open] <
    > [SetupFunctionIDs] <
    > [SetupFunctionIDs] >
    > [PickPlatform] <
    > [PickPlatform] >
    > [VerifyOpen] <
    > [VerifyOpen] > 1
    > [RegisterFunctionIDs] <
    > [RegisterFunctionIDs] >
    > [auto_open] >
    >
    > Thanks,
    > Stefi
    >
    >




  4. #4
    Bob Phillips
    Guest

    re: opening Immediate window

    oh, I suppose you could uninstall that addin.

    --

    HTH

    Bob Phillips

    (replace xxxx in the email address with gmail if mailing direct)

    "Stefi" <Stefi@discussions.microsoft.com> wrote in message
    news:AE5D3717-C316-4C94-8712-168C30574ADC@microsoft.com...
    > Hi All,
    >
    > I use XL2003. When opening Immediate window I get in it the lines below.
    > What are these, why are they there and how can I get rid of them?
    >
    > [auto_open] <
    > [SetupFunctionIDs] <
    > [SetupFunctionIDs] >
    > [PickPlatform] <
    > [PickPlatform] >
    > [VerifyOpen] <
    > [VerifyOpen] > 1
    > [RegisterFunctionIDs] <
    > [RegisterFunctionIDs] >
    > [auto_open] >
    >
    > Thanks,
    > Stefi
    >
    >




  5. #5
    Norman Jones
    Guest

    re: opening Immediate window

    Hi Stefi,

    MZ tools has a free addin which includes numerous useful additions to the
    VBE environment, including a nice eraser toolbar button to clear the
    immediate window:

    http://www.mztools.com/index.htm


    ---
    Regards,
    Norman


    "Norman Jones" <normanjones@whereforartthou.com> wrote in message
    news:uZ4gWNdmGHA.1576@TK2MSFTNGP05.phx.gbl...
    > Hi Stefi,
    >
    > These are debug messages from the Analysis ToolPak Addin which the
    > developers forgot to remove.
    >
    > Without gainning accessto the addin code, there is little that you can do
    > other than delete each time,
    >
    >
    > ---
    > Regards,
    > Norman




  6. #6
    Stefi
    Guest

    re: opening Immediate window

    Not a joy, but thanks for the reply! Uninstalling Analysis Toolpak - VBA gave
    a temporary relief, it is rarely used!
    Stefi


    „Bob Phillips” ezt *rta:

    > oh, I suppose you could uninstall that addin.
    >
    > --
    >
    > HTH
    >
    > Bob Phillips
    >
    > (replace xxxx in the email address with gmail if mailing direct)
    >
    > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
    > news:AE5D3717-C316-4C94-8712-168C30574ADC@microsoft.com...
    > > Hi All,
    > >
    > > I use XL2003. When opening Immediate window I get in it the lines below.
    > > What are these, why are they there and how can I get rid of them?
    > >
    > > [auto_open] <
    > > [SetupFunctionIDs] <
    > > [SetupFunctionIDs] >
    > > [PickPlatform] <
    > > [PickPlatform] >
    > > [VerifyOpen] <
    > > [VerifyOpen] > 1
    > > [RegisterFunctionIDs] <
    > > [RegisterFunctionIDs] >
    > > [auto_open] >
    > >
    > > Thanks,
    > > Stefi
    > >
    > >

    >
    >
    >


  7. #7
    Stefi
    Guest

    re: opening Immediate window

    Thanks Norman, I downloaded it, it looks fine!
    Stefi


    „Norman Jones” ezt *rta:

    > Hi Stefi,
    >
    > MZ tools has a free addin which includes numerous useful additions to the
    > VBE environment, including a nice eraser toolbar button to clear the
    > immediate window:
    >
    > http://www.mztools.com/index.htm
    >
    >
    > ---
    > Regards,
    > Norman
    >
    >
    > "Norman Jones" <normanjones@whereforartthou.com> wrote in message
    > news:uZ4gWNdmGHA.1576@TK2MSFTNGP05.phx.gbl...
    > > Hi Stefi,
    > >
    > > These are debug messages from the Analysis ToolPak Addin which the
    > > developers forgot to remove.
    > >
    > > Without gainning accessto the addin code, there is little that you can do
    > > other than delete each time,
    > >
    > >
    > > ---
    > > Regards,
    > > Norman

    >
    >
    >


  8. #8
    Registered User
    Join Date
    02-10-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Cool Re: opening Immediate window

    No need to suffer or uninstall
    1. Close Excel
    2. Backup ATPVBAEN.XLA
    3. Open ATPVBAEN.XLA (Pwd: "Wildebeest!!")
    4. Remove debugging comments from VBA code
    5. Compile and Save
    6. Done

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1