FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour switch data between FWH and excel 2007
Posts: 434
Joined: Wed Jun 06, 2007 02:58 PM
switch data between FWH and excel 2007
Posted: Thu Oct 09, 2008 02:06 PM

Hi
any example for problem on subject ?
I have this code:
DEFINE WINDOW m_get[40] // ownd
@ 0, 0 ACTIVEX m_get[41]; // oOWc
PROGID "OWC11.Spreadsheet"
m_get[44] = m_get[41]:GetProp( "ActiveWindow" )
OleSetProperty( m_get[44], "ColumnHeadings", 1, "Descrizione" )
OleSetProperty( m_get[44], "ColumnHeadings", 2, "Vendita Euro" )
OleSetProperty( m_get[44], "ColumnHeadings", 3, "Tot CM" )
OleSetProperty( m_get[44], "ColumnHeadings", 4, "% CM" )
OleSetProperty( m_get[44], "ColumnHeadings", 5, "Tot CU" )
OleSetProperty( m_get[44], "ColumnHeadings", 6, "% CU" )
m_get[42] = m_get[41]:GetProp( "ActiveSheet" ) //hsheet

and worked fine on excel 2003
but if I try that on excel 2007
get window error.
why?

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)

Continue the discussion