+ Reply to Thread
Results 1 to 7 of 7

How to handle error 8007000e Memory Error

  1. #1
    L. A. M.
    Guest

    How to handle error 8007000e Memory Error

    Hi

    When I click on a userform commandbutton for the 2nd time, the following
    error appears:

    Run-time error '-2147024882 (8007000e)Not enough storage is available to
    complete the operation'

    Thanks for suggestions

    Luis



  2. #2
    Tom Ogilvy
    Guest

    Re: How to handle error 8007000e Memory Error

    Has the code terminated from the first time you clicked the button?

    --
    Regards,
    Tom Ogilvy


    "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    news:ePOsJbxeFHA.3040@TK2MSFTNGP14.phx.gbl...
    > Hi
    >
    > When I click on a userform commandbutton for the 2nd time, the following
    > error appears:
    >
    > Run-time error '-2147024882 (8007000e)Not enough storage is available to
    > complete the operation'
    >
    > Thanks for suggestions
    >
    > Luis
    >
    >




  3. #3
    L. A. M.
    Guest

    Re: How to handle error 8007000e Memory Error

    Hi Tom, yeah, the first time that I click the commandbutton everything is ok
    (The first time the procedure is ligthly different to the second time).
    Curiosly, it happens only with the procedure linked to this button.

    Thanks for your help

    Luis


    "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    news:eyPqekxeFHA.2984@TK2MSFTNGP15.phx.gbl...
    > Has the code terminated from the first time you clicked the button?
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > news:ePOsJbxeFHA.3040@TK2MSFTNGP14.phx.gbl...
    >> Hi
    >>
    >> When I click on a userform commandbutton for the 2nd time, the following
    >> error appears:
    >>
    >> Run-time error '-2147024882 (8007000e)Not enough storage is available to
    >> complete the operation'
    >>
    >> Thanks for suggestions
    >>
    >> Luis
    >>
    >>

    >
    >




  4. #4
    Tom Ogilvy
    Guest

    Re: How to handle error 8007000e Memory Error

    If you unload and show the original userform or show another userform and
    that userform shows the original useform perhaps based on a button click,
    then your routine may not have ended as you think it has.

    --
    Regards,
    Tom Ogilvy


    "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    news:e6EPvXzeFHA.1600@tk2msftngp13.phx.gbl...
    > Hi Tom, yeah, the first time that I click the commandbutton everything is

    ok
    > (The first time the procedure is ligthly different to the second time).
    > Curiosly, it happens only with the procedure linked to this button.
    >
    > Thanks for your help
    >
    > Luis
    >
    >
    > "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    > news:eyPqekxeFHA.2984@TK2MSFTNGP15.phx.gbl...
    > > Has the code terminated from the first time you clicked the button?
    > >
    > > --
    > > Regards,
    > > Tom Ogilvy
    > >
    > >
    > > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > > news:ePOsJbxeFHA.3040@TK2MSFTNGP14.phx.gbl...
    > >> Hi
    > >>
    > >> When I click on a userform commandbutton for the 2nd time, the

    following
    > >> error appears:
    > >>
    > >> Run-time error '-2147024882 (8007000e)Not enough storage is available

    to
    > >> complete the operation'
    > >>
    > >> Thanks for suggestions
    > >>
    > >> Luis
    > >>
    > >>

    > >
    > >

    >
    >




  5. #5
    L. A. M.
    Guest

    Re: How to handle error 8007000e Memory Error

    Hello Tom, the commandbutton doesn't show any aditional userform. Only it
    execute a VBA procedure opnening other workbooks.

    Luis

    "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    news:OwjtdyzeFHA.2888@TK2MSFTNGP15.phx.gbl...
    > If you unload and show the original userform or show another userform and
    > that userform shows the original useform perhaps based on a button click,
    > then your routine may not have ended as you think it has.
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > news:e6EPvXzeFHA.1600@tk2msftngp13.phx.gbl...
    >> Hi Tom, yeah, the first time that I click the commandbutton everything is

    > ok
    >> (The first time the procedure is ligthly different to the second time).
    >> Curiosly, it happens only with the procedure linked to this button.
    >>
    >> Thanks for your help
    >>
    >> Luis
    >>
    >>
    >> "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    >> news:eyPqekxeFHA.2984@TK2MSFTNGP15.phx.gbl...
    >> > Has the code terminated from the first time you clicked the button?
    >> >
    >> > --
    >> > Regards,
    >> > Tom Ogilvy
    >> >
    >> >
    >> > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    >> > news:ePOsJbxeFHA.3040@TK2MSFTNGP14.phx.gbl...
    >> >> Hi
    >> >>
    >> >> When I click on a userform commandbutton for the 2nd time, the

    > following
    >> >> error appears:
    >> >>
    >> >> Run-time error '-2147024882 (8007000e)Not enough storage is available

    > to
    >> >> complete the operation'
    >> >>
    >> >> Thanks for suggestions
    >> >>
    >> >> Luis
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >




  6. #6
    Tom Ogilvy
    Guest

    Re: How to handle error 8007000e Memory Error

    Not sure what to tell you then. Maybe you need to close them after you use
    them.

    Make sure any sheets have their zoom levels set to 100% can sometimes help.

    --
    Regards,
    Tom Ogilvy


    "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    news:%23xs1N60eFHA.900@TK2MSFTNGP10.phx.gbl...
    > Hello Tom, the commandbutton doesn't show any aditional userform. Only it
    > execute a VBA procedure opnening other workbooks.
    >
    > Luis
    >
    > "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    > news:OwjtdyzeFHA.2888@TK2MSFTNGP15.phx.gbl...
    > > If you unload and show the original userform or show another userform

    and
    > > that userform shows the original useform perhaps based on a button

    click,
    > > then your routine may not have ended as you think it has.
    > >
    > > --
    > > Regards,
    > > Tom Ogilvy
    > >
    > >
    > > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > > news:e6EPvXzeFHA.1600@tk2msftngp13.phx.gbl...
    > >> Hi Tom, yeah, the first time that I click the commandbutton everything

    is
    > > ok
    > >> (The first time the procedure is ligthly different to the second time).
    > >> Curiosly, it happens only with the procedure linked to this button.
    > >>
    > >> Thanks for your help
    > >>
    > >> Luis
    > >>
    > >>
    > >> "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    > >> news:eyPqekxeFHA.2984@TK2MSFTNGP15.phx.gbl...
    > >> > Has the code terminated from the first time you clicked the button?
    > >> >
    > >> > --
    > >> > Regards,
    > >> > Tom Ogilvy
    > >> >
    > >> >
    > >> > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > >> > news:ePOsJbxeFHA.3040@TK2MSFTNGP14.phx.gbl...
    > >> >> Hi
    > >> >>
    > >> >> When I click on a userform commandbutton for the 2nd time, the

    > > following
    > >> >> error appears:
    > >> >>
    > >> >> Run-time error '-2147024882 (8007000e)Not enough storage is

    available
    > > to
    > >> >> complete the operation'
    > >> >>
    > >> >> Thanks for suggestions
    > >> >>
    > >> >> Luis
    > >> >>
    > >> >>
    > >> >
    > >> >
    > >>
    > >>

    > >
    > >

    >
    >




  7. #7
    Luis
    Guest

    Re: How to handle error 8007000e Memory Error

    There's no any information in MSKnowledgeBase about this error occurred
    specificly in Excel. The solution is to include a procedure that unload a
    load the userform, each time you click on it.

    Luis

    "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    news:u8z8LF1eFHA.1680@TK2MSFTNGP09.phx.gbl...
    > Not sure what to tell you then. Maybe you need to close them after you

    use
    > them.
    >
    > Make sure any sheets have their zoom levels set to 100% can sometimes

    help.
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > news:%23xs1N60eFHA.900@TK2MSFTNGP10.phx.gbl...
    > > Hello Tom, the commandbutton doesn't show any aditional userform. Only

    it
    > > execute a VBA procedure opnening other workbooks.
    > >
    > > Luis
    > >
    > > "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    > > news:OwjtdyzeFHA.2888@TK2MSFTNGP15.phx.gbl...
    > > > If you unload and show the original userform or show another userform

    > and
    > > > that userform shows the original useform perhaps based on a button

    > click,
    > > > then your routine may not have ended as you think it has.
    > > >
    > > > --
    > > > Regards,
    > > > Tom Ogilvy
    > > >
    > > >
    > > > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > > > news:e6EPvXzeFHA.1600@tk2msftngp13.phx.gbl...
    > > >> Hi Tom, yeah, the first time that I click the commandbutton

    everything
    > is
    > > > ok
    > > >> (The first time the procedure is ligthly different to the second

    time).
    > > >> Curiosly, it happens only with the procedure linked to this button.
    > > >>
    > > >> Thanks for your help
    > > >>
    > > >> Luis
    > > >>
    > > >>
    > > >> "Tom Ogilvy" <twogilvy@msn.com> escribió en el mensaje
    > > >> news:eyPqekxeFHA.2984@TK2MSFTNGP15.phx.gbl...
    > > >> > Has the code terminated from the first time you clicked the button?
    > > >> >
    > > >> > --
    > > >> > Regards,
    > > >> > Tom Ogilvy
    > > >> >
    > > >> >
    > > >> > "L. A. M." <luism0(arroba)yahoo.es> wrote in message
    > > >> > news:ePOsJbxeFHA.3040@TK2MSFTNGP14.phx.gbl...
    > > >> >> Hi
    > > >> >>
    > > >> >> When I click on a userform commandbutton for the 2nd time, the
    > > > following
    > > >> >> error appears:
    > > >> >>
    > > >> >> Run-time error '-2147024882 (8007000e)Not enough storage is

    > available
    > > > to
    > > >> >> complete the operation'
    > > >> >>
    > > >> >> Thanks for suggestions
    > > >> >>
    > > >> >> Luis
    > > >> >>
    > > >> >>
    > > >> >
    > > >> >
    > > >>
    > > >>
    > > >
    > > >

    > >
    > >

    >
    >




+ 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