Page 1 of 1

Handling Excel from livecode

Posted: Tue Apr 28, 2015 2:50 am
by bergsy
Hi,

I am launching an Excel document from livecode and waiting for it to finish. My Excel workbook has a macro that creates a "finished" file when it is done. My livecode app waits for existence of that file and asks the user every 30 seconds if they still want to wait for it to complete. If they answer "yes" then I would like to bring the Excel window to the front.

Is there any way I can bring another running application to the front using livecode? I want to do this because the user can be doing other things and lose their way

Thanks for any suggestions

Greg

Re: Handling Excel from livecode

Posted: Tue Apr 28, 2015 6:46 pm
by RRobert
Hello,

you can do that via VBScript and use the "do" command to execute the script.

See: https://social.technet.microsoft.com/Fo ... forum=ITCG

Robert

Re: Handling Excel from livecode

Posted: Tue May 19, 2015 5:45 am
by bergsy
Thanks Robert

I ended up changing my VBA to force Excel to front with the code from this link: http://www.excelforum.com/l/732283-asdf.html

Cheers

Greg