Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel sheet within a VFP form
Message
 
To
04/06/2012 15:25:37
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01545120
Message ID:
01545312
Views:
65
>Yuri:
>
>Thanks for the help. It should be very useful for me. I have an additional question that I hope you can help me with.
>thisform.oExcel = CREATEOBJECT("excel.application")
>thisform.oExcel.displayalerts = .F.
>Thisform.oExcelWindowHandle = FindWindowA(NULL, thisform.oExcel.Name)
>
>SetParent(Thisform.oExcelWindowHandle,thisform.HWnd)
>
>Is there any way to have it be part of a Page in a Pageframe object? There's no HWnd property (at least I didn't find one) for either the PageFrame or the Page. Is there any equivalent that I can use?
>
>Thanks again. Your help is always appreciated.
>
>.........Rich

Rich

Probably you can hide/unhide excel window in pageframe page.activate event.
Try to use flags 0x80 to hide, and 0x40 to show, like:
	setWindowPos(Thisform.oExcelWindowHandle,0,0,0,;
			thisform.width,;
			thisform.command1.top,;
			0x80)
Good Luck
Previous
Reply
Map
View

Click here to load this message in the networking platform