Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Automation stumble - Got it!!

G'day there Bob, and whoever else was following this thread.

After being able to sit and play with it for awhile away from
being dragged about Xmas shopping and trying to mow the lawns between
thunderstorms I think I've found & fixed the problem.

It was largely a result of me trying to rush things so that I
could mow the lawns as opportunity offered, and go Xmas shopping (under
extreme duress I might add!!)

I found that when the code finished and I'd shut the spreadsheet
window there were still instances of Excel running. A bit of observation
while running the code with the task manager open & I found it wasn't
shutting Excel down. I then added extra lines, and rearranged others so
that items lower in the XL object heirarchy were released first. I.e.
range objects, then worksheet objects, then workbook objects, and
finally the application object - something that should have been obvious
if I'd not been thinking of how much I hate Xmas shopping.

Lo, and behold, at the end of the Word code there were no Excel
instances left active and when next run it all went smoothly and could
be run again & again without the symptoms described. At lease, it's done
that 4 times so far. I'm hoping that's the usual behaviour.

Thanks for looking at it for me, but I think we can now return to
normal programming ...chucklechucklechuckle. What a sense of
humour!!!! <g

Thanks once again,
Take care,
Happy Yule
See ya
Ken McLennan
Qld, Australia

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automation Sherees Excel Discussion (Misc queries) 4 December 11th 09 09:59 PM
Supressing the ctrl-c and other keys during word automation in automation apondu Excel Programming 0 July 19th 07 10:10 PM
Automation Chris Excel Programming 1 March 8th 05 06:55 PM
Automation Chris Excel Programming 1 March 8th 05 06:45 PM
about OLE automation keyur Excel Programming 0 April 5th 04 02:54 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"