Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I Open Excel and Keep VFP in Focus?
Message
 
To
27/10/2006 15:06:44
Joel Whitehead
Ccs Central Computer Services Inc.
Thunder Bay, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01165147
Message ID:
01165157
Views:
13
>I have a program that opens an Excel spreadsheet and reads some data from it. I know I can keep the instance of Excel invisible, but I would actually like to keep it visible. However, once I set Excel as visible, it gets focus. I can't figure out how to get back to VFP (apart from manually clicking on VFP on the task bar). Is there a way to programmatically force focus back to my VFP application?
>
>Joel

Try:
DECLARE INTEGER SetForegroundWindow IN WIN32API INTEGER

oExcel = CREATEOBJECT([Excel.Application])
oExcel.Visible = .t.
SetForegroundWindow(_screen.HWnd)
WAIT WINDOW [aaa]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform