Sytze, I assume this is with Windows 7 as I went through similar trials and tribulations. Just check that:
1. Check you haven't started two versions of the process in the Task viewer. 2. Check that the application is open with the same privileges as excel ... i.e not administrator. Called programs (Excel) will open with standard user rights even if called from a "administrator" status program. 3. Are you using CreateObject() or NewObject()? Microsoft Office later than 2007 handles automation in a different way to earlier versions so if your code works on 2003 thyen it won't necessarily work on 2010. 4. More information required on how you call the external app. Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: 13 April 2012 02:30 To: profox Subject: The other program is busy I'm sure this has been discussed....... In my system, I create a XLS file and then my app will open this Instead, the system freezes and a message keeps popping up This action cannot be completed because the other program is busy, Choose switch to......etc You can't minimise the screen to see what's going on (or move your app window. No matter what, you can't do a thing, apart from activate task manager and kill the app. Ahah, NOW you can see Excel with a compatibility checker. Driving me nuts -- Regards Sytze de Boer --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
