vb / excel

Jenny · Joined: 04 Oct 2007 Posts: 1

I have an application that read a excel sheet and its open the sheet. The
next code line show how I open the the application,

Set appexcel = CreateObject("Excel.Application")

and there is the code that the application use to close the application
excel.

Set appexcel = Nothing

but I have problem to close the application because its remains in the
memory.
I need close the application excel of the memory.

Any help would be welcome.

Jenny

Archived from group: microsoft>public>vb>enterprise

Steven Burn · Joined: 04 Oct 2007 Posts: 12

Replace

Set appexcel = Nothing

with

appexcel.Close
appexcel.Quit

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk
Jenny wrote in message#cDHA.2860@TK2MSFTNGP11.phx.gbl...
> I have an application that read a excel sheet and its open the sheet. The
> next code line show how I open the the application,
>
> Set appexcel = CreateObject("Excel.Application")
>
> and there is the code that the application use to close the application
> excel.
>
> Set appexcel = Nothing
>
> but I have problem to close the application because its remains in the
> memory.
> I need close the application excel of the memory.
>
> Any help would be welcome.
>
> Jenny
>
>

Ben Taylor · Joined: 04 Oct 2007 Posts: 67

What gives you the delusion that Excel's application
object has a close method, and what gives you the delusion
that you're so good that you don't need to test your
answers?

>-----Original Message-----
> Replace
>
> Set appexcel = Nothing
>
>with
>
> appexcel.Close
OBJECT DOESN'T SUPPORT THIS PROPERTY OR METHOD!!!!

> appexcel.Quit
>
>--
>Regards
>
>Steven Burn
>Ur I.T. Mate Group CEO
>www.it-mate.co.uk
>Jenny wrote in message
>#cDHA.2860@TK2MSFTNGP11.phx.gbl...
>> I have an application that read a excel sheet and its
open the sheet. The
>> next code line show how I open the the application,
>>
>> Set appexcel = CreateObject("Excel.Application")
>>
>> and there is the code that the application use to close
the application
>> excel.
>>
>> Set appexcel = Nothing
>>
>> but I have problem to close the application because
its remains in the
>> memory.
>> I need close the application excel of the memory.
>>
>> Any help would be welcome.
>>
>> Jenny
>>
>>
>
>
>.
>

Steven Burn · Joined: 04 Oct 2007 Posts: 12

I use the one's I've posted above in one of my own programs, and it works
just fine.

Never once have I claimed to be good though?

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk
Ben Taylor wrote in message$0b796560$a601280a@phx.gbl...
> What gives you the delusion that Excel's application
> object has a close method, and what gives you the delusion
> that you're so good that you don't need to test your
> answers?
>
> >-----Original Message-----
> > Replace
> >
> > Set appexcel = Nothing
> >
> >with
> >
> > appexcel.Close
> OBJECT DOESN'T SUPPORT THIS PROPERTY OR METHOD!!!!
>
>
> > appexcel.Quit
> >
> >--
> >Regards
> >
> >Steven Burn
> >Ur I.T. Mate Group CEO
> >www.it-mate.co.uk
> >Jenny wrote in message
> >#cDHA.2860@TK2MSFTNGP11.phx.gbl...
> >> I have an application that read a excel sheet and its
> open the sheet. The
> >> next code line show how I open the the application,
> >>
> >> Set appexcel = CreateObject("Excel.Application")
> >>
> >> and there is the code that the application use to close
> the application
> >> excel.
> >>
> >> Set appexcel = Nothing
> >>
> >> but I have problem to close the application because
> its remains in the
> >> memory.
> >> I need close the application excel of the memory.
> >>
> >> Any help would be welcome.
> >>
> >> Jenny
> >>
> >>
> >
> >
> >.
> >

Steven Burn · Joined: 04 Oct 2007 Posts: 12

