Exit Excel

On Excel if you have the code for Exit as End This does not work
doyledomAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zzzzzoocCommented:
Are you referring to an run-time created object?

Set MyObjectVariable = Nothing

The above should destroy the object and release memory. Replace variable with the one you're using.
0
SteinerCommented:
Are you talking about the "End" in Excel VBA?
This won't close Excel, as it's just supposed to end the VBA-program(!!).
To close Excel from Excel-VBA use Application.Quit.
0
[ fanpages ]IT Services ConsultantCommented:
Further to Steiner's response...


If you have code in VB to create an instance of the MS-Excel object, thus:

  Dim objExcel                                          As Object
 
  Set objExcel = CreateObject("Excel.Application")
 
  objExcel.Visible = True

...

Then you'll need to invoke the .Quit method on the created object to close MS-Excel:
 
  objExcel.Quit
 
  Set objExcel = Nothing

Setting the objExcel object to Nothing releases resources in your local application only.

BFN,

fp.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

doyledomAuthor Commented:
sry i didnt explain myself properly as in exit the program, Quit Excel
0
Steve-HowesCommented:
I think its eitehr Application.Quit or Application.Exit,,, i think its quit
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
[ fanpages ]IT Services ConsultantCommented:
Hi,

I see you accepted Steve-Howes answer, even though Steiner offered the answer prior to this.

BFN,

fp.
0
SteinerCommented:
I'm confused, too. Maybe he did not read the answers posted before your 1st posting??
0
Steve-HowesCommented:
hmmm
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.