Re: Excel Process Not Closed (C++) only after complete Application Shutdown
- From: "Ronald Dodge" <ronald.dodge@xxxxxxxxxx>
- Date: Wed, 1 Aug 2007 07:54:33 -0400
Usually is best to clean up your variables from the smallest (child) objects
to the largest (parent) objects, which Dove indirectly was pointing out.
The other thing, make sure any code in the BeforeSave or BeforeClose events
of the workbook are performing properly, if there is any code in either of
them and if the application's EnableEvent is set to "True" (-1).
Maybe for the programming languages outside of VBA, there's a different set
of methods, properties, and statements available for Excel. I wouldn't know
about that as I haven't programmed with C programming, but yet, I have had
to convert some C programming code to VBA code to get various applications
to be manipulated by VBA within Excel, such as Acrobat Adobe, Lotus Notes,
and IBM Personal Communicator. I am currently in the process of getting my
MCSD cert, which is taking me a while to go through the training material,
though 90% to 95% of the stuff that I have learned is self taught, so many
of the stuff is also review. However, since some of the stuff is geared
towards .NET stuff, that aspect of it is relatively new to me, but still
uses all the same general programming stuff in terms of how you would create
your code even though the syntax is different in many respects and the
object interactions in some cases are different too. But yet, the more
changes that I see, the more of the same I also see. There's one major
thing I don't like about the .NET stuff, though I fully understand their
reasoning for getting rid of it, I still think there's rare occassions of
when it may still be needed. They got rid of the GoTo statement. The
single biggest reason why they got rid of it is simply cause people have
used it in improper ways creating bad programming practices. Now you have
to use the Try...Catch method in it's place.
--
Sincerely,
Ronald R. Dodge, Jr.
Master MOUS 2000
"Kevin" <medicalsounds@xxxxxxxxxxx> wrote in message
news:1185917032.867499.234040@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jul 31, 4:11 pm, "Ronald Dodge" <ronald.do...@xxxxxxxxxx> wrote:
Excel doesn't have a "SetSaved" property, but rather a "Saved" property
on
the workbook. Therefore, the code may be erroring out prior to getting
to
the lines dealing with closing out the workbooks and app, depending on
how
you have the app setup to handle run-time errors.
Thanks for your responce... Yes the function SetSaved is available...
also I changed it as you suggested to Save();
but no luck... process still running...
any other sugestion?
thanks in advance...
-Kevin
.
- Follow-Ups:
- References:
- Prev by Date: RE: I wnat to copy several Worksheets, Several Times...
- Next by Date: Re: Counting visible rows
- Previous by thread: Re: Excel Process Not Closed (C++) only after complete Application Shutdown
- Next by thread: Re: Excel Process Not Closed (C++) only after complete Application Shutdown
- Index(es):