My apologies for the typo (just realised what I've posted).....

appexcel.Close should be

appexcelwb.close '(wb for the workbook)

Oh well, mistakes will happen.......

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk

Ben Taylor wrote in message$0b796560$a601280a@phx.gbl...
> What gives you the delusion that Excel's application
> object has a close method, and what gives you the delusion
> that you're so good that you don't need to test your
> answers?
>
> >-----Original Message-----
> > Replace
> >
> > Set appexcel = Nothing
> >
> >with
> >
> > appexcel.Close
> OBJECT DOESN'T SUPPORT THIS PROPERTY OR METHOD!!!!
>
>
> > appexcel.Quit
> >
> >--
> >Regards
> >
> >Steven Burn
> >Ur I.T. Mate Group CEO
> >www.it-mate.co.uk
> >Jenny wrote in message
> >#cDHA.2860@TK2MSFTNGP11.phx.gbl...
> >> I have an application that read a excel sheet and its
> open the sheet. The
> >> next code line show how I open the the application,
> >>
> >> Set appexcel = CreateObject("Excel.Application")
> >>
> >> and there is the code that the application use to close
> the application
> >> excel.
> >>
> >> Set appexcel = Nothing
> >>
> >> but I have problem to close the application because
> its remains in the
> >> memory.
> >> I need close the application excel of the memory.
> >>
> >> Any help would be welcome.
> >>
> >> Jenny
> >>
> >>
> >
> >
> >.
> >

Ben Taylor · Joined: 04 Oct 2007 Posts: 67

>-----Original Message-----
>I use the one's I've posted above in one of my own
programs, and it works
>just fine.

Either you're using an ultra-spaceage 2003 version or you
must have on error resume next on, because Excel 2000's
application object doesn't have a close method. What would
be the point of it, what would it do?

>
>Never once have I claimed to be good though?

No - neither have I Steven, and I don't see why we should
need to. Sorry for the flame, no offence intended. It's
just I get flamed, talked down to and patronised by all
the pompous MVPs and the readers who consider
themselves 'the elite' (yes, Larry, Rick, Jeff, Bob - I DO
mean you) - when I get the slightest little technical
detail wrong, so I guess I just felt like wielding my own
muscle. I guess that's what persecution does to you. I
don't know why it has to be like that - I can't see why
this can't be a forum where all are equal and all ideas
and answers are treated with the same respect and
validity, but there you go. I don't accept this hostility -
so I've developed a series of aliases with which I point
out that these people AREN'T the elite, and that they have
no right to laugh at or shoot down the replies of people
who may be learning but still want to contribute and have
a valid point to make - and the more they do it the more I
use my aliases to flame them. I used to do so using my own
name, but someone pointed out that my 'reputation'
(whatever that might be good for) would be at stake, so
why bother? That said, other people do do the same as me,
so you shouldn't assume just becuase a 'rebellious'
message is there that it's one of my aliases. Maybe I'm
just an oversensitive twat, but that's just how some of
the messages make me feel sometimes.
My apologies.

>
>--
>Regards
>
>Steven Burn
>Ur I.T. Mate Group CEO
>www.it-mate.co.uk
>Ben Taylor wrote in message
>$0b796560$a601280a@phx.gbl...
>> What gives you the delusion that Excel's application
>> object has a close method, and what gives you the
delusion
>> that you're so good that you don't need to test your
>> answers?
>>
>> >-----Original Message-----
>> > Replace
>> >
>> > Set appexcel = Nothing
>> >
>> >with
>> >
>> > appexcel.Close
>> OBJECT DOESN'T SUPPORT THIS PROPERTY OR METHOD!!!!
>>
>>
>> > appexcel.Quit
>> >
>> >--
>> >Regards
>> >
>> >Steven Burn
>> >Ur I.T. Mate Group CEO
>> >www.it-mate.co.uk
>> >Jenny wrote in message
>> >#cDHA.2860@TK2MSFTNGP11.phx.gbl...
>> >> I have an application that read a excel sheet and its
>> open the sheet. The
>> >> next code line show how I open the the application,
>> >>
>> >> Set appexcel = CreateObject("Excel.Application")
>> >>
>> >> and there is the code that the application use to
close
>> the application
>> >> excel.
>> >>
>> >> Set appexcel = Nothing
>> >>
>> >> but I have problem to close the application because
>> its remains in the
>> >> memory.
>> >> I need close the application excel of the memory.
>> >>
>> >> Any help would be welcome.
>> >>
>> >> Jenny
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>