Hiding, moving HWnd created window 2

[Goofus828]

Hi all,

I found this code on the web:

DECLARE INTEGER FindWindow IN user32;
	STRING lpClassName, STRING lpWindowName

= WinExec("C:\Program Files\Microsoft Office\Office12\EXCEL.EXE b:\lora.xls", 1)

* find its hwnd
nHwnd = FindWindow(NULL, "Microsoft Excel")

Excel loads fine with that spreadsheet but...

I don't know how to Hide the window, UnHide the window or close the window.

Any help would be appreciated!

Thanks

 

[Mike Lewis]

Try this:

DECLARE INTEGER ShowWindow IN user32; 
    INTEGER hwnd,; 
    INTEGER nCmdShow

ShowWindow(nHwnd, 0)

To hide the window, pass 0 as the second param to ShowWindow. To make it visible again, pass 1.

To close the window, you could try this, but I'm not sure what the implications would be, for example if the application has unsaved edits:

DECLARE INTEGER DestroyWindow IN user32;
    INTEGER hWnd
DestroyWindow(nHwnd)

Personally, I wouldn't do any of this. I would use Automation if I wanted full control over Excel.

Mike





__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[DSummZZZ]

That's what I was about to say too Mike, I think you would be better off using automation.
Create the Excel object, then you can do whatever you want:

LOCAL oExcel
oExcel = CREATEOBJECT("Excel.Application")
oExcel.VISIBLE = .T. &&... or .F.

... do whatever ...

oExcel.QUIT
oExcel = .NULL.



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[Goofus828]

Thanks Guys, appreciate the solutions and the feedback.

The automation route is looking better and better.

Thanks again.

 

[JRB-Bldr]

While we would be most happy to give you advice on particular Automation issues and you might already be VERY familiar with doing it, you might also like to look at a good reference book about it:

http://www.hentzenwerke.com/catalog/autofox.htm

Good Luck,
JRB-Bldr