Hi Dave
My routine goes
LPARAMETERS tcFile, tcAction
tcAction='OPEN'
tcFile=upper(alltrim(tcFile))
if !file(tcFile)
=messagebox('Sorry, problem finding the file ',0,'')
else
wait window nowait 'Opening '+tcFile
DECLARE INTEGER ShellExecute ;
IN SHELL32.dll ;
INTEGER nWinHandle,;
STRING cOperation,;
STRING cFileName,;
STRING cParameters,;
STRING cDirectory,;
INTEGER nShowWindow
DECLARE INTEGER FindWindow IN WIN32API STRING cNull,STRING cWinName
RETURN
ShellExecute(FindWindow(0,_SCREEN.caption),tcAction,tcFile,"",SYS(2023),1)
endif
On Fri, Apr 13, 2012 at 10:27 PM, Dave Crozier <[email protected]> wrote:
> 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/cag1nny_hcvcgwqersa1vdfzc9cuysahzxu6b4q7pt85wggx...@mail.gmail.com
** 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.
