2001-01-09, 19:41 #1
- Join Date
- Dec 2000
- Hollywood (sorta), California, USA
- Thanked 0 Times in 0 Posts
Pause Till Automation Object Exists
Here's another one I asked on the old board but never got that definitive answer:
I'd like to have Word 97 pause while the OLE Excel sheet is open. When the user closes the sheet, Word can proceed to set xlapp = nothing.Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
<img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!