FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour abrir excel em janela do fivewin
Posts: 1286
Joined: Mon Feb 25, 2008 02:54 PM

abrir excel em janela do fivewin

Posted: Sat Aug 27, 2016 03:24 AM

Amigos,

é possível abrir uma planilha EXCEL em janela do fivewin?

ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
Posts: 1344
Joined: Wed Nov 16, 2005 09:14 PM

Re: abrir excel em janela do fivewin

Posted: Sat Aug 27, 2016 01:09 PM
Segun este post si http://forums.fivetechsupport.com/viewtopic.php?f=6&t=21028&p=111658&hilit=ABRIR+EXCEL+EN+VENTANA#p111697
oexcelsolver :=CreateObject( "Excel.Application" )
oexcelsolver:Workbooks:Open(clibro)
sysrefresh()
oexcelsolver:Visible(.t.)
hWndexcel := FindWindow(0,"Microsoft Excel - "+cfilenopath(clibro))
SetParent(hwndexcel,oWnd:hWnd)

Con CreateOleObject("Excel.Application") no funcionaban las opciones en las que excel abre un dialogo y se quedaba colgado, entre ellas mis funciones.
Así funciona bien y excel no se sale de la ventana de mi aplicación.
Posts: 1286
Joined: Mon Feb 25, 2008 02:54 PM

Re: abrir excel em janela do fivewin

Posted: Sat Aug 27, 2016 08:45 PM

Gracias por responder, com HARBOUR meu ocorre o erro:

Path and name: C:\fwh1604\samples\b.exe (32 bits)
Size: 3,381,248 bytes
Compiler version: Harbour 3.2.0dev (r1506171039)
FiveWin Version: FWH 16.04
Windows version: 6.1, Build 7601 Service Pack 1

Time from start: 0 hours 0 mins 0 secs
Error occurred at: 08/27/16, 17:44:18
Error description: (DOS Error -2147352559) WINOLE/1007 Argument error: VISIBLE

ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM

Re: abrir excel em janela do fivewin

Posted: Sun Aug 28, 2016 08:45 AM

Inténtalo así:

oexcelsolver:Visible = .t.

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1286
Joined: Mon Feb 25, 2008 02:54 PM

Re: abrir excel em janela do fivewin

Posted: Sun Aug 28, 2016 08:24 PM

Gracias Sr. Antonio. :D

ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin

Continue the discussion